Looking assistance in regex

[Yoichi]

Hi,

In order to improve readability, set “Ssytem.Text.RegularExpression” at Import Tab in advance. And added linebreak as the following expression.

Regex.Matches(yourString,"Title:[\s\S]+?(?=Title:|$)").Cast(Of Match) _
    .SelectMany(Function(m) _
             Regex.Matches(Regex.Match(m.Value,"(?<=Description:\s*)[\s\S]+").Value,"[^\r\n]+").Cast(Of Match) _
        .Select(Function(m2) _
	        dt.LoadDataRow({m.Value.Split(chr(10)).First,m2.Value},False) _
	    ) _
    ).CopyToDataTable

The first Regex.Matches method extracts strings which starts with “Title:”. It’s assigned to m by the 2nd line.
Next, the second (and 3rd) regex extracts each description after “Description”. it’s assigned to m2 by the 4th line.
Then, dt.LoadDataRow method returns datarow which has the first line of m and m2
Finally, these datarows are converted to DataTable by CopyToDataTable.

Could you please suggest the tutorial where i can learn this functionality?

The above using Regex and LINQ.If you are not very familiar with these function. it may be good to start to check the following documents.

Regex help tutorial MEGAPOST – Making your first Regex post, Reusable Regex Patterns, Regex Troubleshooting, Sample Workflow and more

THE PURPOSE OF THIS POST IS TO HELP NEW REGEX USERS If you need help with Regex be sure to provide in your post, a Sample, the Output and the Pattern (as much as you know). CONTENTS: Section : I need a Regex Pattern ASAP! - My first Regex Post Section : Regex samples that you can use! Section : I need help applying regex in UiPath Section : Regex Matches and Groups Section : Le…

[HowTo] LINQ - First Start # Skip | Take | SkipWhile | TakeWhile Operator

This HowTo gives an introductory overview of the partition Operators: Skip, Take, SkipWhile, TakeWhile Introduction The partition operators are used to fetch a particular subset from a set of items. The returned subset is formed by the contiguous items that are matching the provided condition. Skip / Take Operator The Skip Operator will omit the subsequent items from the given start for a given length and will return the remaining items The Take Operator will return the subsequent items fr…

Regards,