NiceDuck Posted December 3, 2020 Report Share Posted December 3, 2020 How do we remove the line break on string? I need to convert something from this: text1 text2 to this: text1text2 Quote Link to comment Share on other sites More sharing options...
0 NiceDuck Posted December 3, 2020 Author Report Share Posted December 3, 2020 this is just another trivia, as for this case, we can use this formula: REPLACE([@field:fieldname],CHAR(10),'') I hope it heps anyone. Quote Link to comment Share on other sites More sharing options...
0 lengleng Posted December 28, 2020 Report Share Posted December 28, 2020 For anyone that might be confused with Char(10), I'd like to add that 'Char(10)' is a character represented by ASCII Code 10, which is a Line Feed, it's basically a new line. More info:https://stackoverflow.com/a/7647983 Quote Link to comment Share on other sites More sharing options...
Question
NiceDuck
How do we remove the line break on string?
I need to convert something from this:
text1
text2
to this:
text1text2
Link to comment
Share on other sites
2 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.