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
