duplicating contents of a field

[Gary Yonaites]

On Jan 25, 2008, at 4:25 AM, Barry Kahn wrote:

>  I have a database and would like to duplicate the existing items  
> in one of the fields and have them appended to the same field. Say,  
> for example, field 1 contains:
>
> A
> B
> C
> D
> E
>
> I would like a way to duplicate and append to get:
>
> A
> B
> C
> D
> E
> A
> B
> C
> D
> E
>
> without changing any of the data in any of the other fields. Is  
> there an easy way to do that?

Assuming your example is only a single record in the field with  
multiple lines of text and not each line representing a different  
record, this should be very simple with a FormulaFill from the menu  
or with a procedure. Use myField+chr(13)+myField as the formula in  
the FormulaFill changing myField to your field name and you will get  
each record doubled up with a new return in between.

Gary
gary at yonaites.com

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://provue.com/pipermail/qna/attachments/20080125/7554fa84/attachment.html