How to split string with delimiter

Question

I'm creating a script that process a .csv file and splits the data to a variable and saves it to a database but the problem goes this way,

for example my db table has 3 fields (name, qty, description) and I need them to be filled by the data from the .csv file and all the data inside the file also has a string with 3 data separated by a comma/','.

Here is the problem, what if the data inside the .csv file, in the description field has a comma/',' in it?

example: product1 , 10 , This is a test, Thanks!, then I need the data to be like this in the table

|NAME     |QTY|DESCRIPTION            |
|product1 |10 |This is a test, Thanks!|

but the problem is if that .csv file has a comma/',' in the description the script recognizes it as another field and it ruined the whole process, so is there any logical solution about this scenario?

Thanks in advance.

FYI: I get the file from vendors and they put it inside a ftp, I have no control on the file's and format they use

csv files containing comas usually use quotes around values. What are you using to parse the file? — njzk2, Dec 21 '18 at 06:47
Use opencsv library so that you can parse column into object directly — Deadpool, Dec 21 '18 at 06:49
Yes, some of the files are wrapped with quotes but some doesn't have any. I'm using a simple row.split, I also tried using papa parse but its the same — Les ter Bon, Dec 21 '18 at 06:51
| pipe separator is just a representation of a border in a data table its just a illustration what should it look like inside a table — Les ter Bon, Dec 21 '18 at 06:52

How to split string with delimiter

0 Answers0