How to insert a symbol in a string

Hi there,
I would like to insert ’ each 3 numbers such as:

123456 —> 123’456

Thank you very much for help.

Andrea

Hi @ANDREACAGNAZZI,

I’d suggest you use the String Replacer with the following RegEx: ^(\d{3})(\d{3})$

and insert the replacement as $1’$2. Please ensure you tick the checkbox to replace the whole string.

Cheers
Mike

1 Like

Hi @ANDREACAGNAZZI,

I would suggest using the String Manipulation node with this expression:
reverse(regexReplace(reverse($column1$), "(\\d{3}+)(?!$)", "$1'"))

a1

:blush:

2 Likes

This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.