• Instructions to Ask a Question

    Click on the "Ask a Question" button and select the application for which you would like to ask questions.

    We have 5 different products namely - Pabbly Connect, Pabbly Subscription Billing, Pabbly Email Marketing, Pabbly Form Builder, Pabbly Email Verification.

    The turnaround time is 24 hrs (Business Hours - 10.00 AM to 6.00 PM IST, Except Saturday and Sunday). So your kind patience will be highly appreciated!

    🚀🚀Exclusive Discount Offer

    Just in case you're looking for any ongoing offers on Pabbly, you can check the one-time offers listed below. You just need to pay once and use the application forever -
     

    🔥 Pabbly Connect One Time Plan for $249 (🏆Lifetime Access) -  View offer 

    🔥 Pabbly Subscription Billing One Time Plan for $149 (🏆Lifetime Access) - View offer

Regex for date

Status
Not open for further replies.

kotakeio

Member
Thanks for the suggestion, but it's not what I need for my use. My workflow is a long string of data that has several dates in it. I would like to use the text formatter - extract pattern feature but can't figure out the regex. Here is something I've tried with no success. I'm not sure how it is structured wrong.

^(0[1-9]|1[0-2])/(0[1-9]|[12][0-9]|3[01])/\d{4}$
 

Fagun Shah

Well-known member
Thanks for the suggestion, but it's not what I need for my use. My workflow is a long string of data that has several dates in it. I would like to use the text formatter - extract pattern feature but can't figure out the regex. Here is something I've tried with no success. I'm not sure how it is structured wrong.

^(0[1-9]|1[0-2])/(0[1-9]|[12][0-9]|3[01])/\d{4}$
Provide sample string for testing.
 

kotakeio

Member
EMAIL DATE: 11/01/2023
EMAIL TYPE: Personal Story Email

EMAIL DATE: 11/02/2023
EMAIL TYPE: Value Email

EMAIL DATE: 11/03/2023
EMAIL TYPE: Client Story Email

EMAIL DATE: 11/06/2023
EMAIL TYPE: Negative How To Email

EMAIL DATE: 11/07/2023
EMAIL TYPE: Value Email

EMAIL DATE: 11/08/2023
EMAIL TYPE: Personal Story Email

EMAIL DATE: 11/09/2023
EMAIL TYPE: Straight Offer Email

EMAIL DATE: 11/10/2023
EMAIL TYPE: Client Story Email

EMAIL DATE: 11/13/2023
EMAIL TYPE: Value Email

EMAIL DATE: 11/14/2023
EMAIL TYPE: Negative How To Email

EMAIL DATE: 11/15/2023
EMAIL TYPE: Personal Story Email

EMAIL DATE: 11/16/2023
EMAIL TYPE: Client Story Email

EMAIL DATE: 11/17/2023
EMAIL TYPE: Low-Ticket Offer Email

EMAIL DATE: 11/20/2023
EMAIL TYPE: Interview/Success Story Email

EMAIL DATE: 11/21/2023
EMAIL TYPE: Value Email

EMAIL DATE: 11/22/2023
EMAIL TYPE: Personal Story Email

EMAIL DATE: 11/23/2023
EMAIL TYPE: Client Story Email

EMAIL DATE: 11/24/2023
EMAIL TYPE: Straight Offer Email

EMAIL DATE: 11/27/2023
EMAIL TYPE: Negative How To Email

EMAIL DATE: 11/28/2023
EMAIL TYPE: Personal Story Email

EMAIL DATE: 11/29/2023
EMAIL TYPE: Value Email

EMAIL DATE: 11/30/2023
EMAIL TYPE: Client Story Email
 

Himesh

Active member
Hello @kotakeio please use this regex :- \b\d{2}\/\d{2}\/\d{4}\b

1698386466632.png
 
Status
Not open for further replies.
Top