Answering my own question...I used Replace with Proper (word) as my
equation to solve the problem! Never noticed that function before--it
actually does replace the value, not just the style.
Sorry for the silly question. : )
Sue
On May 12, 2011, at 11:55 AM, Sue wrote:
I am trying to massage some data for import from one software
program to another.
I have information from a starting file that has some words entered
in title case, some words typed in all caps, some words entered in
plain text.
I need to end up with this same information in all title case with
the vast majority of words in abbreviated forms.
I have set up scripts that use the calculation Substitute(WORD
Field; selected wd; abbrev wd) to find words and replace with the
desired abbreviations. I know this is case sensitive so my script
doesn't work when the WORD is typed in all caps, but the selected
word value is in title case or plain text. I can go back and repeat
the script with the word typed in all caps to get the abbreviation
right, but there has got to be an easier way.
I would like to somehow change all the information in the WORD field
to title case format, but have found that replacing the values using
TextStyleRemove
and
TextStyleAdd
to get the format I want doesn't actually work.
I also tried exporting, reformating, the reimporting. No luck.
The text looks like what I want, but then when I try my Substitute
script--the substitute doesn't work for the originally uppercase
words. And when I export the data, even with apply current
Filemaker format to data checked, the Word Field comes out with the
words in the same style as they originally entered the file.
Can anyone suggest a way to quickly solve this problem?
Thanks!
Sue
