- Sun Aug 15, 2021 11:20 am
#829462
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
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
Last edited by yuvsaha123 on Wed Sep 22, 2021 9:18 am, edited 1 time in total.