Jump to content

Format of exported data


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

Recommended Posts

  • Newbies

Hello,

This may not be the correct forum, I am new to fmp.

I'm exporting data as Comma Separated Text - this is how it exports:

"Darren", "Mcdonnald"

"Ben", "Smith"

"Gavin", "Richardson"

"George", "Brown"
 



But instead, I want all the collumns on one line:


 

FirstName = "Darren", "Ben", "Gavin", "George"

LastName = "Mcdonnald", "Smith", "Richardson", "Brown"

Is this possible?

Thanks

Link to comment
Share on other sites

You'll need two new fields to concatenate the data. I would suggest using global fields and looping through the found set, appending each piece of a data to the fields. Something like

Set Field [globalFirstName, ""]

Set Field [globalLastName, ""]

Go to Record/Request/Page [First]

Loop

Set Field [globalFirstName, globalFirstName & """" & FirstName & """, "]

Set Field [globalLastName, globalLastName & """" & LastName & """, "]

Go to Record/Request/Page [Exit after last, Next]

End Loop

Set Field [globalFirstName, Left( globalFirstName, Length(globalFirstName) - 2 )]

Set Field [globalLastName, Left( globalLastName, Length(globalLastName) - 2 )]

Then export the globals.

Link to comment
Share on other sites

Don't forget that text fields have a 640 KB character limit in FMP 6 and earlier. In FMP 7 the limit has extended to 2 GB.

This could probably be done easily with XML export. Unfortunately I know not how to do it myself but others may be able to help.

Link to comment
Share on other sites

Hey, Giraffe.

Is this by any chance a one-off?

If so, export as comma delimited Fname, LName.

Import to Excel or other spreadsheet and transpose rows and columns.

Export from Excel as comma-delimited.

Depending on how big your database is, I think you could have problems with the size of your two resulting records. Many text editors truncate at ?? and I think this is a system limitation not the editors' authors. I think ?? might be the magic 64k but not sure. BigThumbUp.gif

Link to comment
Share on other sites

  • 2 weeks later...

Wow, this is almost the answer to the question I was about to post...but not quite. I need to do something like what -Queue- was suggesting (but I think that the character limit will make this infeasible for us), but it is not a one time thing, so I'd like to make it as quick an user-interaction free as possible. Does anyone see another way to do this?

I have been searching this site for a while to see if there's anything about this. A different post mentioned using an ODBC link. I am embarrassed to admit that I have no idea what this is. I'm using FileMaker version 4, and I can't find anything in the help about this...is it something only available in newer versions?

Link to comment
Share on other sites

This topic is 6964 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
×
×
  • Create New...

Important Information

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