Regex replace only the 1st character

[terrellchong]

Hi, let say I have a value that is like this

-112324-A

How do I use Regex replace to make the result look like this?

112324-A

Thanks in advance

[atcodedog05 · Accepted solution]

Hi @terrellchong 

Regex formula would be

REGEX_Replace([Field1], ".(.*)", "$1")

Workflow:

Hope this helps : )

[atcodedog05]

Hi @terrellchong 

You can also do it without regex. The below method might give better performance.

Workflow:

Hope this helps : )

[OllieClarke]

Hi @terrellchong just adding other options to the two which @atcodedog05 has given, but you can use the substring function here as well

Substring([field],1)

edit: I did a performance comparison of the 3 methods, and I would avoid using RegEx here, but there isn't much between using Substring() and Right()

[atcodedog05]

@OllieClarke 

yup, I keep tending to forget Substring() function should start using it more 😅