Re: Cleaninig Up Text in a FM Text Field
Re: Cleaninig Up Text in a FM Text Field
- Subject: Re: Cleaninig Up Text in a FM Text Field
- From: Jed Verity <email@hidden>
- Date: Mon, 29 Jan 2001 10:24:57 -0800
Sorry if I'm late on this...somebody has probably already suggested it.
I would just use FMP's Substitute function.
Set Field [field1, Substitute(field1,":,",":")]
HTH,
Jed
On 1/26/01 7:23 PM, The Great Michelle Steiner blessed me with these words:
>
On 1/26/01 2:30 PM, Kevin Morrison <email@hidden> wrote:
>
>
> I want to clean it up so that everytime it has ":," that it is replaced with
>
> only ":"
>
>
>
> This field might have this occurring in it 5 or 6 times. Any insights as to
>
> a quick clean up are much appreciated!
>
>
set TextToBeconverted to "this is a test:, this is only a test:, it is."
>
my convert(TextToBeconverted)
>
>
to convert(teststring)
>
set {TID, AppleScript's text item delimiters} to,
>
{AppleScript's text item delimiters, ":,"}
>
set teststring to text items of teststring
>
set AppleScript's text item delimiters to ":"
>
set teststring to teststring as string
>
set AppleScript's text item delimiters to TID
>
return teststring
>
end convert
>
>
--Michelle
>
>
----------------------------------------------------------------------
>
| Michelle Steiner | Hard as it may be to believe, my |
>
| email@hidden | life has been based on a true story. |
>
----------------------------------------------------------------------
>
_______________________________________________
>
applescript-users mailing list
>
email@hidden
>
http://www.lists.apple.com/mailman/listinfo/applescript-users
>
~)~)~)~)~)~)~)~)~)~)~)~)~)
Jed Verity