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