Solved! Go to Solution.
It might be easiest to use the text to columns tool instead with | as the delimiter
Hi Brandon,
First off, I am thank full for the quick support and you time.
I've just added the example image which may explain my predicament. If I use text to columns, it will also do the same for any other data before or after the | separator. If there is a way I can only extract the data before/after this one unique separator, that would be perfect. If there is another approach I can try, please feel free to suggest anything.
The Text to Columns tool can use multiple delimiters, like "|" and ",". Since the arguements are all word characters (a-zA-Z_0-9), then the RegEx tool can Tokenize (split to columns) using the expression "\w+".
Check out the attached workflow for an example of both methods.
Hi Charlie,
Thank you for the response. Both solutions will work.
"extract the data before/after | " : why FA15 in first row not included in perfect scenario ?
Hi Benakesh,
That was my ideal solution where I dont have to use text to column to split both , and | in to columns but only get the single data that is before or after the | extracted to the separate column. Hope that makes sense.
With the solution's provided however, I will get all the words split in to columns and using a formula to remove those unwanted splits to blank fields so in the end I have only the data I needs as above.