Sign up to take part
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
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
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.
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.
Hi AlexT, greatly appreciate your kind reply. I believe this works for me. Thanks!!