Results 1 to 6 of 6
  1. #1
    Join Date
    Jan 2004
    Location
    The Netherlands
    Posts
    421

    Unanswered: Linefeeds & Carriage returns

    This really is a windows problem, but its Unix related. I am hoping to find a kindred spirit who can help me....

    => I know I can use a sed to add the ^M to the line end, but in my customer does not have a Unix environment. The supplying party is unwilling at the moment to help us. <=

    In text files created by Unix a line ends (and in those cases the record) with a linefeed (chr(10)) If you then want to import the file into access it sees it as 1 long line.
    Now i have found that to be a major pain, and one can work around by reading the file character by character. This however causes the import to take a very long time.

    Also i have noticed that in a certain environment, using A2k sp-3 on a win 2k machine access will accept the chr(10) as the "carriage return" thus importing the file properly. On other systems tho, NT/A97 and XP/AXP, it sees it as one line.

    Does anyone have any info on the how when and why of this? I tried googling, MSDN and searching on the forum, but could not find anything trully relevant. Except maybe that Access should see it as 1 line, except for the earliest version (2).

    Anybody?

    Thanx

  2. #2
    Join Date
    Aug 2004
    Location
    Rome, Italy
    Posts
    81

    Linefeeds & Carriage returns

    Hi namliam,
    I don't know whether I've got the point, so you produce a file in a unix-like OS. After you send it via FTP in windows server to import it to Access. So you can use the ASCII option during FTP the file it will be sent to the server Windows with Line Feed and Carriage Return. Anyway if you have already the file and you don't have a unix-like OS then(I know that it is so stupid to tell it) open the file with a an advanced text editor(like TextPad or UltraEdit) and save it as a Dos file.

    bye bye,
    ducasio

  3. #3
    Join Date
    Jun 2003
    Location
    West Palm Beach, FL
    Posts
    2,713

    Cool

    You could also install cygwin and use the unix2dos utility.
    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

  4. #4
    Join Date
    Jan 2004
    Location
    The Netherlands
    Posts
    421
    Thanx for the suggestions....I am affraid that installing something/anything is not an option, my hands are tied on that end....

    Changing the method of sending is the same, out of my hands and/or are not willing to change....

    The process should be as automated as possible, we need to process multiple files ... Doing it by hand really is not an option either....

    Sorry to be so limited, but thats what i have to deal with and get some work done as well.
    Easiest would be for the sending party to do a sed command... but my grandchildren will be dead before they listen to me....

    Thanx again for all suggestions... Also keep them comming cuase i am still stuck to doing it char by char...

    Regards

    The Mailman

  5. #5
    Join Date
    Jun 2002
    Location
    UK
    Posts
    525
    Do you have flip?

  6. #6
    Join Date
    Jun 2003
    Location
    West Palm Beach, FL
    Posts
    2,713

    Cool

    Quote Originally Posted by namliam
    Thanx for the suggestions....I am affraid that installing something/anything is not an option, my hands are tied on that end....

    Changing the method of sending is the same, out of my hands and/or are not willing to change....

    The process should be as automated as possible, we need to process multiple files ... Doing it by hand really is not an option either....

    Sorry to be so limited, but thats what i have to deal with and get some work done as well.
    Easiest would be for the sending party to do a sed command... but my grandchildren will be dead before they listen to me....

    Thanx again for all suggestions... Also keep them comming cuase i am still stuck to doing it char by char...

    Regards

    The Mailman
    If you cannot install or change anything, then you have NO options!
    cygwin is free and the unix2dos utility can be run in batch.
    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

Posting Permissions

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