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

Question

Question

Token Calculator Substitute Value with New Line

Workflow
Updated December 18, 2019
asked on July 26, 2019

Does anyone know if it is possible to substitute the value you replace with a new line.

I have tried both SUBSTITUTE(input, old, "\n") and SUBSTITUTE(input, old, \n(assigned to a token)) they both return the text \n on the output.

Any help would be appreciated.

 

0 0

Answer

SELECTED ANSWER
replied on July 26, 2019 • Show version history

I'm not sure if you can do it with the Substitute function, but you could use the token editor.

In the token editor dialog

  • Add a Function
    • Split on your "old" value/character
  • Apply Index
    • All values separated by line break

 

In the example below, I used an & for the split, but you can use other characters, words, or tokens.

3 0
replied on July 26, 2019

@████████ That did the trick thank you!

1 0
replied on December 18, 2019 • Show version history

@Amir Mukatarzada,

 

For Special characters, you can use CHAR(number) instead.

E.G :

CHAR(34) = " (double quote)

CHAR(39) = ' (simple quote)

SUBSTITUTE(token, CHAR(34), CHAR(39) )

 

You can find the number code for each characters here

https://fr.wikibooks.org/wiki/Les_ASCII_de_0_%C3%A0_127/La_table_ASCII

 

Regards

 

0 0

Replies

You are not allowed to reply in this post.
You are not allowed to follow up in this post.

Sign in to reply to this post.

Details
Related Posts
Loading ...