[yuvsaha123]

Hello,

I have a situation where I have to import contents of a CSV file into a grid using a PHP trigger. PM's wiki has the related scripts. However, I get stuck when the content has special characters like " (double quotes) or ' (single quote) or , (comma). This messes up the values being imported into the grid. https://breakfasthoursofficial.com/chick-fil-a-lunch-hour
https://breakfasthoursofficial.com/carls-jr-breakfast-hours
https://breakfasthoursofficial.com/subway-breakfast-hours
What could be the best way to handle these characters when using the explode() function in a PHP trigger?


thanks
yuvsaha

[kirkwg]

Hi,

See below example if it can help or not?
https://www.pmusers.com/index.php/Import_and_export_CSV_files_into_and_out_of_grids

or Use another separator for your CSV file, the example in the link say using ';' as the separator.
Of course you need to edit or modify of your CSV files replacing ',' into ';' first. At least this is feasible to edit CSV....

Anyway, good luck..