Divide Column based on InString Character
Posted: Wed Dec 22, 2010 1:09 pm
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
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