sujittalukde
04-02-2011, 03:43 AM
I have a text file and want to split each and every data after the delimiter ^ for each line and take the values in an array for each line.
For eg, Line 1 is like this:
1^FH^SL1^R^16032011^1^D^MUMN77777A^1^NSDLRPU2.4^^^^^^^
The array should store value like this:
1,FH,SL1,R,16032011,1,D,MUMN77777A,1,NSDLRPU2.4
and dump this data in each colum of Row 1 of Sheet 1
Then Line2
Do the same thing. In this case, each column of Row 2 and so on till the last line of the file.
regards
For eg, Line 1 is like this:
1^FH^SL1^R^16032011^1^D^MUMN77777A^1^NSDLRPU2.4^^^^^^^
The array should store value like this:
1,FH,SL1,R,16032011,1,D,MUMN77777A,1,NSDLRPU2.4
and dump this data in each colum of Row 1 of Sheet 1
Then Line2
Do the same thing. In this case, each column of Row 2 and so on till the last line of the file.
regards