Converting Google Maps distance measurements in decimal miles to int32 format

Question

Converting Google Maps distance measurements in decimal miles to int32 format

I am currently working on a project where I have an Asp.net text box that is being automatically populated by JavaScript using the Google Maps API. The text in the textbox can display varying distances ranging from 40.2 miles to 1,634 miles and so on.

My main goal is to extract the numerical value from the text box and convert it into an integer for storage in the database.

The challenge lies in ensuring that the extracted number is always in a rounded format, such as "40" or "1634", without any decimal points or extra characters.

I have attempted methods like Substring and Math.Round, but unfortunately, I keep encountering exceptions. Here is my latest try:

        string miles = txtEstDistance.Text;
        miles.Substring(0, miles.IndexOf('.') > 0 ? miles.IndexOf('.') : miles.Length);

        int oDistanceMiles = Convert.ToInt32(miles);

However, I am consistently getting the exception: "Input string was not in a correct format." specifically for this line of code:

int oDistanceMiles = Convert.ToInt32(miles);

I am feeling quite lost at this point. Using .Net 4.0 with C# programming language.

javascript asp.net math substring

Answer 1

Answer №1

How about removing the " mi" first and then treating the remaining value as a floating-point number? Utilizing Math.Round, you can round it to the nearest whole number and then convert it to an integer.

Assuming that the NumberStyles.Float enum will automatically eliminate any leading or trailing white spaces. Additionally, you have the option of using string.Trim().

var distanceInMiles = txtEstDistance.Text;

distanceInMiles = distanceInMiles.Substring(0, distanceInMiles.IndexOf("mi"));

float temporaryDistance;
var result = float.TryParse(distanceInMiles, NumberStyles.Float, CultureInfo.InvariantCulture, out temporaryDistance);

if (result)
{
    var roundedDistance = Convert.ToInt32(Math.Round(temporaryDistance, 0));

    // alternatively

    roundedDistance = (int)Math.Round(temporaryDistance, 0);
}

Answer 2

How about removing the " mi" first and then treating the remaining value as a floating-point number? Utilizing Math.Round, you can round it to the nearest whole number and then convert it to an integer.

Assuming that the NumberStyles.Float enum will automatically eliminate any leading or trailing white spaces. Additionally, you have the option of using string.Trim().

var distanceInMiles = txtEstDistance.Text;

distanceInMiles = distanceInMiles.Substring(0, distanceInMiles.IndexOf("mi"));

float temporaryDistance;
var result = float.TryParse(distanceInMiles, NumberStyles.Float, CultureInfo.InvariantCulture, out temporaryDistance);

if (result)
{
    var roundedDistance = Convert.ToInt32(Math.Round(temporaryDistance, 0));

    // alternatively

    roundedDistance = (int)Math.Round(temporaryDistance, 0);
}

Answer 3

Answer №2

When a dot is missing, the string appears as 40 mi, necessitating the use of a space.

miles.Substring(0, miles.IndexOf('.') > 0 ? miles.IndexOf('.') : miles.IndexOf(' '));

Answer 4

When a dot is missing, the string appears as 40 mi, necessitating the use of a space.

miles.Substring(0, miles.IndexOf('.') > 0 ? miles.IndexOf('.') : miles.IndexOf(' '));

Converting Google Maps distance measurements in decimal miles to int32 format

Answer №1

Answer №2

Similar questions

Avoiding conflicts between API calls in React's ComponentDidMount and ComponentDidUpdate phasesNote: The original text does not provide

Creating a Piechart in Kendo UI that is bound to hierarchal remote data

Leveraging log (or any other object from index.js) within nodejs modules

What is the best way to remove an object from a complex JavaScript array structure?

Error: The src for the image of the double cheeseburger could not be properly parsed by the `next/image` component

Is it possible for Express in Node.js to handle multiple static folders at once?

The Bootstrap drop-down feature refuses to open

Why is the updated index.html not loading with the root request?

Error in Javascript: Character class range is not in order

Access the value from a JArray element that contains varying values

Navigating to the HTTPS webpage

Transferring input data between two HTML files in Electron with a secure login feature

The getElementById function can only select one option at a time and cannot select multiple options

JavaScript does not allow executing methods on imported arrays and maps

Showing and hiding nested Form Group validation in Angular 4 is a crucial feature that can improve

Why won't the CSS update in Next.js when the local state variable changes on page load?

Display a <div> every hour

Combining Nested Objects in MongoDB

In a React Native application, images sourced from the database fail to display after the first initial view

Interactive Zoomable Tree with d3.js