aloustan
10-07-02, 16:53
| Hi There , I am looking for a function (or a class) similar to scatter. However, instead of pasting a whole record into an array, I would like to paste an expression into an array. This expression is a field in a table and it has different values delimited by commas (in the same field). I wonder if there is a function class in this frame work which would allow me to scatter each value of this field into a seprate array cell. For instance, I have this expression: "box,cs,bx" Each value is delimited by commas. So I want to copy each value to an array; let's say A[i] where i=1,2,3 So A[1] = "box" A[2]="cs" A[3]="bx" This example is containing 3 values with length between 2 and 3 characters. But we could have an expression with 4, 5 6, ...X values and lengths between 1 to 4 characters. The ideal function should be able to work for any of these scenarios. How could this be acomplished? Thanks for your help! |