Remove specific text from an output

[bliffick]

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?  

 

Trim([SONAR_DEF],"rev.")

[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.

[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