How to extract specific data from a string in excel into a variable

[mukesh.singh]

You need to convert this to list below are the Example @Robot2_Automation you need to change according to your value
Option 1
Below Post will help you

Convert Json Key Value Pair

@shanmugaraj27may Welcome to the forum as it is JSON we would process it preferred with JSON Api instead of Text approaches For this structure: Can doit with a oneliner (for String) "[" & JSonConvert.SerializeObject(JArray.Parse(strJSON).ToDictionary(Function (x) x("FieldName").Value(Of String), Function (x) x("FieldValue").Value(Of String)))& "]" for JArray [grafik] JArray.Parse("[" & JSonConvert.SerializeObject(JArray.Parse(strJSON).ToDictionary(Function (x) x("FieldName").Value(Of S…

Option 2
You can use the regex which pulls your data

Option 3
You can convert to a data table and pull the data

JsonConvert.DeserializeObject(jsonString, new DataTableConverter());

Option 4
You can try to get the good knowledge

SELECT id, JSON_QUERY(jsonData, ‘$.key_word’) AS value FROM your_table

Option 5
By using string manipulation

You can achieve this by using all 4 options, some of the solutions already given by @Anil_G @vrdabberu