duplicating contents of a field

[Rob Campbell]

Oops: the last line should be:
OpenFile "+ at newRecords"

Told you I'd screw it up  ;-)




On 1/25/08, Rob Campbell <bigbenchrob at gmail.com> wrote:
>
> On 1/25/08, Barry Kahn <barryk at caravanbeads.net> wrote:
> >
> > What if each line is a different record?
> >
>
>
> local newRecordsnewRecords=""
> arraybuild newRecords,¶,"",FirstField
> OpenFile "+ at FirstField"
>
>
>
>
> I'm not able to test that right now so probably screwed it up. But the
> idea is to build an array with the existing ID numbers, then add that list
> of new 'records' (which only have data in the first field) to the database.
>
>
> Rob
>
>
>
> >
> > 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
> >
> >


-- 
Rob Campbell M.D., Ph.D.
Big Bench / Scientifica Software
web:  http://www.bigbench.com
weblog: http://www.scienceandsoftware.com
bigbenchrob at gmail.com
phone: (604) 685-8506
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://provue.com/pipermail/qna/attachments/20080125/5b6be286/attachment.html