Text to multiple columns

Question

1.00/5 (1 vote)

See more:

Hi friends,
I am in a trouble, I have a list like below

CSS

1181     1003 /LW2A      1   W14X68            A992          16'-3 1/2"   id:7959532
1182     1000 /LW1A      1   W12X53            A992          16'-3 1/2"   id:8085877
1182     1008 /LW5A      1   W12X53            A992          16'-3 1/2"   id:8085856
1183     1005 /LW3A      1   W30X90            A992          16'-3 1/2"   id:7957895
1184     1005 /LW3A      1   W24X94            A992          16'-3 1/2"   id:7958098
1184     1008 /LW5A      1   W24X94            A992          16'-3 1/2"   id:7957812
1184     1008 /LW5A      1   W24X94            A992          16'-3 1/2"   id:7957913
1184     1008 /LW5A      1   W24X94            A992          16'-3 1/2"   id:7958116
1185     1001 /LW1B      1   W16X77            A992          14'-5 1/4"   id:3434205
1185     1001 /LW1B      1   W16X77            A992          14'-5 1/4"   id:3434226
1185     1001 /LW1B      1   W16X77            A992          14'-5 1/4"   id:3434240
1185     1001 /LW1B      1   W16X77            A992          14'-5 1/4"   id:3434247
1185     1001 /LW1B      1   W16X77            A992          14'-5 1/4"   id:4061137
1185     1001 /LW1B      1   W16X77            A992          14'-5 1/4"   id:4061152
1185     1001 /LW1B      1   W16X77            A992          14'-5 1/4"   id:4061434
1185     1001 /LW1B      1   W16X77            A992          14'-5 1/4"   id:4063687
1186     1001 /LW1B      1   W16X89            A992       29'-10 15/16"   id:3434142

I want to split each lines wherever tab is coming ,I used

string[] columns = Regex.Split(line, @"\t");

but it is not working. Please help me on this...
Note: The words may contain maximum two spaces

Thanks and regards,
Manuprasad M

Posted 19-Jan-15 20:34pm

Manu Prasad

Add a Solution

Comments

Praveen Kumar Upadhyay 20-Jan-15 2:55am

Can you mention the object that you want in your array.

Manu Prasad 20-Jan-15 3:12am

String

BillWoodruff 20-Jan-15 6:58am

What is an example ... from the table above ... of a word that contains two spaces ?

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Answer 1 · 2015-01-19T21:06:00

Solution 1

A very quick test here:

C#

string test = "9199\t6345\t2421\tAC62\t14BX\tCNY0";
string[] columns = Regex.Split(test, @"\t");
foreach (string s in columns)
    {
    Debug.WriteLine(s);
    }

Says that the regex breaks the string correctly:

9199
6345
2421
AC62
14BX
CNY0

So I suggest that it's a data problem: check that the columns are separated by TAB characters (use a Hex Editor - PSPad[^] is what I use and it has a Hex mode) and if it is, show use exactly what the input is, the output is, and what you expect the output to be.

Posted 19-Jan-15 21:06pm

OriginalGriff

Comments

Manu Prasad 20-Jan-15 3:15am

Hello,
I think you are correct its not TAB, they used padding while creating the list. Any other options ?

Abhinav S 20-Jan-15 3:22am

If they are using padding with fixed number of characters, then try to split on spaces.

Manu Prasad 20-Jan-15 3:26am

See the words itself contains spaces..

Abhinav S 20-Jan-15 4:53am

Right. But is the space setting fixed between two words in the csv?

Abhinav S · Answer 2 · 2015-01-19T21:21:00

Solution 2

There could be multiple tabs e.g. \t\t.
Or they could be using padding or blank spaces along with the tab.

Try to find out the exact character set that separates data.

Posted 19-Jan-15 21:21pm

Abhinav S

Manu Prasad · Answer 3 · 2015-01-19T21:24:00

Solution 3

Thanks all,
Its working now I used,

string[] columns = Regex.Split(line, @"\s{2,}");

-Manuprasad

Posted 19-Jan-15 21:24pm

Manu Prasad