Jump to content

Importing xls rows which have quotation marks


enquirerfm
 Share

This topic is 1782 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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?

Link to comment
Share on other sites

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 by comment
Link to comment
Share on other sites

  • 3 weeks later...

This topic is 1782 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.