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 QuestionDid 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
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
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
Our community of experts have been thoroughly vetted for their expertise and industry experience.
The Distinguished Expert awards are presented to the top veteran and rookie experts to earn the most points in the top 50 topics.