I am not able parse Close value example close has "7,324.55" its is giving as 4550. string clsd = columns[8].Replace("\"", ""); bool isCloseParsed = false; var close = 0.0f; if (clsd.Contains(",")) { string newclsd = clsd.Replace(",", ""); isCloseParsed = float.TryParse(newclsd, out close); } else { isCloseParsed = float.TryParse(clsd, out close); } Included sample data @page "/NSEInd" @using Microsoft.AspNetCore.Components.Forms @using System.Globalization @using Microsoft.ML @using Microsoft.ML.Data @using Microsoft.ML.Transforms.TimeSeries @inject IJSRuntime JSRuntime @using System.Text.Json <h3>Upload CSV File</h3>

Cannot parse "7,345.55" to 7344.55 maui blazor

Accepted answer

Yonglun Liu (Shanghai Wicresoft Co,.Ltd.) 49,126 Microsoft External Staff

Hello,

After testing your code, there is no problem with the way the number is parsed. 7,344.55 can be converted to 7344.55 and displayed in the Blazor page. This should be a problem when you set the Blazor page code variable.

You can refer to the following runnable code.


<p role="status">@close</p>

 

<button class="btn btn-primary" @onclick="@Replace">Click me</button>

 

@code {

    private string str = "7,344.55";

    private float close;

    private void Replace()

    {

        bool isCloseParsed = false;

        if (this.str.Contains(","))

        {

            string newclsd = this.str.Replace(",", "");

            isCloseParsed = float.TryParse(newclsd, out this.close);

 

        }

        else

        {

            isCloseParsed = float.TryParse(this.str, out this.close);

        }

    }

}

Best Regards,

Alec Liu.

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Kalyan A 440

Here is the working code , there are commas within double quotes these should be ignored example

"1,112.45"

A regex is used then parse has been changed to Allow Thousands got these suggestions from Copilot github copilot

"Date ","series ","OPEN ","HIGH ","LOW ","PREV. CLOSE ","ltp ","close ","vwap ","52W H ","52W L ","VOLUME ","VALUE ","No of trades "

"05-Mar-2025","EQ","1,056.80","1,118.65","1,055.00","1,057.95","1,112.45","1,112.70","1,103.00","1,621.40","995.65","37,85,743","4,17,56,71,834.00","1,84,169"

"04-Mar-2025","EQ","1,047.95","1,063.00","1,036.50","1,053.05","1,056.80","1,057.95","1,052.28","1,621.40","995.65","17,88,886","1,88,24,09,434.45","1,10,647"

"03-Mar-2025","EQ","1,074.95","1,081.00","1,040.60","1,069.40","1,053.05","1,053.05","1,053.27","1,621.40","995.65","22,74,285","2,39,54,46,236.30","92,207"

