I am attempting to write a vb.net program that will call another program which exports data from an accounting program into a text file in a specific format (tab delimited). I can't change the order of the fields at this point nor the format. I need to then take the text file that is generated and create another text file in the order specified by our client along with some addiitonal fields that are not in the original export. For example the original exported text file would read:
CustID, CustName, CustPhone, CustAddress, CustCity, CustState, and so on.
The new text file for the client needs to be:
CustID, CustName, CustCity,CustState, DateExported, and so on.
As you can see the file would be in a different order - omitting fields and adding fields.
Is it possible to simply read the existing text file and then write only the data I want (along with the additional required data) into a new text file. I know how to read a text file and write a text file in VB.net. But am not clear as to how to accomplish the task described above. Any assistance is greatly appreciated.
Start Free Trial
