Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Massage that DAT

  1. #1
    New Member
    Join Date
    Feb 2002
    Location
    Sackville
    Posts
    39
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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.

  2. #2
    New Member
    Join Date
    Feb 2002
    Location
    Sackville
    Posts
    39
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

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

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •