Re: Rapid/Globall Update

[Elizabeth Thomsen <et at noblenet dot org>]

Quick answer:

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:
>  
> Quick question:
>  
> 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"
>  
> Cheers
>  
> Jeff
>
>
>
> --- StripMime Report -- processed MIME parts ---
> multipart/alternative
>   text/plain (text body -- kept)
>   text/html
> ---
> --
> 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