How make fields into records

[Adker]

I'm importing a series of large notepad files which consist of ; separated
email fields. When I import themIget one big long record with the number of
fields equal to the number of email address fields. Thats OK but how to I
create a single record for each field? Or is there a better way to do this?

 

[MH]

Open the text files in a text editor of your choice, find semicolons and
replace with a Carriage Return / Line Feed pair.

Import the file.

MH

 

[JHL]

Does this work for commas too?

JHL

Open the text files in a text editor of your choice, find semicolons and
replace with a Carriage Return / Line Feed pair.

Import the file.

MH

 

[Adker]

Thanks very much. JHL, I used the replace function in Word 2003 and it was
perfect.

 

[MH]

Yep

Does this work for commas too?

JHL

 

[MH]

You're welcome, the simplest way is often the best.

MH