Page 1 of 1

Search and Split String

Posted: Mon Jul 27, 2020 12:52 am
by Alan_37
Hi,

Some time ago I made this simple but very powerful Macro thought would be nice to share with the community.
Maybe someone could make a Component out of it I use this almost all the time.

The Macro takes an input string and another 2 search strings, It Searches for a specific word or letter in the input string
and outputs the following:

If used with only one Search String
input 1.png
input 1.png (78.2 KiB) Viewed 4041 times
SSS_Out_Str_AM_EM ( String After match but excluding match )
SSS_Out_Str_AM_IM ( String After match Including match )
SSS_Out_Str_BM ( String Before match )
SSS_Match_Found ( if match found =1 )



IF used with 2 Search Strings
input2.png
input2.png (91.81 KiB) Viewed 4041 times
SSS_Out_Str_AM_EM ( NOT USED )
SSS_Out_Str_AM_IM ( the second Search String )
SSS_Out_Str_BM ( String BETWEEN the 2 Search Strings )
SSS_Match_Found ( if match found =2 )


Made this on V7 but should also work on V8 enjoy!

Re: Search and Split String

Posted: Mon Jul 27, 2020 10:42 am
by Steve
Nice one, Alan. Thanks for sharing!