Jump to content
Sign in to follow this  
myersli

Field Format Problem After Export

Recommended Posts

I am working on exporting data out of a custom-created FileMaker 5.5 database to import into eBase. One of the fields is a series of check boxes for a value list called "Groups." When I export data into .CSV, all of the data from that field is placed into a single field, separated by "boxes." I originally assumed that these "boxes" were line breaks. But, I do not believe that they are now. My problem is that I cannot do much of anything with the data while it is all concentrated into one field. And, since I cannot figure out what the data separator character is, I'm really quite stuck. I've attached a sample of the data. If anyone can provide assistance, I would greatly appreciate it. Thanks.

Sample.zip

Share this post


Link to post
Share on other sites

The box is a "vertical tab", ASCII 11, which FileMaker must use in order to not screw up the .csv, because 1 record = 1 line; can't handle extra line endings.

One way to do it is to create a FileMaker calculation, using Substitute() to convert those to a comma, then export the calculation field instead. The quotes in the CSV should allow you to have commas in a text field.

But one wonders why, since eBase is FileMaker, you don't just import as FileMaker? Other than the fact that eBase is kind of convoluted. Of course, much of that is to flexibly handle security/viewing with user-configurable fields. I haven't looked at their 7 version; hopefully it's been streamlined.

Share this post


Link to post
Share on other sites

Thanks for your help. However, I don't understand how to reference a vertical tab in that function. Is it Alt 0011? I've tried that, but nothing appears in the expression. Thanks.

Linton

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.