@page "/NSEInd"
@using Microsoft.AspNetCore.Components.Forms
@using System.Globalization
@using Microsoft.ML
@using Microsoft.ML.Data
@using Microsoft.ML.Transforms.TimeSeries
@inject IJSRuntime JSRuntime
@using System.Text.Json
@using System.Text.RegularExpressions
<h3>Upload CSV File</h3>
<InputFile OnChange="HandleFileSelected" />
@if (csvData != null && csvData.Count > 0)
{ 
    <h4>Original CSV Data</h4>
    <table class="table">
        <thead>
            <tr>
                <th>Date</th>
                 
                <th>Close</th>
                 
            </tr>
        </thead>
        <tbody>
            @foreach (var row in csvData)
            {
                <tr>
                    <td>@row.Date.ToString("yyyy-MM-dd")</td>
                    
                    <td>@row.Close</td>
                     
                </tr>
            }
        </tbody>
    </table>
}
@if (forecastedValues != null && forecastedValues.Length > 0)
{
    <table class="table">
        <thead>
            <tr>
                <th>Forecasted Day</th>
                <th>Forecasted Close</th>
            </tr>
        </thead>
        <tbody>
            @for (int i = 0; i < forecastedValues.Length; i++)
            {
                <tr>
                    <td>@i</td>
                    <td>@forecastedValues[i]</td>
                </tr>
            }
        </tbody>
    </table>
}
<!-- Create Chart on the page load -->
<canvas id="NewLineChart" width="400" height="200"></canvas>
<span>  @errmsg   </span>
@code {
    private List<StockData> csvData = new List<StockData>();
    private MLContext context = new MLContext();
    private float[] forecastedValues= new float[0];private string errmsg="";
    private async Task HandleFileSelected(InputFileChangeEventArgs e)
    {
        forecastedValues = new float[0];
        var file = e.File;
        if (file != null)
        {
            using var stream = file.OpenReadStream();
            using var reader = new StreamReader(stream);
            var fileContent = await reader.ReadToEndAsync();
            csvData = ParseCsv(fileContent);
            ForecastHighValues();
        }
    }
   
    private List<StockData> ParseCsv(string content)
    {
        var lines = content.Split('\n', StringSplitOptions.RemoveEmptyEntries);
        var data = new List<StockData>();
          string pattern = @",(?=(?:[^""]*""[^""]*"")*[^""]*$)";
        foreach (var line in lines.Skip(1)) // Skip header row
        {
           var columns = Regex.Split(line, pattern).Select(s => s.Trim('"')).ToArray();
             
            try
            { 
                
                bool isCloseParsed = float.TryParse(columns[8], NumberStyles.AllowThousands | NumberStyles.Float, CultureInfo.InvariantCulture, out var close);
            
                bool isDateParsed = DateTime.TryParseExact(columns[0].Replace("\"", ""), "dd-MMM-yyyy", CultureInfo.InvariantCulture, DateTimeStyles.None, out var date);
              if (isDateParsed &&  isCloseParsed )
                {
                    var stock = new StockData
                        {
                            Date = date,
                         
                            Close = close 
                        };
                    data.Add(stock);
                }
         }
            catch (Exception ex)
            {
                errmsg = ex.Message;
            }
        }
        return data;
    }
    private void ForecastHighValues()
    {
        try
        {
            var sortedData = csvData.OrderBy(stock => stock.Date).ToList();
            Array.Clear(forecastedValues, 0, forecastedValues.Length);
            var dataView = context.Data.LoadFromEnumerable(sortedData);
            var pipeline = context.Forecasting.ForecastBySsa(
                outputColumnName: "ForecastedClose",
                inputColumnName: nameof(StockData.Close),
                windowSize: 115,
                seriesLength: 200,
                trainSize: 245,
                horizon: 16);
            var model = pipeline.Fit(dataView);
            var forecastingEngine = model.CreateTimeSeriesEngine<StockData, StockDataPrediction>(context);
            forecastedValues = forecastingEngine.Predict().ForecastedClose;
            Submit();
        }
        catch (Exception ex)
        {
            errmsg = ex.Message;
        }
    }
    protected async Task Submit()
    {
        try
        {
           
            var xs = new int[forecastedValues.Length]; 
           var ys = new float[forecastedValues.Length];
           Array.Clear(xs, 0, xs.Length); // Clears the array by setting all elements to default values (0 for int)
          Array.Clear(ys, 0, ys.Length); // Clears the array by setting all elements to default values (0.0f for float)
 
            for (int i = 0; i < forecastedValues.Length; i++)
            {
                xs[i] = i; // Assign the index value to xs array
                ys[i] = forecastedValues[i]; // Assign the forecasted value to ys array
            }
              JSRuntime.InvokeVoidAsync("createLineChart", xs, ys);
 
          
        }
        catch (Exception ex)
        {
            errmsg = ex.Message + forecastedValues.Length;
        }
        
        
       
    }
    public class StockData
    {
        public DateTime Date { get; set; }
        public string Series { get; set; }
        public float Open { get; set; }
        public float High { get; set; }
        public float Low { get; set; }
        public float Prevclose { get; set; }
      
        public float Ltp { get; set; }
        public float Close { get; set; }
        public float Vwap { get; set; }
        public float H52 { get; set; }
        public float L52 { get; set; }
        public float Vol { get; set; }
        public float Value { get; set; }
        public long SharesTraded { get; set; }
    
        public float[] ForecastedClose { get; set; } // Added ForecastedHigh
    }
    public class StockDataPrediction
    {
        [ColumnName("ForecastedClose")]
        public float[] ForecastedClose { get; set; }
    }
}

Share via

Cannot parse "7,345.55" to 7344.55 maui blazor

0 additional answers

Your answer