0
votes

I have one field in SAP Crystal Report and I want to insert a carriage return in the middle of the value based on the appearance of a certain word.

Example:

Ring mat:1.4404 DrawNo:645321 Rev.A

Should look like:

Ring mat:14404 DrawNo:645321 Rev.A

In this, the return should always come before the word DrawNo:

Can someone give me a explanation how to do this?

I have tried different methods, but they're all based on a fix number of character. And the return is set after this number of characters. Because the characters in front of DrawNo: are dynamic, i can't get it to work properly.

1

1 Answers

0
votes

Use something like: Replace(YourValue, "DrawNo", Chr(10) + "DrawNo")

Turn on the property 'Can Grow'