Replace / remove line breaks

gamestoenjoy

Well-Known Member
Full GL Member
Credits
9,470
Sometimes you want to replace or remove the line breaks from a text.
For example, when we work with SQL and we executed a select query that returned the values as a collection of lines,
and we want to use those values separated by commas for an update query .
There is an easy solution here, to use an online tool that will replace the line breaks with commas (or whatever character we want, or remove them).

Here is link: Line breaks replacer
 
So what exactly does this do?
 
So what exactly does this do?

It removes newlines (meaning \r, \n or both) or replace them with a different character for a given text.

It can be used for example when we work with SQL and executed a select query that returned the values as lines separated by newlines.
We want to use those values for an update query, but for this query the values should be separated by commas.
Using this tool you can replace the newlines with commas.

Very easy solution for an irritating problem :)
 
Back
Top