Finance | Project Operations, Human Resources, ...

Import from csv files brings wrong data values

(0) Share

Report

Posted on by SGbron

157

Hello to everyone.

I have an issue after reading a file from csv.
The csv has 22 rows, but some of them are empty in some lines and in the container that brings back the data, some values are in wrong position.

for example:

line 1 : value 1; value2; ; value4; value5

it brings back : [1value1, [2value2, [3value4, [4value5

when it has to bring back [1value1, [2value2, [3null , [4value4, [5value5

Is it possible to fix this issue somehow?

The code i use to read the file is

 #File
        container               currentLine;
        int                     totalOfLines;
        CommaTextStreamIo       localStream;
        Num                     number;
            
       
        FileUpload fileUploadControl = this.getFormControl(dialog, FileUploadName);
        
        FileUploadTemporaryStorageResult fileUploadResult = fileUploadControl.getFileUploadResult();
        
        if (fileUploadResult != null && fileUploadResult.getUploadStatus())
        {
            textFile = fileUploadResult.getDownloadUrl();
        }
        
        localStream = CommaTextStreamIo::constructForRead(File::UseFileFromURL(textFile));
        
        
        localStream.inFieldDelimiter("\;");
        localStream.inRecordDelimiter("\n");
    
        currentLine = localStream.read();
        totalOfLines  ;
        
        
        while(currentLine)
        {
            
            number = conPeek(currentLine,1);

            info(strFmt("Number : %1",number));

            currentLine = localStream.read();

        }

I have the same question (0)

All responses (4)

Answers (0)

Sort by

nmaenpaa 101,172 Moderator on at

Like (1)

Report
Copy link

Link copied!

Hi SGbron,

what do you mean by "brings back"? What part of your code handles this "bringing back"? Doesn't your code simply print one entry in the infolog for each row in your CSV file?

Was this reply helpful? Yes No
SGbron 157 on at

Like (0)

Report
Copy link

Link copied!

Hello Nikolaos.

By brings back I mean that in lines:

while(currentLine)

{

number = conPeek(currentLine,1);

info(strFmt("Number : %1",number));

currentLine = localStream.read();

}

where it reads the file, in the container takes the values that i am writing

It misses the null value.

Was this reply helpful? Yes No
nmaenpaa 101,172 Moderator on at

Like (0)

Report
Copy link

Link copied!

Could you change your code a bit, to print the contents of currentLine (using con2str(currentLine))?

And share with us some real CSV rows, and real output from your code? Thanks!

Was this reply helpful? Yes No
Suggested answer

SGbron 157 on at

Like (0)

Report
Copy link

Link copied!

Finally I found the reason for missing colums.

I had set the delimeter to ' ; ' but for some reason it doesn't read correct the file when null values exist. the correct delimeter is ' , '.

Was this reply helpful? Yes No