Vista Forums - View Single Post - Convert CSV semi-colone to comma separated

**.Joe** · 04-10-2008

Quote: Originally Posted by Gregor

Hello

I have a CSV File for import in AD

firstname;lastname;street,description
Max;Huber;Street 1;Max Huber, Street 1 >In the description, I have a
commas!

How convert the csv to comma separated

fistname,lastname,street,description
Max,Huber,Street 1,"Max Huber, Street 1"

You have an idea how this makes? For converting in comma with inverted comma
(apostrophe)

Thanks
Gregor

Gregor,

If I understand your post correctly, you want to replace a ";" with a "," (without the quotes) in a text file.

Open the file with notepad. Click on edit, click replace. Put a ; in the find what box, and put a , in the replace with box. That should make the process easier for you.

04-10-2008	#2 (permalink)
.Joe Windows 7 RC 916 posts	Re: Convert CSV semi-colone to comma separated Quote: Originally Posted by Gregor Hello I have a CSV File for import in AD firstname;lastname;street,description Max;Huber;Street 1;Max Huber, Street 1 >In the description, I have a commas! How convert the csv to comma separated fistname,lastname,street,description Max,Huber,Street 1,"Max Huber, Street 1" You have an idea how this makes? For converting in comma with inverted comma (apostrophe) Thanks Gregor Gregor, If I understand your post correctly, you want to replace a ";" with a "," (without the quotes) in a text file. Open the file with notepad. Click on edit, click replace. Put a ; in the find what box, and put a , in the replace with box. That should make the process easier for you.
My System Specs