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?

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, 20169 yr by comment

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