Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

Troubleshooting
Research
Professional Opinions
Ask a Question
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

troubleshooting Question

EDI TO CSV

Avatar of W.E.B
W.E.B asked on
Microsoft Excel
29 Comments1 Solution2233 ViewsLast Modified:
Hello,
in 2010 I've asked for a macro help to convert an edi (.out file) that I receive daily from a client and I needed to convert to csv to be able to import into my database.

the macro that I used is/was working perfectly until this week when my client changed the file format.

My client added some lines to the file.

Please see attached macro I use., and sample csv file

I need your help changing the macro to recognize the changes.

changes are:
if you notice on line 10, line 25, Column "A" is empty.

I need to have 2 files created .
1- I need the macro to recognize and skip the lines that has colmn "A" empty. and save the file (FILE01) as .csv
2- I need the macro to recognize the lines with column "A" empty and ignore everything else, and save the file (FILE02) as .csv

is there any way the new file created can be saved automatically on the desktop?

Any help is appreciated.
macro.txt
sample.csv
ASKER CERTIFIED SOLUTION
Avatar of aikimark
aikimarkFlag of United States of America imageGet vaccinated; Social distance; Wear a mask
Commented:
This problem has been solved!
Unlock 1 Answer and 29 Comments.
See Answers