Parsing out only certain letters

[Deano478]

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.

[caltang · Accepted solution]

Try this:

((?i)^TS)

[Amy_smart · Accepted solution]

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 solution]

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 solution]

Hi @Deano478 

Please use the Regex tool.

Regular expression:

(TS)

Output method: 

Parse

Many thanks

Shanker V

[jdminton · Accepted solution]

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 solution]

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

[Deano478]

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