How to get substring starting and ending with different characters

Help
#1

Article not needed anymore

#2

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

(\X&FI.*?\()

image
image890×326 10.4 KB

1 Like
#3

Thank you!

#4

Let me know if it works.

#5

not needed anymore

#6

not needed anymore

#7

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
#8

Did it work for you?

#9

not needed anymore

1 Like
#10

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

#11

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