I have an address file containing a few hundered thousand rows of data.
The max character lines for my lables is 60 and unfortunatly a large number of the fields exceed this limit.
I need to create a string somthing to the effect of:
delimination
if len(A2<60) end
if len(A2>60) then
if character 60 isblank then deliminate = 60
if character 60 not isblank then deliminate at blank < 60
It makes more sence in my head.
Any suggestions?
Last edited by sirlink; 05-22-2009 at 01:52 PM.
Maybe like this:
Please Login or Register to view this content.
Entia non sunt multiplicanda sine necessitate
That is almost perfect. I need to preserve the information
IE
Colmn A
"WEINBERG, GRIFFITH, TUCKER AND JONES PA., PROFIT SHARING PLANAND TRUST - DTD 12/21/87"
Would be
Colmn A
"WEINBERG, GRIFFITH, TUCKER AND JONES PA., PROFIT SHARING"
Column B
"PLANAND TRUST - DTD 12/21/87"
Try this:
Please Login or Register to view this content.
Last edited by shg; 05-22-2009 at 12:18 PM.
Perfection!!!
You're welcome. Would you please mark the thread as Solved?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks