+8Hi 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
+5Does this work?
............($'*)
Basically working backwards to grab everything except the first character.
+9You 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'.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
