You are viewing limited content. For full access, please sign in.

Question

Workflow

Updated August 10, 2020

asked on August 5, 2020

Hi all,

How can I substitute double quote ["] by 2 x double quote [""] ?

This SUBSTITUTE(%(fichier),"""" ,"""""" ) return me 3 x double quote ["""]

Becareful, this is 1 character double quote ["] and note 2 characters simple quote ['] !

0 0

Answer

SELECTED ANSWER

replied on August 5, 2020

This appears to be a bug with the front-end validation in the activity. Reference ID 261985.

There are 2 workarounds:

Add an Assign Tokens activity and create 2 tokens. One set to just " and another set to "". Use these tokens to specify the old and new values in Substitute.
Use the Split token function on your string to break it up every time there's a " and then put it back together using "" as delimiter

3 0

replied on August 10, 2020

Hi Miruna,

Thanks for your help. The first solution is working. I didn't try the last one.

0 0