Re: Rapid/Globall Update
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
- Date: Fri, 15 Apr 2005 09:07:15 -0400
- From: Elizabeth Thomsen <et at noblenet dot org>
- Subject: Re: Rapid/Globall Update
Yes, it's possible to add something to the end of a variable field in
global update. Use "change variable field," specify the field, and
don't put in any data to replace. In the replace line, put the suffix
you want to add. I don't know why this works, but the system seems to
decide that since it can't find "nothing" it might as well just stick
the data at the end of the existing field.
Of course, you should test this first, but it works for us.
Jeff Wesson wrote:
Is there a way in rapid update/globall update to update the field to whatever the field is + something else, say add a 'z' to the end of the field.
Row 1 XY
Row 2 AB
Row 3 BC
these would now be changed to
Row 1 XYZ
Row 2 ABZ
Rows 3 BCZ
If i was doing this in SQL i would use:
UPDATE [Table] SET [Table]. [Field] = [Field] & "Z"
--- StripMime Report -- processed MIME parts ---
text/plain (text body -- kept)
This message was distributed through the Innovative Users Group INNOPAC list
Public replies: INNOPAC at innopacusers dot org
Update your subscription options: http://innopacusers.org/mailman/listinfo/innopac
Elizabeth Thomsen, Member Services Manager
NOBLE: North of Boston Library Exchange
Danvers MA 01923
et at noblenet dot org