How to insert a symbol in a string

ANDREACAGNAZZI · November 4, 2019, 6:22pm

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

123456 —> 123’456

Thank you very much for help.

Andrea

mwiegand · November 4, 2019, 6:45pm

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

armingrudd · November 5, 2019, 8:11am

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

system · May 5, 2020, 8:11pm

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