Remove specific text from an output

Hello,

I am new to Alteryx and learning the ropes. I am trying to remove specific wording in a Column. The wording changes as this is a large data set. I currently my the below formula, but wanted to know is there a wildcard that I can use?

Alteryx Snip.png

Trim([SONAR_DEF],"rev.")

Input

Output

Accepted answers

All comments

MilindG

bliffick

replace([SONAR_DEF], 'rev.','')

This only removed the "rev" portion. I was looking more to remove the entire rev.XX wording.

Garabujo7

Hello @bliffick ,

For that, you may use a simple regex expression.

rev.\d{3}

It removes any 3 digits coming after rev.

Gabriel

bliffick

unfortunately that did not work Either. Is there a wildcard that we can place to cover the various Versions?

Example

Rev.011

Rev.,001

Rev.010

Ultimately I am just wanting the date left over.

MilindG

Okay I have attached a workflow that has couple different ways. See if that works.

sample_replace.yxmd

MilindG

@bliffick Check out the workflow I have attached.

bliffick

I appreciate everyones responses, I found a way to do it outside of Formulas. In the wanted field I changed the View to Date. This removed the REV.XXX

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703