Middle function

[ferg]

Mac OS 10.7.5

I receive orders via Excel in .xls format.

Personalized products.

Personalization is thus: 44184 Name: Alexandra

Obviously I wish to remove the " 44184 Name: " With spaces etc. equals 12 characters/spaces.

I have this working in other data base using MONO (MONO ; 12 ; 20 ; )

New data base is essentially the same set up with like column names, will not function.

I have the Mono column formatted as Text in FM as well as the .xls file. Tried changing format to number or General in the .xls file with no different results.

Only difference in the receipt of the files from the old DB and the new one, the file I receive in original is a .csv file which I convert to .xls so FM can use it correctly.

Any help greatly appreciated. Did I make any of this clear?

ferg

[Lee Smith]

Automatic message

This topic has been moved from "FileMaker Product Family → FileMaker Pro 10" to "Database Schema & Business Logic → Calculation Engine (Define Fields)".

[comment]

Did I make any of this clear?

I am afraid not. I will make a guess, though.

I have this working in other data base using MONO (MONO ; 12 ; 20 ; )

Did you perhaps mean =

Middle ( MONO ; 12 ; 20 )

If so, I don't see why it wouldn't work in the new file - although it would be better written as =

Right ( MONO ; Length ( MONO ) - 12 )

the file I receive in original is a .csv file which I convert to .xls so FM can use it correctly

Filemaker can import .csv directly. Converting to Excel adds unnecessary steps and possibly unnecessary complications.

[ferg]

Reference: Filemaker can import .csv directly. Converting to Excel adds unnecessary steps and possibly unnecessary complications.

May be true but: The Excel file we receive from this company does not list multiple Personalizations from same customer, I have to modify the Excel file to insert these names into the list. When using the .csv format it gets messed up when I save and import into FM. Saving as a .xls format keeps everything as it was. No complications except for time to insert the extra names.

The problem with the file above not deleting the unwanted characters was because I had neglected to put a check mark in the Import so FM would Perform Auto-Enter options.

Everything works as planned. Sometimes the eyes are totally blind to the little things.

Thanks for the help. The calculation works the way I had written it, as well as your method.

ferg