Bagsy Baker
New Member
- Joined
- Feb 17, 2002
- Messages
- 41
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.
#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.