Split Large Text Field into several smaller fields

Scott Walker ScottWalker at RAMSystemsCorp.com
Fri Jan 4 06:02:06 PST 2008


Thanks to all who gave me ideas on splitting this text up.  I decided to
use the 5.6 version to do it since it has the "Wordwrap" feature.
Worked great and took about 2 minutes to implement.

Regards,

Scott


Scott Walker
RAM Systems Corp.
ScottWalker at RAMSystemsCorp.com
Ph: (704) 896-6549
Fx: (704) 896-7458





-----Original Message-----
From:
filepro-list-bounces+scottwalker=ramsystemscorp.com at lists.celestial.com
[mailto:filepro-list-bounces+scottwalker=ramsystemscorp.com at lists.celest
ial.com] On Behalf Of Kenneth Brody
Sent: Friday, January 04, 2008 8:33 AM
To: Scott Walker
Cc: Filepro_List
Subject: Re: Split Large Text Field into several smaller fields

Quoting Scott Walker (Thu, 3 Jan 2008 16:16:37 -0500):

> Does anyone have a couple of lines of code to take a 200 character
> description field (I imported it from a customer supplied text file)
and
> break it up into (4) 54 character description fields (how my filePro
> application has it stored).  I don't want it to break in the middle of
a
> word or Part# so I guess it has to know when it does not have enough
> room left for word it is on and therefore should not put it in the
> current description field but start at that point as it puts data into
> the next description field.
>
> I know I can figure this out but I hoped someone might already have
> invented this wheel.

Take a look at the WORDWRAP() function.

-- 
KenBrody at BestWeb dot net        spamtrap:
<g8ymh8uf001 at sneakemail.com>
http://www.hvcomputer.com
http://www.fileProPlus.com
_______________________________________________
Filepro-list mailing list
Filepro-list at lists.celestial.com
http://mailman.celestial.com/mailman/listinfo/filepro-list




More information about the Filepro-list mailing list