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.
Solved! Go to Solution.
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'.