Solved

How can I add carriage return in Report Designer using vldtstr:strReplaceAll(tns:ORDER_LINE_NOTES,'~#CR;','???')

  • 15 January 2021
  • 3 replies
  • 402 views

Userlevel 5
Badge +10

Hi guys,

My colleages have entered a longer text, which is shown on several lines in the customer order line document text.

But on customer order confirmation it shows like one string.

I have tried to use this

vldtstr:strReplaceAll(tns:ORDER_LINE_NOTES,'~#CR;','<br/>')

but it does not work, ^p neither...

Who can help?

Any proposal is appreciated.

Regards Martina

icon

Best answer by dhlelk 16 January 2021, 11:33

View original

This topic has been closed for comments

3 replies

Userlevel 6
Badge +15

Hi @ALHAGMO,

Try using the $new_line string constant in the report designer function editor.

Example which replaces all occurrences of 2 spaces with a new line,
Formulas: vldtstr:strReplaceAll('Line 1  Line 2', '  ', $new_line)
Output: Line 1
Line 2

If you are unable to achieve this in report designer, I would suggest you to do the changes on the RDF logic.

Check the following f1doc link,
IFS Report Designer Functions

You might might need to check the below article on how to convert the above link to your customer specific f1doc URL,
How to access wit.ifsworld or docs.ifs links on this site

Cheers !
Dhananjaya.

 

 

Userlevel 5
Badge +10

Hi Dhananjaya,

thank you very much for your quick and great answer, it worked immediately!

Regards Martina

Userlevel 6
Badge +15

Hi Dhananjaya,

thank you very much for your quick and great answer, it worked immediately!

Regards Martina

Hi @ALHAGMO,

You are welcome and I'm happy to help 😊

Cheers !
Dhananjaya.