Importing xls rows which have quotation marks

[enquirerfm]

I'm having trouble importing a file which has the odd double quotation mark dotted around the xls file. eg T-shirt, "logo" (M). The quotation mark messes up the import and I've tried using

Substitute (field;["\"";""];["( ";"("];[") ";")"];["   ";" "];["  ";" "];[".";""];[",";""];["-";" "];[".";" "] etc)

but it deletes everything between the quotation marks - I just want the marks removed. Obviously, I can do find/replace in the spreadsheet but I would like to do this on import and in case I forget. I have looked around at this without much luck. Also, worth noting that I have another field in the spreadsheet which has lots of quotations because the contents are made up of a formula eg

=a2&" | "&c2 &" | " &d2 etc

Maybe it's not possible?

[comment]

Your question is not clear. You posted this in XML/XSL - but you seem to be importing an .xls Excel spreadsheet? I don't see why quotation marks would "mess up the import" in such case. Why don't you post a small example of the source file, so we can try and reproduce the problem ourselves?

 

 

Edited August 26, 2016 by comment

[beverly]

try saving the worksheet as .csv and then import

and agreed with comment. ".xls" is Excel, not ".xsl" (Extensible Stylesheet Language)

http://www.w3schools.com/xsl/

beverly