Massage that DAT

Bagsy Baker · May 9th, 2002, 04:45 AM

I am trying to open a DAT file in excel, add an extra field, then SaveAs a DAT file. The open, amend, and SaveAs work, ... sort of. If I set the SaveAs type to CSV, it puts extra quotes around the text fields. If I remove the quotes on import, it leaves them off when it saves. The quote marks are required to tell the program that opens this DAT file which fields are text. I have even tried inserting a column between the columns with information and putting in comma marks and SaveAs .txt, but I hit the same road block. Does anyone have an avenue of possible hope? Here is a sample of data that I am trying to manipulate.

#V1.0
*,461,1111111,,,123
1,2,"IXX",324,800,,,"LAST",24
2,2,"IXX",400,450,"XXX",,,14
*462,1111111,,,111
1,5,"IXC",400,500,,,,,11
#

The overall goal is to add the number after the * to the end of the line that starts with a number. All I can't figure out is how to SaveAs shown above.

Bagsy Baker · May 9th, 2002, 03:00 PM

Come on .... I know someone out there must have run across this before .... any manufacturing production schedulers on?

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 9th, 2002, 04:45 AM	#1
Bagsy Baker New Member Join Date: Feb 2002 Location: Sackville Posts: 39	I am trying to open a DAT file in excel, add an extra field, then SaveAs a DAT file. The open, amend, and SaveAs work, ... sort of. If I set the SaveAs type to CSV, it puts extra quotes around the text fields. If I remove the quotes on import, it leaves them off when it saves. The quote marks are required to tell the program that opens this DAT file which fields are text. I have even tried inserting a column between the columns with information and putting in comma marks and SaveAs .txt, but I hit the same road block. Does anyone have an avenue of possible hope? Here is a sample of data that I am trying to manipulate. #V1.0 ,461,1111111,,,123 1,2,"IXX",324,800,,,"LAST",24 2,2,"IXX",400,450,"XXX",,,14 462,1111111,,,111 1,5,"IXC",400,500,,,,,11 # The overall goal is to add the number after the * to the end of the line that starts with a number. All I can't figure out is how to SaveAs shown above.

May 9th, 2002, 03:00 PM	#2
Bagsy Baker New Member Join Date: Feb 2002 Location: Sackville Posts: 39	Come on .... I know someone out there must have run across this before .... any manufacturing production schedulers on?