Dataflow creation - csv File is driving me insane, need help !

[Vrykolakas]

Hello !

To give some context, I have a bunch of csv files that I load manually once a month from AppleStore, and I need to digest these files into PBI to do some reporting of all the app installs that happened daily per country. ( I shortened my file for the purpose of posting here, so that the issue I'm having is clear )

These files have the following structure : 

The highlighted row 5 is problematic, of course a solution could be to manually delete the first 4 rows, remove the extra " ".. But, what I'm looking for here, is a way to do and automate this kind of transformation in my dataflow.

Another Screenshot from PBI service when trying to digest this file : 

So that's it, I'm having a big blockage at this step.. Would really appreciate some insight from more experienced people here.

Any Help, or tip is highly welcomed. 

[lbendlin]

Check your CSV files with a hex editor to see if there is a character between the double quotes ""  that you could use for splitting.

Is it right to assume that only the rightmost country in that line is important?