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: "Pitcher, George" <email@hidden>
- Date: Mon, 29 Jan 2001 07:00:26 -0000
kevin,
a non-AS solution could be to have another 'clean_text' field in FM which
would be a calc field (data type text) withe the following calc:
substitute(text,":'",":")
This would do exactly what you want, but the restriction of holding your
text in a clac field would apply.
George P, Edinburgh
>
-----Original Message-----
>
From: Kevin Morrison [mailto:email@hidden]
>
Sent: 26 January 2001 22:30
>
To: email@hidden
>
Subject: Cleaninig Up Text in a FM Text Field
>
>
>
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