[CSVUtil] Last line character error (EOL)

Forge Component
Published on 2019-09-28 by Wei Zhu
26 votes
Published on 2019-09-28 by Wei Zhu

Hi Guys!

I came across this error / bug...

The first image shows the configuration and the second the incorrect content of the file.The text is correct.File contents without last characters.

Temporary solution AKA Gambiarra in Brazil:

Would anyone have a definitive solution ?

Hi Maurilio, It is not clear for what exactly you're trying to achieve here.

Is it your requirement to have a line break to the end of your file or not? In this you should indeed use NewLine() action, it's not a gambiarra.

Can you share your espace so we can take a look and help out?

Wait! Is it not only EOL issue, but also incorrect data itself? 

What I read in 2nd image, the data itself is not complete.

Exactly Swatantra ...

The last characters are deleted from the generated CSV file.

To avoid this I manually entered Chr (13) + NewLine () + NewLine ()

So the last characters remain in the file.

João, I will isolate this example and share OML here ... as soon as it replies here.


Hi Maurilio

 According to you images, the problem are there are 5 bytes missed.

 Though I can not see your oml, but there are following steps.

  Step1: Use CSVUtil to export CSV as Text

  Step2: Use TextToBinaryData to convert Text to Binary with utf-8 encode.

  Step3: Transfer Binary Data from server to your PC.

  Step4: Open CSV with your text editor

 According to your 1st image, Step1 should be OK, becuase CSVUtil return the correct text.

 And assuming Step4 is OK, because usually text editor should be work fine.

So the problem should between Step2 and Step3 that cause 5 bytes missed.

You'd better to check binary data of these two steps.