Hi all,
I try to work with an CSV file and ran into a strange behaviour when using the csv_decode filter.
I have my file resource and use the Get File Resource Data filter to get the raw data. Then I use the csv_decode filter to process the rows:
That should give me an array with the content of the rows. If I run a stop&debug at this point, it sometimes gives me an array of rows and every item in it is an array as well with the values from the CSV, as it should be:
But sometimes - even without changing anything, just running the function a few times in a row - it gives me the array of rows an every items contains just text:
It also changes the numbers in the content from e.g 1480,50 to 1,480.50.
What could be the reason for that and how can I make sure to get the correct array reliably?
Any help is appreciated. Thank you.
Stefan