Results 1 to 3 of 3
  1. #1
    rpeare is offline VIP
    Windows XP Access 2003
    Join Date
    Jul 2011
    Posts
    5,442

    In need of UNIX text files for testing.

    If there is anyone out there who has access to a UNIX system I'm in need of 4 text files that I can't create locally. If you have a UNIX system available to you I really need a file created for each one of these:

    three lines on each file

    Line1
    Line2
    Line3

    BUT I need

    1 file that has a CR only at the end of each line
    1 file that has a LF only at the end of each line
    1 file that has a double LF at the end of each line


    1 file that has a double CR at the end of each line

    I've tried to create these using my windows system but they are not appearing the same as the same files built out of a UNIX system. If you can help me please let me know or simply upload the files to the forum for me!

    Thanks

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,825
    Are you trying to build procedure to import UNIX file?

    Here is one http://vbcity.com/forums/t/32132.aspx.

    But of course you need a UNIX file to test. This link shows code to convert either direction. Seems a simple matter of replacing or including Chr(10):
    http://www.a1vbcode.com/snippet-2938.asp

    Although this one suggests must also strip EOF code for DOS to UNIX conversion:
    http://www.bastet.com/
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    rpeare is offline VIP
    Windows XP Access 2003
    Join Date
    Jul 2011
    Posts
    5,442
    No, not trying to build a unix import. We get text files that are generated out of a unix system but lately there have been errors in the generation of those files that include a single line feed character or double line feed, or double carriage returns etc. I've built a set of code in access that works on the errors that I've encountered so far but I'm trying to make it a little more far reaching. I've tried building test files using fso but it's not displaying the same way a file generated out of the UNIX system displays when I open them for instance if I had

    Line1
    Line2
    Line3

    if I generate them with fso and a single line feed, it appears exactly as it does above (even when I try to detect carriage returns when examining the file again it only shows as a line feed) whereas out of the external UNIX system (one I do not have access to) it would appear as

    Line1Line2Line3

    so I'm just flat out not able to do testing under the same circumstances. I'll give the freefile method a shot, I hadn't used that method in a long long time but I may be able to produce the same visual effect using it.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Transfer text files
    By raytackettsells in forum Import/Export Data
    Replies: 5
    Last Post: 09-08-2012, 12:37 PM
  2. Export table to several text files
    By ShadeTree in forum Programming
    Replies: 3
    Last Post: 04-24-2012, 08:02 AM
  3. Importing Text files
    By RayMilhon in forum Programming
    Replies: 4
    Last Post: 10-10-2011, 10:54 PM
  4. Converting UNIX time
    By sharon.chapman7 in forum Programming
    Replies: 3
    Last Post: 09-02-2011, 08:32 AM
  5. Unix Time
    By wifor in forum Programming
    Replies: 2
    Last Post: 07-29-2008, 11:01 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums