Finding prefix of a string

[JotaPey]

I have a DTI in which I want to search a column for a string with a specific prefix.  The column contains strings of 25 characters each with a unique 3 letter prefix.  How can I perform a search returning a match for a given  prefix?  In other words, I want to return the  string with prefix "ABC".  Thanks in advance!

[ORSO2001]

Hi JotaPey,

have you tried the Find Substring function block?....field A the string where you want navigate; field B the substring to search; field C the starting point to search in the main string; field D the result....for this last a positive result means that the substring was found....negative result means that the primary string doesn't contain the secondary string...you can navigate in your DTI until find what you want.