by Falcon » Sun Jul 20, 2008 4:52 pm
Hi kookoo,
Your multi-segment text file could look like this -
a,a,a,,,,,,,,,
a,a,b,,,,,,,,,
a,a,c,,,,,,,,,
a,b,a,,,,,,,,,
a,b,b,,,,,,,,,
a,b,c,,,,,,,,,
a,c,a,,,,,,,,,
a,c,b,,,,,,,,,
a,c,c,,,,,,,,,
b,a,a,,,,,,,,,
b,a,b,,,,,,,,,
b,a,c,,,,,,,,,
b,b,a,,,,,,,,,
b,b,b,,,,,,,,,
b,b,c,,,,,,,,,
b,c,a,,,,,,,,,
b,c,b,,,,,,,,,
b,c,c,,,,,,,,,
c,a,a,,,,,,,,,
c,a,b,,,,,,,,,
c,a,c,,,,,,,,,
c,b,a,,,,,,,,,
c,b,b,,,,,,,,,
c,b,c,,,,,,,,,
c,c,a,,,,,,,,,
c,c,b,,,,,,,,,
c,c,c,,,,,,,,,
where 'a' would be a segment, 'b' a segment, and 'c' a segment for the first column, and there would be a different set of segments for abc in the second column and a different set again for the third column.
You would normally create something like this in Excel and then replace a b and c with your segment values.
Note also that the filter needs to have positions in the file equivalent to all 11 columns hence the following commas.
You can have as many columns of segments as you wish but probably 5 or 6 is enough.
Also note that a column of segments can be in any column, for example if the last column shown above was to be in column -4 instead of column -2
then it would look like this (two lines only shown)
a,a,,,a,,,,,,,
a,a,,,b,,,,,,,
etc
I have shown an array for abc - you can have any set up you wish.
Given that commas are used as separators I suggest you save the file in CSV format.
hope this helps
falcon