data manipulation

jamesmetcalf74
jamesmetcalf74 used Ask the Experts™
on
I have a long csv file but the rows are not identifiable by your classic character return.

its identified by a *

is there anyway to take this csv file and you a replace function to have the notepad file
have actual breaks in the line where the * used to be?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Top Expert 2014
Commented:
Rename the file type from csv to txt and use the import wizard.

It would help us if you posted a reasonable sample of the data.
Top Expert 2014
Commented:
Alternatively, you might use something like Notepad++ to change the * to CrLf
Even if it's .csv i believe you can change the delimiter in the Excel import wizard to * or any other character with which your records are separated.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial