Replace new line with comma

[sunil1989]

Thanks in Advance!!!!!

Hi ,

i am taking set of string in input box and replace new line with comma for e.g.

Input box:

Vina Maipo Sauvignon Blanc 75c

Ciroc Green Apple 700ml

Output should be:

(Vina Maipo Sauvignon Blanc 75c,Ciroc Green Apple 700ml)

Thanks,

Sunilkumar

[sunny_talwar]

May be this

Replace(vVar, Chr(10)&Chr(13), ', ')