Re^3: To split with spaces

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.

Comment on Re^3: To split with spaces

Replies are listed 'Best First'.
Re^4: To split with spaces by gorkemsarikaya (Novice) on Aug 05, 2013 at 21:18 UTC
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.	[reply]
Re^5: To split with spaces by Loops (Curate) on Aug 05, 2013 at 21:24 UTC
Please just give examples of data that aren't handled by the given solutions. People can only work with what you give them. Those solutions worked for the data you presented, so if they don't work for your entire sample, you failed to provide enough data to fully define the problem. Please help us.	[reply]