You are right data is not obvious, sorry for this, I am not familiar with html codes. My input data is exactly as you predicted:

      1234 2321 0      45    1st
      2122 sdsa 0   0  34    
      2313 dsad        43    2nd    
      1232 ffff 0   0        1st 
      3213 sadf     0  34    
      2133 dada 0            2nd
[download]

As it is seen, there is different number of spaces between columns. So /\s/ is not working as well as /\s+/ is not working, because some columns have whitespace characters. Also substr function does not work due to same reason. Substr does not see whitespace character and passes to next column. I hope told my problem clearly:)

To answer your question, it is necessary to know more about your data. There are 6 columns and in your sample the third and fourth columns are 0 or blank. Is it possible that they could be a 2 or 3 digit number, like 33 or 123? Is the fifth column always a 2 digit number like 45, 34, 43... or could it be 1 digit (or 3 digits)? Its hard to tell with this data whether fields fill in from the left or right.

And I'm guessing that the leading whitespace before the 1st column isn't really there, but is just the way you pasted it in.

This is a small piece example data of our real data which is a telecommunication company parameters. So yes, third and fourth columns can also be between 0-100; and fifth column can be 0-300. Sequenly, from third column to last column, there can be blanks. Finally, leading whitespace before the 1st column isn't really there. Please help me, I should split those columns exactly. Problem I cannot pick up blanks, instead of that I can pick up next columns' values. That s the point. Substr or solutions that given from are not working.