replace([SONAR_DEF], 'rev.','')
This only removed the "rev" portion. I was looking more to remove the entire rev.XX wording.
Hello @bliffick ,
For that, you may use a simple regex expression.
rev.\d{3}
It removes any 3 digits coming after rev.
Gabriel
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.
@bliffick Check out the workflow I have attached.
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