Group String in Array and Json

[ppr (Peter Preuss)]

@Pablo_Sanchez
With the help of Regex we can split the string

refering to the groups (we will trim later)

For regex learning have a look here:

[CheatSheet] - System.Text.RegularExpressions | RegEx

This CheatSheet introduces the basic use of regex functions. With further examples also special cases are presented. Introduction From the namespace System.Text.RegularExpressions following methods are offered: Regex.Match Regex.Matches Regex.isMatch Regex.Replace Regex.Split A simple usage for example would look like this: [grafik] Recommendation: add System.Text.RegularExpressions to the imports: [grafik] it allows to use the shortened statement, as the namespace part can be ommited…

With following flow we can achieve the result:

The main idea is about:

• use regex to as mentioned above
  Regex.Matches(strText, strPattern, RegexOptions.IgnoreCase)

• group the matches and create JProperties, return all as an array

(From m In myMatches.Cast(Of Match).toList
Group m By k=m.Groups(1).Value.Trim Into grp = Group
Let arrVal = grp.Select(Function (a) a.Groups(2).Value.Trim).toArray
Let ja = JArray.FromObject(arrVal)
Select p = New JProperty(k, ja)).toarray

• Create the JObject from the returned JProperty Array
  new JObject(arrProps)

We had used LINQ:

[HowTo] LINQ (VB.Net) Learning Catalogue

This topic references the different Learning HowTos related to LINQ. It will be updated on new published HowTos as well LINQ Learning: Topic LINK First Start with LINQ [HowTo] - First Start with LINQ (VB.Net) Exploring the LINQ universe [HowTo] - Exploring the LINQ Universe (VB.Net) Operator [HowTo] Overview Topic LINK Where [HowTo] LINQ - First Start # Where Operator Select work in progress Any [HowTo] LINQ – First Start # Any Operator All [HowTo] LINQ – First Start…

But can also decompose the LINQ part to essential activities

Find starter help here:
ppr_RegexBox_PabloSanchez.xaml (7.0 KB)