Ordering exponential notation values

Question

0.00/5 (No votes)

See more:

Hi,
I have a txt file containing related values such as these:

ColumnOne, ColoumnTwo
1.1, 0.1836856
3.3, -5.5
-0.38162, 6.636666E-08
1.01516E-07, 0.3695395

I would like to order these values using the second column then write them to a new txt file.
How can I do this without modifying any values ?
i.e. if the original file contains 6.636666E-08, then the new txt file needs to contain that value and not a converted value such as: 0.00000006636666

Thank you.

[Update]
How can read the file into a Tuple ?
Thank you

C#

var reader = new StreamReader(File.OpenRead(@"C:\MyFile.txt"));

            while (!reader.EndOfStream)
            {
                var line = reader.ReadLine();
                var values = line.Split(',');

                var val1 = decimal.Parse(values[0], System.Globalization.NumberStyles.Float);
                var val2 = decimal.Parse(values[1], System.Globalization.NumberStyles.Float);
                var val3 = values[2];

                Tuple<decimal,> myTuple = Tuple.Create<decimal,decimal,string>(val1,val2, val3);

            }</decimal,decimal,string></decimal,>

Posted 17-Oct-15 5:52am

walidm38

Updated 17-Oct-15 9:21am

Patrice T

v3

Add a Solution

Comments

PIEBALDconsult 17-Oct-15 12:08pm

Use tuples or something. Have one contain the "raw" string value and the other contain the numeric value. Sort by the numeric. Write the string.

walidm38 17-Oct-15 14:59pm

If my txt file contained similar rows to this:
1.1, 0.1836856, 5.6
3.3, -5.5, 43.44
-0.38162, 6.636666E-08, 3.1
1.01516E-07, 0.3695395, 1.5

How can read the file into a Tuple ?
Thank you

Hide Copy Code
var reader = new StreamReader(File.OpenRead(@"C:\MyFile.txt"));

while (!reader.EndOfStream)
{
var line = reader.ReadLine();
var values = line.Split(',');

var val1 = decimal.Parse(values[0], System.Globalization.NumberStyles.Float);
var val2 = decimal.Parse(values[1], System.Globalization.NumberStyles.Float);
var val3 = values[2];

Tuple<decimal,> myTuple = Tuple.Create<decimal,decimal,string>(val1,val2, val3);

}

Patrice T 17-Oct-15 15:22pm

I have used the improve question for you.

2 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)

Andreas Gieriet · Answer 1 · 2015-10-17T12:12:00

Solution 3

You may employ LINQ to objects, e.g.

C#

string filein = @"datain.txt";
var sorted = from line in File.ReadAllLines(filein)
             let record = Tuple.Create<double, string>(double.Parse(line.Split(',')[1]), line)
             orderby record.Item1
             select record.Item2;
string fileout = @"dataout.txt";
File.WriteAllLines(fileout, sorted.ToArray());

Cheers
Andi

Posted 17-Oct-15 12:12pm

Andreas Gieriet

Comments

[no name] 18-Oct-15 12:51pm

I like it so a +5. I'm not sure whether it is something Overkill for OP.

Andreas Gieriet 18-Oct-15 13:45pm

Thanks for your 5.
I was reluctant to post it. But, hey, it's showing some approaches to read a file line-wise, create a aux structure to sort/filter items and return the items again.
If it's a homework assignment, the OP has to chew something ;-) If it's for production code, I think it's worthwhile to consider such a solution.
Cheers
Andi

Patrice T · Answer 2 · 2015-10-17T09:40:00

Here is a simplified version of your code:

C#

var reader = new StreamReader(File.OpenRead(@"C:\MyFile.txt"));
 
            while (!reader.EndOfStream)
            {
                var line = reader.ReadLine();
                var values = line.Split(',');
 
                var val1 = decimal.Parse(values[1], System.Globalization.NumberStyles.Float);
                
 
                Tuple<decimal> myTuple = Tuple.Create<decimal,string>(val1,line);
 
            }
            // sort here on the decimal value
            
            // write here result to text file

</decimal>

I think myTuple should be a list
Nota: I am not a specialist of C#.