Jump to content
Sign in to follow this  
ginger

Exporting to Excel

Recommended Posts

We have tried exporting from FileMaker (V5) to Excel in several different formats (tab separated, dbf, dif, sylk and merge) and in all formats the information you get when you open in excel has a box everywhere there was a return used in the sending field from filemaker???

Please does anyone have any suggestions???

Thank you in advance for your help

Share this post


Link to post
Share on other sites

You obviously use carriage returns in your felds ( bad move for compatibility)

Filemaker translates every return character (ASCI code 13) into ASCI character 11. I don't know why on Earth FMPinc chose to do this, maybe this has something to do with the MAC origins.

ASCI 11 does not have a symbol ( at least in windows) . (The FMP help file calls it a vertical tab, whatever that is) When this gets exported to Excel, then all you see is a box. You could emulate this with two cells in Excel. Put 11 in cell A1, then in A2 type =Char(A1) and you'll see a box.

In fact the first 32 characters in ASCII do not have a symbol.

I'm not sure what you could do apart from creating calculated fields to split the lines in your text fields, before exporting.

Hope this helps

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...

Important Information

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