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