Merging columns into single
Posted: Mon Feb 11, 2008 11:54 pm
I have one input file around 2000 fixed width columns.I have to search text from this columns.
Directly i can't search from multiple columns, so i thought of merging all columns into one single column.This i'm doing by using a ":" operator in stage variable.
E.g:
col1(5) col2(2) col3(3) StageVarcol1:col2:col3)
"abc " "xx" "yy " "abc xxyy "
But the size is so huge it's throwing an error "Run time error(6) overflow"
Is this the right way of merging all columns into one single column?
Please help me out...
Directly i can't search from multiple columns, so i thought of merging all columns into one single column.This i'm doing by using a ":" operator in stage variable.
E.g:
col1(5) col2(2) col3(3) StageVarcol1:col2:col3)
"abc " "xx" "yy " "abc xxyy "
But the size is so huge it's throwing an error "Run time error(6) overflow"
Is this the right way of merging all columns into one single column?
Please help me out...