String Function for taking the first & last characters?
Posted: Mon Aug 19, 2002 12:10 pm
hey all, I'm getting an excel file and I have to save it as a tab deliminated text file then I do a load data infile into my database...
well that works fine but in the text file some of the descriptions have " " (quotes around them)
like instead of the product name being: jims red truck its coming out as "jims red truck"
any way to cut the first and last char off a string if it matches " ?
or is there a way in excel to stop outputting those quotes around my desc? cause they don't have them when you open the exel file, only when I output it to text. thanks all!
well that works fine but in the text file some of the descriptions have " " (quotes around them)
like instead of the product name being: jims red truck its coming out as "jims red truck"
any way to cut the first and last char off a string if it matches " ?
or is there a way in excel to stop outputting those quotes around my desc? cause they don't have them when you open the exel file, only when I output it to text. thanks all!