Removing only first character that appear multiple times in a string

Aminmin

Hi there, I am trying to remove the FIRST apostrophe in a string. There are also data that has apostrophe in the middle of the string which i do not want to remove eg. in '1234 output should be 1234. In '12'34 the 2nd ' should remain, output should be 12'34. Using Prepare, Replace ' --> No value will also replace the ' that is not the first character. Pls advise what I should do. Thank you

Alexandru

Hi @Aminmin
,

If you use the existing Replace processor in the prepare recipe with a small modification e.g

Use Regular Expression matching mode and provide the correct regex: ^'

^ is simply the "start of string" in regex :

Let me know if this is what you were looking for.

Aminmin

Hi AlexT, greatly appreciate your kind reply. I believe this works for me. Thanks!!