By using this website, you agree to our Terms of Use (click here)
Hi
Does anyone have any ideas of how to use the Replace function where you want to replace a line break with another value?
In a shipment I have added row comment on line. No space used, only entered first value(111111) the clicked Enter and added next value(22222) etc
In the GI, I have added the following tables
With the following join
In the Results grid, I have added formula =Replace( [Note.NoteText], ' ', '/' )
But it doesn't work
Seems like when displaying note text in inquiry, the line break is shown as a space. But it is not possible to replace the space. So it is a line break that should be replaced, maybe?=) Anyone have any ideas on how to do this?
You should be able to get what you want with =Replace( [Note.NoteText], '\n', '/' ). I just tested in 2019 R1.
Thank you!