Skip to Content
-1

Uploading file to AL11 with CG3Z issues

Hi Experts,

Am trying to upload csv file from CG3Z to AL11.

My file has very long header.

So after upload, in Al11, in file header in splitting into 3 lines.

I want header to fit in one line.

Can you please help me out.

Thanks,

Priya.

al11.jpg (173.9 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Apr 22, 2017 at 08:57 PM

    Probably your CSV file contains "newline" characters at the end of a few column headings (shown at positions X hereafter: "search fieldX", "Summarized Characteristic RecordingX"...) Correct your file in Excel, and try uploading again. If it doesn't work, please attach the CSV file here (zip it beforehand).

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 23, 2017 at 12:06 PM

    Sandra, I have two files, my client may pass, .csv(comma separated) or .txt (tab demilted)

    In my code open dataset in text mode default.

    Then read ,

    Then split at horizontal tab ( this line is splitting only # separated means txt dimilted, but it is not accepting or splitting comma separated means .csv file.

    I wanted both files to be processed.

    Second question resolved, I was clearing p_file.

    Thanks and kind regards,

    Priya.

    Add comment
    10|10000 characters needed characters exceeded