Using Get File Content using Path for CSV leaves extra empty line at end of file

(0) Share

Report

Posted on by MFEProjects

Hi,

I have been trying to use Get File Content Using Path to retrieve a CSV file from SharePoint.

When the content is converted from base 64 to string, it appears to have an empty entry at the end.

Here is a picture of my flow:

And here is the output of the Split CSV Into Array action:

[
 "ContClient,ContMFE,ProcName,RecTitle,Remarks,RespParty,RespPartyText,Specifications",
 "Witness,Witness,Welder Qualifications,,,Client,,\"ASME BPVC Sec. IX, AS3992\"",
 "Witness,Witness,WPS/PQR Approval,,,Client,,",
 "Witness,Witness,Procedure Materials,,,Client,,",
 ""
]

As you can see there is an empty entry at the end.

What causes this, and am I better off fixing the problem or just cutting off the empty entry afterwards?

Thanks

Categories:

General topics