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: Eric Waters <email@hidden>
- Date: Fri, 26 Jan 2001 16:44:35 -0800
Kevin-
you can use a filemaker script to do this as follows:
create a calculation field "body.calc" with the following calculation:
If(Right(body, 2) = ":,", Left(body, Length(body) - 1), body)
then either use the body.calc field to display your information or
set up a script to replace data in the body field with a calculated
result based on the same calculation.
I have a field in a FM database called "Body". It tends to collect text that
has ":," (I've added the quotes).
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!
Kevin
Kevin Morrison
Dorian Studios, Inc
_______________________________________________
applescript-users mailing list
email@hidden
http://www.lists.apple.com/mailman/listinfo/applescript-users
--
WWWWWWWWWWWWWWWWW
Eric Waters
Systems Trainer - Office of Institutional Communications
Southwest Educational Development Laboratory - SEDL
Austin, Texas 78701
800-476-6861 ext. 329
web:
http://www.sedl.org