How to get substring starting and ending with different characters

Article not needed anymore

Can you try using the below regex: use the isMatches activity

(\X&FI.*?\()

1 Like

Thank you!

Let me know if it works.

not needed anymore

not needed anymore

So if your 1st array is:
KH13
KR13
KR14
MY15

Then you can loop for each of the above, then loop for each in the below 2nd array:
X&FI_XXXX_SSCRTRAGENT_FA
X&FI_XXXX_SSCRTRAGENT_GL
X&FI_XXXX_SSCRTRAGENT_CI

and use replace XXXX with item from 1st array and then get the result into a datatable
this way your result dt will have 12 items.
Result you can write into a csv or excel
extractandappend.xaml (12.3 KB)

image

1 Like

Did it work for you?

not needed anymore

1 Like

Well its about the selectors. Thats all i can say.
All the best making that solution :slight_smile:

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.