how to read a text file with mixed string and integer and without separated value

Question

0.00/5 (No votes)

See more:

hi
I have a text file with mixed string and integer like this:
X12 Y0.4 Z8
X4.5 Y231 Z32.4
Y0.4 Z8
X54 Y5.11 Z9
Y78 Z68
.
.
.

I have only X,Y,Z in text file
I Always have Y,Z but may not have X
I defined double x,y,z in my program,
how i can read integers in each line and save their values as x,y,z?
Should I use the pattern? how i can write a pattern for this text file?
please help me

Posted 17-Feb-13 20:46pm

fika_fa

Updated 17-Feb-13 21:37pm

v6

Add a Solution

Comments

Saurabh_Damle 18-Feb-13 3:14am

Will all the lines contain X,Y and Z values only or it will contain more such patterns.
e.g.
1. X12Y0.4Z8 - Only X,Y and Z
2. X12Y0.4Z8A24 - In this case along with X,Y,Z we have A.

fika_fa 18-Feb-13 3:30am

I modify my question
only X,Y,Z
Always have Y,Z but may not have X
like this:
X12 Y0.4 Z8
X4.5 Y231 Z32.4
Y0.4 Z8
X54 Y5.11 Z9
Y78 Z68

2 solutions

Solution 2

Do you have pattern like X12 Y0.4 Z8, in this case I can see a space character in between. If that is the case then you can just split the string with space character. As you said X may or may not be present and that can be determined on the basis of number of items the resultant array holds. You can then get the respective value by replacing X,Y or Z accordingly.

If space is not present in between...
In this case also you can check if X exists in the line and use substring to get numeric part.

Posted 17-Feb-13 21:55pm

Saurabh_Damle

Updated 17-Feb-13 21:56pm

v2

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 · Accepted Answer · 2013-02-17T21:15:00

Personally, I would use a regex:

(?<key>[a-zA-Z]+)(?<value>(\d*\.\d+)|(\d+))

Should do it.

[edit]Encoded HTML - damnit! - OriginalGriff[/edit]

Long update from OP

You could, but it's pretty horrible to maintain.
Did you know that you can get more than one Match from a regex?
Try this:

C#

Regex regex = new Regex(@"(?<key>[a-zA-Z]+)(?<value>(\d*\.\d+)|(\d+))");
float x = 0.0F, y = x, z = x;
string[] lines = File.ReadAllLines(pathToFile);
foreach (string line in lines)
    {
    foreach (Match m in regex.Matches(line))
        {
        string key = m.Groups["key"].Value;
        string val = m.Groups["value"].Value;
        float f;
        if (float.TryParse(val, out f))
            {
            switch (key)
                {
                case "X": x = f; break;
                case "Y": y = f; break;
                case "Z": z = f; break;
                }
            }
        }
    Console.Write("{0},{1},{2}", x, y, z);
    }