Split Large Text Field into several smaller fields
GCC Consulting
gccconsulting at comcast.net
Thu Jan 3 13:36:04 PST 2008
> -----Original Message-----
> From: filepro-list-
> bounces+gccconsulting=comcast.net at lists.celestial.com [mailto:filepro-
> list-bounces+gccconsulting=comcast.net at lists.celestial.com] On Behalf
> Of Scott Walker
> Sent: Thursday, January 03, 2008 4:17 PM
> To: Filepro_List
> Subject: Split Large Text Field into several smaller fields
>
> 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.
>
> Regards,
>
> Scott
>
>
> Scott Walker
Scott,
What version of FP are you running?
If you have 5.6 you could use the word-wrap function to divide up this
field. I am currently doing this with a form letter which prints different
paragraphs depending on a specific code in the record.
Richard Kreiss
GCC Consulting
More information about the Filepro-list
mailing list