Visual studio read a text file to an array and sort the array and then copy certain lines only to a listbox

Question

0.00/5 (No votes)

See more:

Hello!

Using Visual Studio 2015.
I am reading a text file into an array. Text file data looks like this:

Cell 1, 435
Cell 1, 655
Cell 2, 923
Cell 1, 233
Cell 2, 222

Reading the text file works properly. The array has the data as it should be. I am just using the array.sort and it seems to be working and placing the data in the proper order.

I need to be able to sort the array on the Cell #.
Next I need to be able to take only a line with Cell 1 or Cell 2 in it and and display the whole line results into listboxes.

Thank you for any help

What I have tried:

I can only loop through the whole array and display it in the listbox. I am unable to select individual lines based on the Cell #

Posted 19-May-18 5:58am

Member 13814386

Updated 19-May-18 6:24am

Add a Solution

Comments

Richard MacCutchan 19-May-18 12:11pm

Does your array contain just the strings above, or are you splitting the lines into their separate fields? Doing the latter would mean you can easily combine fields for the same cell into a string and display the data that way.

1 solution

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 · 2018-05-19T06:25:00

To sort on the cell number, you need to "explore" each line, and extract the cell number, convert it to a numeric value, and then sort the array by that. Sorting an array of strings sorts them using string comparison which compares two strings character by character, and the result of the entire comparison is based on the first difference.
So your sort order would be

Cell 1
Cell 10
Cell 11
...
Cell 19
Cell 2
...

The simplest way to do what you want is to write a static method which compares two strings and returns an integer:

C#

public static int CompareLines(string a, string b)
   {
   ...
   }

And use it using the Array.Sort override that accepts a delegate:

C#

Array.Sort(myArrayOfStrings, ComapareLines);

When you write the the method, it should return -1 if a is before b, 0 if they are the same, and 1 if b is before a.