Multiple actions in Update or Nested Substitute

[lliu_western]

Hello Community,

Is it possible to have multiple Substitute function in the Update Statement? 

I am trying to substitute all possible letters that could break JSON when input is converted from SharePoint to JSON

Any help will be highly appreciated, thank you!

(Please note the example in my screenshot doesn't work. I have tried using && as well .)

[WarrenBelz · Accepted solution]

Hi @lliu_western ,

You just have to nest them

Substitute(
   Substitute(
      DataCardValuel3.Text,
      Char(10),
      "-"
   ),
   "&",
   "-"
)

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

[Luka84]

Thank you, this saved me a lot of time and effort