duplicating contents of a field

[Barry Kahn]

What if each line is a different record?

Thanks,
bk



> 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
>
> _______________________________________________
> Qna mailing list
> Qna at provue.com
> http://provue.com/mailman/listinfo/qna

Barry Kahn
Caravan Beads, Inc.
915 Forest Ave
Portland ME 04103
800-230-8941
fax: 207-874-2664
www.caravanbeads.net
barryk at caravanbeads.net





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