Split Large Text Field into several smaller fields

Kenneth Brody kenbrody at bestweb.net
Fri Jan 4 05:32:30 PST 2008


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


More information about the Filepro-list mailing list