Parsing out only certain letters

Question

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:

DescriptionTS: Entry1TS :Entry2TS:Entry3TS 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.

caltang · Accepted Answer

Try this:

((?i)^TS)

Amy_smart · Accepted Answer

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

caltang · Accepted Answer

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.

ShankerV · Accepted Answer

Hi @Deano478

Please use the Regex tool.

Regular expression:

(TS)

Output method:

Parse

Many thanks

Shanker V

jdminton · Accepted Answer

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

caltang · Accepted Answer

So many ways of solving - that's the beauty of Alteryx! Thanks for sharing @ShankerV @jdminton @Amy_smart !