StrReplace newline

[woodpecker]

Hi,

I am trying to replace a comma with newline with StrReplace, I have tried:-

StrReplace(myvariable,",","\r\n")
and
StrReplace(myvariable,",","\n")

These just change to \r\n or \n. Also tried without quotes and tried chr$(13), none work, can this be done with StrReplace?

TIA

 

[klaus]

Try this one:
StrReplace(myvariable,",",crlf)

Best regards.

 

[woodpecker]

Try this one:
StrReplace(myvariable,",",crlf)

Best regards.

Perfect, thanks so much.