LSF9 PFI's FileAccess Node

 0 Replies
 0 Subscribed to this topic
 52 Subscribed to this forum
Sort:
Author
Messages
Sam Simpson
Veteran Member
Posts: 239
Veteran Member
    Here's some observation I found when creating a file using FileAccess method. this is not happening when file is created in your local hard drive c:\.

    In unix:
    1. A one long string of records is created when the cursor is ended next to the last variable. also true in local drive.

    2. If the cursor is ended at the beginning of the next line, then two newline characters are created (CR/LF). This is particularly disturbing because if you open the file in excel then you will get an extra line per record.  I'm using VSlick editor and I can see two newline characters. So how do you remove the extra newline characters?

    Here's what I did for my process flow but first for those
    using Solaris or AIX, make sure you have the dos2unix command. If not just browse the internet and download the script to your server's bin directory.

    Solution:  I added a system call to a korn shell script whose function is to call dox2unix command:

    "dos2unix  $MyFile $MyFile"