How I pick up a group of word from a large string which is got by scanning a QR code

The QR code is a combination of a large information like age, name, Id, location,. I need only id ,
will there work text function of excel?

Welcome to the community, @Hasibul_E! Have you gone through our previously discussed post? It should help you solve your issue:

Thank you very much for your response. I have got the solution by studying ODK string function. it looks like javascript function. I used strslice(${bar_c},12,25) … it provide the output to characters between 12 and 25. that was my need.
Thanks a lot

1 Like

@Hasibul_E, was curious to know more about strslice function. Or is it the substr function you used as outlined in the post discussed previously: