Regex to extract data between dates

[RajivKumar12 (Rajiv Kumar)]

How do we build a regex to extract the ff (only extract capital letters data). data Thank you

Data string sample :

" 5/30/23/ , TEST DATE
6/30/23/ , HELLO WORLD "

output : TEST DATE , HELLO WORLD

[RajivKumar12 (Rajiv Kumar)]

I mean after dates

[Steven_McKeering]

Hello

If you mean only extract capital letters after the date then try this pattern:

(?<=\d+/\d+/\d+/\s+,\s+)[A-Z\s]+

If you need just capital letters anywhere in a string try this pattern:
[A-Z]+

If you want to learn Regex - check out my Regex MegaPost for new users

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…

Cheers

Steve

[Dave (David Wiebelhaus)]

Based on the data string sample, It looks like it is a comma-separated list. It may be easier to read as a CSV into a datatable and taking the column2 values. Or if you don’t want it as a datatable, it may be better to use a strings.split() function to split by newline, then by comma - this would make the 2nd/last value in the array for each line be your output string.

Regex can be extremely helpful, but it’s important to know when to use the different types of string extraction techniques instead. Each method of string extraction has pros/cons and when to use each will depend entirely on the input data structure