How to craft this regular expression?

Help Studio
, ,
1

Hi guys, I would like to extract the month and year as shown in the picture. However, i’m trying to loop the process and I’ve been trying to use the term bill which is the common word after the month and year which always changes, how do I craft the regular expression?
image

2

Hi,

How about the following pattern?

[A-Za-z]+\s*\d{4}(?=\s*Bill)

image

3

Hi @HENG_JUN_YING_AARON

Try this

(?<=SPgroup ).*\d+

image

I hope it helps!!

4

Thank you so much, it worked!

5

@HENG_JUN_YING_AARON

Try this

\w+ \d+.*(?= Bill)

image

6

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.