Hi All,
I hope everyone is having a nice Friday.
I'm currently having a bit of a problem that maybe someone could maybe help me solve. I have data like so that's very messy:
Description |
TS: Entry1 |
TS :Entry2 |
TS:Entry3 |
TS Project Work |
what I need to do is extract just the letters TS from the data into a new column i've tried a few approaches but sadly no dice yet.
any help would be much appreciated.
Solved! Go to Solution.
Try this:
((?i)^TS)
Hi,
I would recommend the following:
1) Use a Text to Parse on : as the delimitator. Your 'TS' will be in the first column.
Thanks,
Amy
If they're all on the LEFT, you can also use:
LEFT([Data],2)
Try both and see which one is better.
If it helps, kindly like & mark it as an accepted solution to help others & to close this thread accordingly.
Thanks.
Hi @Deano478
Please use the Regex tool.
Regular expression:
(TS)
Output method:
Parse
Many thanks
Shanker V
Or simply use a formula tool with Replace(Left([Description],2),"TS","")
Edit: that would also remove words with TS together after. This would work though
IF Left([Description],2)="TS"
THEN Substring([Description],2,Length([Description]))
ELSE [Description]
ENDIF
So many ways of solving - that's the beauty of Alteryx! Thanks for sharing @ShankerV @jdminton @Amy_smart !
Wow @caltang @jdminton @ShankerV @Amy_smart I appreciate you all taking the time to look at this issue I was having I tried each solution offered and they all worked so I;m going to mark you all solved