Chemical formulae formatting

[dcrOz]

I wish to migrate a mineralogical database that I created using v5.5 for use with v9 Advanced, but a straight import loses all the special formatting for the chemical formulae. Is there a way to import the data while preserving the formatting so that I don't have to reformat 3000 formulae?

[comment]

I am not sure what you mean by "straight import". You cannot import directly from a .fp5 file. But if you let Filemaker v.9 convert the .fp5 file, the text styling will be preserved - even if you then import the data to another file.

[dcrOz]

Just opened the fp5 file and let v9 convert it - and the superscript and subscript formatting is gone from the formulae.

[comment]

Can you post a sample .fp5 file? A copy of your file with just the relevant field and one or two records with example data should be sufficient.

[dcrOz]

here it is

Edited July 6, 2008 by Guest

[RodSierra]

Converts fine retaining formating for me FM9 advanced on OSX Tiger.

[dcrOz]

hmmm - must be something with the Windows versions not retaining super/sub formatting.

oh well - looks like I'll have to edit each formula individually anyhow - thanks for the attempt :

[RodSierra]

check your PM box, I can send you the converted file, perhaps it will work for you.