Hey there. New user to FM7 and FMForums and need a bit of help.

We have inherited a database that has a field defined as Text[10] with a maximum of 10 repeating values. When we export this database, each of the values in this repeating field appear with no spaces between them. Example:

Fires

Winnipeg

Exports as "FIRESWINNIPEG", which is not helpful to us at all.

Is there any way to include spaces so this data can be parsed?

Thanks,

Grant

Yes export another field that plucks each value return/pilcrow delimited via a calc'field. This is the quick down and dirty approach.

But frankly is the structure of the table rotten. Such a field should have been normalized into two tables ...you do not say what application you wish to export it to. So before advising more is this the crutial question.

--sd

There are no spaces, but there is a non-printing character (ASCII 29) separating the entries, so they can be parsed.

Thanks for the quick replies on this.

I did search for ASCII 29, but it did not find a delimiter between these values. However, the knowledge that there were hidden values was helpful and I was able to replace them with something visible.

We're exporting this data for import into MySQL with a web based front end written in CFML for public searching.

Thanks again for your help.

Grant

We're exporting this data for import into MySQL with a web based front end written in CFML for public searching.

Note that .com has this tool that makes this process, including the handling of repeating fields:

http://www.fmpromigrator.com/products/fmpro_migrator/index.html

--sd