cancel
Showing results for 
Search instead for 
Did you mean: 
Workflow Hero

Removing first character using Regex

Jump to solution

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

Labels: (1)
Tags (1)
0 Kudos
Reply
3 Replies
Workflow Hero

Re: Removing first character using Regex

Jump to solution

Does this work?

............($'*)

Basically working backwards to grab everything except the first character.

0 Kudos
Reply
Highlighted
Workflow Hero

Re: Removing first character using Regex

Jump 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'.

 

0 Kudos
Reply
Workflow Hero

Re: Removing first character using Regex

Jump to solution

And thank you Lakshmi both actually worked I used the second recommendation. Thanks to you both!

0 Kudos
Reply