asked on 11/19/2014

I need to convert this file to a csv or excel sheet How would I do this?

I need to convert this file to a csv file or an excel file. This is a flat file that we created years ago for our medical program. Any help on getting these type of files into a csv would be great. I have included a screenshot of an example. what would be the best way to accomplish this?
consult.png

Microsoft Excel Microsoft Access

Last Comment

Martin Liss

12/22/2014

Gozreh

11/19/2014

FIrst import it in table to MS-Access with single field.
write VBA function to get the column names

Function GetColumnName(str as String) As String
   Select Case str
   Case "<"
         GetColumnName = "Names"
   Case ">"
         GetColumnName = "Address"
......

Open in new window

Then add to query GetColumnName(Left$([Field],1)) AS MyColumn, Right([Field], Len([Field]) - 1) AS MyValue

Then you can add new query for cross-tab

Qlemo

11/19/2014

A CSV requires a static format, and the data shown have variable amount of fields.
The second and third "record" have ">" instead of "<" as Name marker.
And there is additional text found - what should happen with that?

Lastly, is PowerShell an option?

Paul Sauvé

11/19/2014

this seems to be a text file. Open Excel, Data tab -> Get External Data -> From text

Navigate to the file and click on import

ASKER CERTIFIED SOLUTION

Nick67

11/21/2014

THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial

Steve Lizardi

11/23/2014

ASKER

@nick67 I will take a look. sorry for the delay. I will try it on Monday. We are moving from one EHR to another and I need to be able to import files. Thanks guys for all your help.

Martin Liss

12/22/2014

This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.