Exporting - Repeating Fields & No Spaces

[Grant Gelinas-Brown]

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

[Søren Dyhr]

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

[comment]

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

[Grant Gelinas-Brown]

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

[Søren Dyhr]

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