I have a problem with importing a spreadsheet from Excel into FMP. Only fields with leading zeros get an underscore into FMP. How do I get rid of them?
Preparing table in FMP to fill with data from the solution to finally deliver a prepared exportfile to Excel again. The tables are very big (lot of fields and record) and I prepare those in Excel.
I can open the files in FMP and I'm asked to put the first row into fieldnames of the record. That's very nice. I do so. Then FMP makes a new database from the table. When I go to the database design I see that All fields which are interpreted with numbers have a leading underscore. See table below what I mean.
|Source in Excel||Fieldname after import in Filemaker Pro||Result|
This screenshot is from Excel. The first row from this sheet is imported to fieldnames in one table in FMP. All cells have a text format but are interprete differently in FMP in the import process.
This is of course the reason ... It is possible to change the fieldname afterwards but FMP doesn't like it.
As said, the tables are very big to manually change the filednames. Is there a posibility to ommit the preceeding underscores when importing from Excel? And as you see, this only happens when FMP interpretes the first digits as a number. And of course, is it wise to work with leading zeros in filenames? I choose for this option because I want to export from the solution as is imported from Excel and I want to prevent extra sort procedures.
Thanks in advance,