Text formulas with multiple lines of text in a variable

Answered

Follow

James Brammer

October 22, 2019 14:54

I'm finding that attempting to modify the contents of a variable that contains multiple lines of text results in a blank output. If for example I have the block of text in [%GetDescription], and I want to use RightOf to set a new variable [%NewVar] to everything that comes after      Company: 'This Company'      then the resulting [%NewVar] is always blank.

What do I need to do to make the contents of multi-line text variables workable with formulas?

 

0

• 

  Tatyana Falaleeva October 22, 2019 15:05

  Hi James,

  You need to use Clean formula first - to replace the line breaks. We usually replace them with pipes - then it's easier to manipulate the value.

  Hope this helps.

  1

  Comment actions Permalink
• 

  James Brammer October 22, 2019 15:12 (Edited October 22, 2019 15:13)

  That solved it thank you Tatyana

  0

  Comment actions Permalink

Please sign in to leave a comment.