Hello,
I am reading a cell I have parsed from a CSV file and if it contains a few quotes it adds extra quotes to the line of text.
The CSV file reads: 1-3/4"X9-1/2"X20' S PINE 2.0LVL BEAM
The read-line function gives me: "\"1-3/4\"\"X9-1/2\"\"X20' S PINE 2.0LVL BEAM\""
Once the text is placed in my attribute field it displays: "1-3/4""X9-1/2""X20' S PINE 2.0LVL BEAM"
I have already found a way to strip the quotes from the begging and the end but in the middle it's giving me double quotes.
I guess for starters I need to find out why it reads the line of text from the CSV file like that.
I will need to use this attribute to search and compare back with the CSV file later so stripping them out might not show as a match but I don't want them displayed. Why does read-line give me two quotes instead of one? Is there another way to get a literal read from the CSV file?
Thank you