Hi,


I'm trying to use the app CSVUtil to convert a CSV file to a list but when I try to change the field delimiter from "," to "|" my list becomes empty. Other than that it works fine and the list appears full with the content that I want.

Does anyone knows how to overcome this problem?


Thank you,

Madalena

Hi Madalena Costa e Silva,

If you use the "," works fine?


Probably you need to open the xif and add the "|" as delimiter.


Best Regards,

Pedro Vila Nova

Solution

Pedro Vila Nova wrote:

Hi Madalena Costa e Silva,

If you use the "," works fine?


Probably you need to open the xif and add the "|" as delimiter.


Best Regards,

Pedro Vila Nova

Hi Pedro,


Thank you for your help.

I found out what was wrong and apparently it had nothing to do with the delimiter. It was the data type of the structure of the imported file that can only be defined as text. So that is why it was giving me an empty file.

Just a simple mistake that took hours to figure out!!


Madalena


Solution