How to take this Value from string using regex

[Gopi_Krishna1 (Gopi Krishna)]

InputString=“ABC
JANUARY 13,2023
DEF” i Need that JANUARY 13,2023 String Value. Suggest a method to get it

[lrtetala (Lakshman Reddy)]

Hi @Gopi_Krishna1

Try this

Regards,

[rlgandu (Rajyalakshmi Gandu)]

@Gopi_Krishna1

OutputString=System.Text.RegularExpressions.Regex.Match(InputString,"[A-Z]+\s+\d{2}\,\d{4}").Value

[Gopi_Krishna1 (Gopi Krishna)]

Instead ABC and DEF if any other comes means what is the expression

[lrtetala (Lakshman Reddy)]

@Gopi_Krishna1

ABC
JANUARY 13,2023
DEF

@Gopi_Krishna1

It works

System.Text.RegularExpressions.Regex.Match(str,"[A-Z]+\s+\d+\,\d+").Value

[lrtetala (Lakshman Reddy)]

@Gopi_Krishna1

[rlgandu (Rajyalakshmi Gandu)]

@Gopi_Krishna1

Regular expression checks the pattern if it matches the pattern then it will store that data,
For example:[A-Z]+\s+\d{2}\,\d{4}

In this it will check the word or one letter which contains space and then digits of length 2and then comma and then digit with length of 4 then only it stores the data.

Hope it gives some basic understanding

[Parvathy (PS Parvathy)]

Hi @Gopi_Krishna1

Assign-> Input = "ABC
JANUARY 13,2023
DEF"

Assign-> Output = System.Text.RegularExpressions.Regex.Match(Input,"\w+.*\d+").Value.Trim()

Hope it helps!!

[Parvathy (PS Parvathy)]

@Parvathy

System.Text.RegularExpressions.Regex.Match(Input,"\w+.*\d+").Value.Trim()

Below workflow will give you better understanding:

Regards