Skip to main content
Solved

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

  • January 15, 2021
  • 3 replies
  • 538 views

ALHAGMO
Hero (Customer)
Forum|alt.badge.img+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

Best answer by dhlelk

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.

 

 

View original
Did this topic help you find an answer to your question?
This topic has been closed for replies.

dhlelk
Superhero
Forum|alt.badge.img+15
  • Superhero
  • January 16, 2021

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.

 

 


ALHAGMO
Hero (Customer)
Forum|alt.badge.img+10
  • Hero (Customer)
  • January 18, 2021

Hi Dhananjaya,

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

Regards Martina


dhlelk
Superhero
Forum|alt.badge.img+15
  • Superhero
  • January 18, 2021
ALHAGMO wrote:

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.


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings