Skip to main content
Nintex Community Menu Bar

What pattern can I use to replace apostrophes within text with an *

  • July 20, 2017
  • 5 replies
  • 10 views

Forum|alt.badge.img+1

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? 

5 replies

Forum|alt.badge.img+14
  • Scholar
  • July 20, 2017

that one is quite easy, you do not need any special consideration laugh.png

just use single apostrophe as a pattern and asterix  as a replacement character

205784_pastedImage_2.png


Forum|alt.badge.img+1
  • Author
  • July 20, 2017

Thank you it worked.  I was making it more complicated than it was.


Forum|alt.badge.img+14
  • Scholar
  • July 21, 2017

Great!

Please mark correct answer


Forum|alt.badge.img+14
  • Scholar
  • July 24, 2017

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.


Forum|alt.badge.img+14
  • Scholar
  • July 26, 2017

Hi, ‌, one more attempt....

correct answer should be the post that answers original question. that's the purpose of it.

so I'd ask you to mark my above first post.