filtering CSV data

  • Thread starter Thread starter J_J
  • Start date Start date
J

J_J

Hi,
I have 650 lines of data in CSV format in an excel sheet.
The lines are long and something like this:

Aaaaaa,"",Bbbbbb," ","(e-mail address removed)","bla bla", ..........
Cdfhdj,"",Djkjds,"dsd","(e-mail address removed)","sdfsd",.......
.....
....

I need to filter out the records like this

A B C
1 Aaaaa Bbbbbb (e-mail address removed),
2 Cdfhdj Djkjds (e-mail address removed)

Any code recommendation is much appriciated.
J_J
 
try using the replace command under the edit menu. Turn on the macro
recorder and run it manually if you want code
 
Sorry Tom, but I couldn't get your point.
I do not want to replace anything. All my data are on Sheet1 and resides in
column A:A.

With cell A1 what I need to do actually is :

get the first text from the left of first comma and put it to Sheet2 A1
get the text between the second and the third comma and put it to Sheet2 B1
get the emial address between the forth and fifth commas and put it to
Sheet2 C1

Then I need to repeat this process for all 650 lines.
Regards
J_J
 
Paste the column in Sheet2

Select column A in sheet2

do data=>Text to columns, select comma as the delimiter

Delete the columns you don't want.

If you want code, turn on the macro recorder while you do it manually.
 
I got it this time.
Thanks a lot Tom.
J_J

Tom Ogilvy said:
Paste the column in Sheet2

Select column A in sheet2

do data=>Text to columns, select comma as the delimiter

Delete the columns you don't want.

If you want code, turn on the macro recorder while you do it manually.
Click to expand...
 
Back
Top