Forum Discussion

Adagio's avatar
Adagio
Frequent Contributor
7 years ago
Solved

How to extract a string from between 2 other repeating strings

Hi,   This problem has been bothering me for sometime now. Could someone please help?   As shown in the snapshot below, I have to extract 0028441622 from this text on the picture. I'm able to rea...
  • karkadil's avatar
    karkadil
    7 years ago

    Such tasks can usually be easy solved with the help of replace/split/join methods.

    Here is your specific task solved in JScript:

    var s = 'SOME TEXT\nItem Description:\nSOME OTHER TEXT\nINT:SOME TEXT AGAIN\niLPN:\n0028441622\niLPN:SOME TEXT AT THE END';
  
var iLPN = s.replace('\n', '').split('iLPN:')[1];
Log.Message(iLPN);
tristaanogre's avatar
tristaanogre
Esteemed Contributor

Question:

 

When you examine that form, do each of the text labels identify as their own?  '

 

That said, what Marsha_R suggests is the best way that I now how.  Use the aqString object and the "Find" method to find the string starting at a location and having a particular length.

Adagio's avatar
Adagio
Frequent Contributor
7 years ago

Hello Robert,

 

The content on that page might change(i.e. size of the string) as well as the string that I'm trying to extract. I can read the whole content as it's one panel.

The easier option I thought would be to fetch a string that's present between LPN and iLPN. is there any way do do this even by using regex ?

 

Thank you

abhi