I have a SQL execute statement within my workflow, I am needing to add a regular expression that replaces apostrophes within text with an * before executing to SQL. What pattern can I use to perform the replace of an ' with * using the regular expression before the execute statement?
that one is quite easy, you do not need any special consideration
just use single apostrophe as a pattern and asterix as a replacement character
Thank you it worked. I was making it more complicated than it was.
Great!
Please mark correct answer
Hi, Gaby Frayjo, marking a post just helpful is a way how to promote usefull posts, however, marking an answer correct is highly recommended and much more effective, since correct answer is shown at the top of page right after the question. so everyone can immediately see question and anser together.
have a look on 's reasoning why marking answers correct is usefull
so I would still encourage you marking a correct answer.
thanks.
Reply
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.