new line character

[davikokar]

Hallo,
I'm trying to make a query that replaces the new line charachter with a string, but I cannot find the way to refer to the new line charachter. Does someone know how can I say "new line character" in a query?
thanks

Expr1: Replace([tmes].[mes_text];"newlinecharachter";"<br />")

 

[earthandfire]

It depends on where you are doing this, in Code you would use the constant vbCRLF, otherwise you would use Chr(13) & Chr(10) ie

Expr1: Replace([tmes].[mes_text];Chr(13) & Chr(10);"<br />")

 

[davikokar]

thanks earthandfire
I'm doing it inside a SQL sentence. In a stored query.
What's the difference between Chr(13) and Chr(10)?

 

[PHV]

Chr(13) is CR(Carriage Return) and Chr(10) is LF(LineFeed).

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[earthandfire]

Chr(13) is 'Carriage Return' and Chr(10) is 'Line Feed', goes back to the old days of line printers. So a 'New Line' consists of the two codes CarriageReturn LineFeed ie the concatenation (or joining) of Chr(13) & Chr(10)

 

[ProgramError]

old days! it was only 30 yeas ago u young wippersnapper.


Program Error
Programmers do it one finger at a time!

 

[earthandfire]

30 years ago! I should have said 'Ancient Times'