Hi everyone I have a fairly simple question but I just can't figure it out. Basically I have a list with a column called Serial Number. Typicallly it's an alphanumeric 14 digit number. they all start with S. I would like to use Regular expression to remove that S. So for example STH9FT5HWWNM7 would ideally be turned into TH9FT5HWWNM7 any help would be greatly appreciated.
Thank you
Does this work?
............($'*)
Basically working backwards to grab everything except the first character.
You can directly use 'fn-Replace' function in 'Build String' action.
or use 'Replace' option in 'Regular Expression' action with below formula.
And also, if you know the starting letter is always 'S' then directly you can use replacement text as 'S'.
And thank you Lakshmi both actually worked I used the second recommendation. Thanks to you both!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.