How to reference special characters from a Caspio task / triggered action?

[Bkkkl]

Hello, 

Is it possible to specifically reference special characters from a Caspio task/triggered action?  

I see basic text functions here:

https://howto.caspio.com/tables-and-views/triggered-actions/

But how do you specifically insert something like a line return ('Char(10)' ) using the text functions?   Alternatively how would you find and remove a line return?  

https://howto.caspio.com/tech-tips-and-articles/tech-parameters/using-special-characters-in-query-string/

It looks like it can be done with a calculated field, but that seems like a convoluted solution. 

Thanks

 

[CoopperBackpack]

Hello @Bkkkl,

I tested the CHAR(10) as an example in a Task and it looks like it does not work. 

Basically, it is possible to replace values in the string using the REPLACE() function: 

 

However, CHAR(10) is considered as a text and not as a  line return in Triggered Actions and Task. 

So, the same is relevant to any CHAR() function. 

But in Calculated Field or Calculated Value it works: