How do I loop through a string and convert figures in it.

Question

2.45/5 (4 votes)

See more:

Hi All

I want to convert figures with ending with "'" to meters in a string.

e.g I have

The core heavily broken from 239'-242': 23'-28' with a core recovery of 25%.

I want this

The core heavily broken from 72.85-73.76: 7.01-8.53 with a core recovery of 25%.

Please I need help.

Posted 28-Aug-14 5:04am

wizy@2020

Add a Solution

Comments

[no name] 28-Aug-14 11:20am

Okay.... what is it that you need help with?

3 solutions

Solution 1

You can split them using the Split() method on the string. Split on ' and then loop through the results.

Something like:

C#

foreach (String str in stringVar.Split("'"))
{
  // do your thing
}

Posted 28-Aug-14 5:35am

ZurdoDev

Comments

wizy@2020 29-Aug-14 5:22am

What if I have something like this

QUARTZ with minor schist partings from 7'8''-8'2''

I want
QUARTZ with minor schist partings from 2.34-2.49

ZurdoDev 29-Aug-14 7:27am

You'll have to parse the data. There is no magic to just do what you want. You'll have to finish the code.

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)

Yvan Rodrigues · Accepted Answer · 2014-08-28T05:43:00

Solution 2

Off the top of my head:

C#

using System.Text.RegularExpressions;

static string Convert(string value)
{
    return Regex.Replace(value, @"([\d.]+)'", m => (
        float.Parse(m.Groups[1].Value) * 0.3048 +     // Convert feet to metres
        m.Groups[2].Success ? float.Parse(m.Groups[1].Value) * 0.0254 : 0     // Convert inches to metres.
    ).ToString());
}

What is says is:

Find all occurrences of a number followed by an apostrophe.
Convert the numerical value to metres.
Substitute all occurrences.

Posted 28-Aug-14 5:43am

Yvan Rodrigues

Updated 29-Aug-14 3:19am

v2

Comments

wizy@2020 29-Aug-14 5:20am

I am very happy with your solution.

But in case I have something like this

QUARTZ with minor schist partings from 7'8''-8'2''

I want
QUARTZ with minor schist partings from 2.34-2.49

Yvan Rodrigues 29-Aug-14 9:19am

Solution updated.

Yvan Rodrigues 29-Aug-14 9:20am

PS: Regular Expressions are pretty amazing. Read http://www.codeproject.com/Articles/9099/The-Minute-Regex-Tutorial. It will change your life.

RaisKazi 29-Aug-14 9:25am

My 5.

OriginalGriff · Accepted Answer · 2014-08-28T05:52:00

Solution 3

First, extract your numbers-ending-in-quote with a regex.
You can then use the Regex.Match overload that takes a MatchEvaluator as teh second parameter to feed each match individually to a function, which returns the new string.

C#

Regex regex = new Regex(@"\d+(?=')");
string replaced = regex.Replace(inputString, new MatchEvaluator(ReplaceMatch));

The ReplaceMatch method would be along the lines of:

C#

private string ReplaceMatch(Match m)
    {
    double feet = double.Parse(m.Value);
    return string.Format("{0:N2}", feet * 0.3048);
    }

Posted 28-Aug-14 5:52am

OriginalGriff

Comments

wizy@2020 29-Aug-14 5:21am

I like your suggestion.

But in case I have something like this

QUARTZ with minor schist partings from 7'8''-8'2''

I want
QUARTZ with minor schist partings from 2.34-2.49

OriginalGriff 29-Aug-14 5:55am

So all you have to do is change the regex and the method to cope with it.
Probably, the regex would have two groups (one for feet, one for inches so the feet could be optional) and the method would use the Match.Groups to do one or two conversions depending on the input.