array ? sort? text file read

Deli Dumrul

8y965Visual Basic .NET

Hello there

I have a text file with an indeterminate size of type string and double.

I need to read this file and sort the double type from big to small

sample

bcd 1,215

efg -0.50

abc 0,125

.... .....

..... ....

thank you

8 Replies

Know the answer? Post it — somebody with the same question will find it here.

Nitin Sontakke8y ago
Accepted answer
And here is a proper C# code sample:
public class SampleClass : IComparable
{
  public String Text { get; set; }
  public Double Value { get; set; }

  public SampleClass(String text, Double value)
  {
    Text = text;
    Value = value;
  }

  public override string ToString()
  {
    return "Text = " + this.Text + ", Value = " + Value.ToString();
  }

  public int CompareTo(SampleClass other)
  {
    SampleClass y = other as SampleClass;

    if (y == null)
      return 0;
    if (Value == y.Value)
      return 0;
    if (Value > y.Value)
      return 1;
    if (Value < y.Value)
      return -1;
    return 0;
  }
}
Then...
String[] fileContents = System.IO.File.ReadAllLines(@"E:\TextFile1.txt");
List lsc = new List();
foreach (String line in fileContents)
{
  String[] lineContents = line.Split(new Char[] { ' ' });
  lsc.Add(new SampleClass(lineContents[0], Double.Parse(lineContents[1])));
}
lsc.Sort();
foreach (SampleClass sc in lsc)
{
  Console.WriteLine(sc.ToString());
}
And here is the output...
Text = KONYA, Value = -4.4
Text = ZOREN, Value = 0.124
Text = TMSN, Value = 0.19
Text = ADANA, Value = 1.52
Text = VESTL, Value = 11.57
Notice how .ToString() is used.
Deli Dumrul8y ago
Dear Nitin and Navi

im grateful to you

thank you so much
Nitin Sontakke8y ago
I just noticed that you wanted to have it sorted in reverse order. So we just modified the following piece of code as follows:
if (Value < y.Value)
  return 1;
if (Value > y.Value)
  return -1;
All we did is swapped the < and >.
Hope it helps!
Ravi Sangtani8y ago
Hi @Deli

if their is comma in digit then it throws an error so you have to replace by..

no[i] = Convert.ToDouble(arr[i].Split(' ')[1].Replace(",",""));
Deli Dumrul8y ago
mey text file is here

ADANA 1.52
KONYA -4.4
ZOREN 0.124
VESTL 11.57
TMSN 0.19
Nitin Sontakke8y ago
In your data I am seeing both a . and ,. I assume that . is a decimal digit. Is that right? I also assume that , is used as a thousand separator. Are these assumptions correct? Please respond. This is very important while providing solution.
Deli Dumrul8y ago
Hi again

I get an error on this line

no[i] = Convert.ToDouble(arr[i].Split(' ')[1]);
Ravi Sangtani8y ago
Hi @Deli

try this may help you....

string[] arr = System.IO.File.ReadAllLines("E:\\sample.txt");
string[] name = new string[arr.Length];
double[] no = new double[arr.Length];
for (int i = 0; i < arr.Length; i++)
{
name[i] = arr[i].Split(' ')[0].ToString();
no[i] = Convert.ToDouble(arr[i].Split(' ')[1]);
}

bool flag = true;
double temp;
string t1;
int numLength = no.Length;
for (int i = 1; (i <= (numLength - 1)) && flag; i++)
{
flag = false;
for (int j = 0; j < (numLength - 1); j++)
{
if (no[j + 1] > no[j])
{
t1 = name[j];
name[j] = name[j + 1];
name[j + 1] = t1;
temp = no[j];
no[j] = no[j + 1];
no[j + 1] = temp;
flag = true;
}
}
}
for (int i = 0; i < no.Length; i++)
{
Console.WriteLine(name[i]+" "+no[i]);
}