Jump to content
Salesforce and other SMB Solutions are coming soon. ×

Title case import problem


Nocturnal

Recommended Posts

I made an old database that had the title case format in the first, last names fields. I have since made something better as I learn more about Filemaker but I can't think how dumb I was to use the title case text format. I won't be using the title case format in the new database so I want the records to import with title case but I have not been sucessful at all. They all appear lower case. Is their a way to make them work?

Link to comment
Share on other sites

Hi,

 

you can run a replace command on the field(s)

 

Proper(fieldname)

 

You will need to do this to each field in turn.

 

Or you can do this in a script

 

Show All Records

Go to layout [with the fields on]

Replace (field name, no dialog] Specify Proper(fieldname)

 

Repeat the replace for each field required.

 

HTH

Link to comment
Share on other sites

This thread is quite old. Please start a new thread rather than reviving this one.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.



×
×
  • Create New...

Important Information

Terms of Use