Skip to main content
Nintex Community Menu Bar

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

  • Jul 20, 2017 5:13 PM UTC
  • 5 replies
  • 32 views
  • Translate All

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
  • Jul 20, 2017 7:35 PM UTC

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

Translate

Forum|alt.badge.img+1
  • Author
  • Jul 20, 2017 8:32 PM UTC

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

Translate

Forum|alt.badge.img+14
  • Scholar
  • Jul 21, 2017 6:06 AM UTC

Great!

Please mark correct answer

Translate

Forum|alt.badge.img+14
  • Scholar
  • Jul 24, 2017 8:53 AM UTC

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.

Translate

Forum|alt.badge.img+14
  • Scholar
  • Jul 26, 2017 7:20 AM UTC

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.

Translate