Acronyms in cells

[jenettd]

Is there a way to pick out the spelled-out version of acronyms in a cell?

For instance, the below sentences are in one cell.

'Bob is a great salesman because he Always Be Closing (ABC). He has a brilliant future in sales.'

I would need Alteryx to see that 'Always Be Closing' is spelled out for the acronym 'ABC'. The acronyms will always be in parentheses and the spelled-out version should always precede the acronym in parentheses.

Thanks!

[OTrieger]

@jenettd 
Will the spelled out will always start with Capital Letter?

[jenettd]

Yes, the spelled out will always start with a capital letter.

[OTrieger · Accepted solution]

@jenettd 
\u\l+\s\u\l+\s.*\s\(\<\w+\>\)

This will give you the spell out and acronym, then you can get rid of the acronym

[OTrieger · Accepted solution]

(\u\l+\s\u\l+\s.*)\s\(\<\w+\>\)

Without the acronym

[OTrieger · Accepted solution]

When using parenthesis you can define what you would like to be tokenize our of the whole code 

[jenettd]

Thank you. Would I put this formula in the Regex parse tool?

[OTrieger]

yes

[jenettd]

This worked great; however, I noticed it isn't working where the acronyms have 2 characters, such as Accounting Unit (AU). It worked great on the 3-character acronyms but the 2 character ones aren't pulling. Would you mind incorporating the fix for 2 character acronyms as well? If the formula is separate from the 3 character one, that's fine too. I appreciate your help. 

[OTrieger]

@jenettd 
Ok I deleted one \s, which indicating space

(\u\l+\s\u\l+\s.*)\(\<\w+\>\)

The reason that it did not work was that if there are only 2 Words then it was looking for \s\s, double space. Is it possible to have an Acronym of one word?