Import and Export Text data
 

Hello All, I have a text file that contains 17 lines of header
information and then a bunch of data from rows 18 on. I need to import
the data to remove one column and the re-export the data as a text
file, I can do all of this manually but I wanted to try and automate
the process as it takes up way to much of my time to do this everyday
with all the data.

Here is my ultimate goal:

1-Import the text file and save the header information to attach to
the text document that is exported.

2- Delete column E after importing the raw data starting at row 18

3-Put the header information back on top of the data and export as a
text (tab delimited) file.

If anyone wants I can email the text file it is too big to post here.

Thanks,
Bob

Import and Export Text data
 

if it's the exact same steps every time you can record a macro

"yanks6rule" wrote:

Hello All, I have a text file that contains 17 lines of header
information and then a bunch of data from rows 18 on. I need to import
the data to remove one column and the re-export the data as a text
file, I can do all of this manually but I wanted to try and automate
the process as it takes up way to much of my time to do this everyday
with all the data.

Here is my ultimate goal:

1-Import the text file and save the header information to attach to
the text document that is exported.

2- Delete column E after importing the raw data starting at row 18

3-Put the header information back on top of the data and export as a
text (tab delimited) file.

If anyone wants I can email the text file it is too big to post here.

Thanks,
Bob

Import and Export Text data
 

Hi,

I'm not sure of all the steps you are doing or where, but you might try
recording your actions and see how far that takes you.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"yanks6rule" wrote:

Hello All, I have a text file that contains 17 lines of header
information and then a bunch of data from rows 18 on. I need to import
the data to remove one column and the re-export the data as a text
file, I can do all of this manually but I wanted to try and automate
the process as it takes up way to much of my time to do this everyday
with all the data.

Here is my ultimate goal:

1-Import the text file and save the header information to attach to
the text document that is exported.

2- Delete column E after importing the raw data starting at row 18

3-Put the header information back on top of the data and export as a
text (tab delimited) file.

If anyone wants I can email the text file it is too big to post here.

Thanks,
Bob