String Quoting (it's not duplicating inner quotes)

Automise Bugs
1

  I think this action should duplicate inner quotes found in the string, just like Delphi's QuoteStr function does. Before I have realized this action existence I used scripts to replace a variable contents quotes for two quotes and concat one quote at the beginning and another at the end to use this in a insert ADO Execute Query. Now I'm using three actions String Replace (changing inner quotes for two quotes), String Replace (changing inner double quotes for two single quotes, see topic "Parameter object is improperly defined") and String Quoting (adding single quotes).

  Sample of the desired result:

  The text: My value is 'xxxx'

  Should be: 'My value is ''xxx'''

 

  Best regards,

  DM

2

Hi Daniel,

I’ll put adding an option to escape inner quotes on the todo list, using either the run script or string replace action would be the best way to do this at the moment.

Regards,
Paul.

3

It will stay for the other users (or other implementations I need), I changed the script this weekend to use stored procedures, so I’m passing this value as a parameter.

Best regards,
DM