using System;

using System.Collections.Generic;

using System.Text.Json;

​

public class ChildItem

{   

    public string name { get; set; }

    public string type { get; set; }

    // Generate new key to sort

    public int SortKey()

    {

        return ExtractSubstring(name);  

    }

    // Function to transform name property to SortKey

    private static int ExtractSubstring(string originalString)

    {

        string prefix = "Acoustic_Spectator_Info_";

        string suffix = ".csv";

​

        int startIndex = originalString.IndexOf(prefix) + prefix.Length;

        int endIndex = originalString.LastIndexOf(suffix);

​

        if (startIndex != -1 && endIndex != -1 && endIndex > startIndex)

        {

            return int.Parse(originalString.Substring(startIndex, endIndex - startIndex).Replace("_", ""));

        }

        else{

            return 0;

        }        

    }

}

​

public class Data

{

    public List<ChildItem> childItems { get; set; }

}

​

public class Program

{       

    public static void Main()

    {

        string json = @"{

            ""childItems"": [

                {

                    ""name"": ""Acoustic_Spectator_Info_20230629.csv"",

                    ""type"": ""File""

                },

                {

                    ""name"": ""Acoustic_Spectator_Info_20230629_11.csv"",

                    ""type"": ""File""

                },

                {

                    ""name"": ""Acoustic_Spectator_Info_20230629_1.csv"",

                    ""type"": ""File""

                },

                {

                    ""name"": ""Acoustic_Spectator_Info_20230629_2.csv"",

                    ""type"": ""File""

                },

                {

                    ""name"": ""Acoustic_Spectator_Info_20230629_21.csv"",

                    ""type"": ""File""

                }

            ],

            ""effectiveIntegrationRuntime"": ""AutoResolveIntegrationRuntime (UK South)"",

            ""executionDuration"": 0,

            ""durationInQueue"": {

                ""integrationRuntimeQueue"": 0

            },

            ""billingReference"": {

                ""activityType"": ""PipelineActivity"",

                ""billableDuration"": [

                    {

                        ""meterType"": ""AzureIR"",

                        ""duration"": 0.016666666666666666,

                        ""unit"": ""Hours""

                    }

                ]

            }

        }";

​

        // Deserialize JSON into an object

        Data data = JsonSerializer.Deserialize<Data>(json);

​

        // Sort by name property

        data.childItems.Sort((item1, item2) => item1.SortKey().CompareTo(item2.SortKey()));

​

        // Serialize the sorted data object back to JSON

        string sortedJson = JsonSerializer.Serialize(data, new JsonSerializerOptions { WriteIndented = true });

​

        // Output the sorted JSON

        Console.WriteLine(sortedJson);

    }

}

​