Divide Column based on InString Character

[ryanrabo22]

Hello,
I have a column with data coming in this format "ABC:123". I am wondering if there is a way or function that can find the ":" character, such as InStr, and then give me the value to the Left without the ":". I need my final output from "ABC:123" to be "ABC". The lengths of "ABC" and "123" within the column are variable. I have looked through the functions in the transformer stage, but I cannot think of a solution using the functions available. Any help would be greatly appreciated!


Thanks,
Ryan

[vinothkumar]

Check FIELD function.. It can fulfil your requirement.

[ray.wurlod]

Code: Select all

Field(InLink.TheString, ":", 1, 1)