On Thu, 15 Nov 2007 15:16:00 -0800, sfleck
wrote:

Below is an example of a strring of data that i receive. Many times the data
string is over 255 characters in length. ( bigger that the capacity of the
location that i am copying it to.

Is there a way to programatically parse out those strings longer than
allowed in my field

I need to do that to a text string that is both comma deliminated ( item &
quatity) and semicolon deliminated (Record)

262662,1;287740,1;266043,1;265832,1;283351,1;2988 64,1;292744,1;301754,1;302201,1;283346,1;296536,1; 292910,1;274865,1;293748,1;77029,1;47952,1;295392, 1;292327,1;273352,1;276065,1;256396,1;269669,1;269 671,1;82205,1;301349,1;269668,1;260051,1;81462,1;2 69670,1;302623,1;281220,1;297459,1;257806,1;271241 ,1

The item is not always the sam# of characters and the quantiy either

Is there a way to take all text including Say (10) semicolons

That is certainly possible:

=LEFT(A1,FIND(CHAR(1),SUBSTITUTE(A1,";",CHAR(1),10 ))-1)

will give the leftmost characters up to but not including the 10th semicolon.

But is that what you really want?

You can split your string in many ways. The above, on your sample string,
gives 89 characters.

Perhaps you should be more specific in what you want to do, though.


--ron