Pulling Names from Inquiry Forms

Joel_Kuhn · January 30, 2025, 11:00pm

Hello! I'm a wedding photographer. When a couple inquires through my site, I receive an email with their info (see photo below).

I would like to extract the following info from this form automatically for use in my response snippets:
-Bride's Name (First name only)
-Groom's Name (First name only)
-Wedding Date (Sometimes received numerically (e.g. 12/31/25) sometimes received with words (December 31st, 2025) (Either way I would like it formatted with words in my snippets)

I'd love to use the {site} command if possible, but the form submissions are not structured - I just receive the info as a wall of text (see screenshot). I'm fine to copy the submission to my clipboard if I must.

A customer service rep tried to provide regex code for me (see below) but it returned results "No Match Found" and he recommended I post in this form.

{clipboard_data={clipboard}}
BRIDE'S NAME: {=extractregex(clipboard_data, "BRIDE'S NAME::\n(\S+)")}
GROOM'S NAME: {=extractregex(clipboard_data, "GROOM'S NAME:\n(\S+)")}
WEDDING DATE: {=extractregex(clipboard_data, "WEDDING DATE:\n(.+)")}

Could anyone help me achieve my goal? Thank you!

VinodGubbala · January 31, 2025, 1:09am

Hi @Joel_Kuhn ,
Welcome to Text Blaze community,
I tried your snippet with the text you provided and seems to be working fine.

Check the snippet

{clipboard_data="BRIDE'S NAME::
Pam Beasly

GROOM'S NAME:
Jim Halpert

WEDDING DATE:
January 14th, 2025

LOCATION:
Crystal View Pines

REFERRAL:
Instagram

ABOUT:
Lorem ipsum dolor sit amet, consectetur adipiscing elit

WEDDING DETAILS:
Lorem ipsum dolor sit amet, consectetur adipiscing elit

EMAIL ADDRESS:
pam.beasly@email.com

Submitted From:
Showit Help"}

BRIDE'S NAME: {=extractregex(clipboard_data, "BRIDE'S NAME::\n(\S+)")}
GROOM'S NAME: {=extractregex(clipboard_data, "GROOM'S NAME:\n(\S+)")}
WEDDING DATE: {=extractregex(clipboard_data, "WEDDING DATE:\n(.+)")}

Is it possible that the text sometimes contains "BRIDE'S NAME:" with only single colon.
Lets tweak this a little if that is the case to catch the name if its either of the case.

{clipboard_data="BRIDE'S NAME:
Pam Beasly

GROOM'S NAME:
Jim Halpert

WEDDING DATE:
January 14th, 2025

LOCATION:
Crystal View Pines

REFERRAL:
Instagram

ABOUT:
Lorem ipsum dolor sit amet, consectetur adipiscing elit

WEDDING DETAILS:
Lorem ipsum dolor sit amet, consectetur adipiscing elit

EMAIL ADDRESS:
pam.beasly@email.com

Submitted From:
Showit Help"}

BRIDE'S NAME: {=extractregex(clipboard_data, "BRIDE'S NAME[:]+\n(\S+)")}
GROOM'S NAME: {=extractregex(clipboard_data, "GROOM'S NAME[:]+\n(\S+)")}
WEDDING DATE: {=extractregex(clipboard_data, "WEDDING DATE[:]+\n(.+)")}

Joel_Kuhn · January 31, 2025, 1:36am

Thank you so much for the response, Vinod! Thanks for the note about the one vs. two colons.

Unfortunately, I'm still having trouble. When I "Copy to Text Blaze" that snippet, then copy a different inquiry (non Jim+Pam, but same format), it just posts the Jim and Pam info.

When I put {clipboard_data={clipboard}} instead of the clipboard_data= that you have as the first line, then copy a different inquiry, I get:

BRIDE'S NAME: [Error - No match found.]
GROOM'S NAME: [Error - No match found.]
WEDDING DATE: [Error - No match found.]

Could you maybe give me more specific instructions as to what to do? Sorry, I'm new!

Below is a simplified example of the snippet I am trying to use this info in. Thank you!!

Hey {formtext: name=Bride's Name},

Thank you for your inquiry! Congrats to you and {formtext: name=Groom's Name}. We're still available for your wedding on {formtext: name=Wedding Date}. Below is our pricing.

Thank you!

VinodGubbala · January 31, 2025, 1:58am

Can you please share some few examples of the email formats so we can target all the available formats.

Joel_Kuhn · January 31, 2025, 3:12am

Yes! They all come in the same format, I believe. Below are three examples:

BRIDE'S NAME::
Erin Jameson

GROOM'S NAME:
Jimmy Carter

WEDDING DATE:
December 6th, 2025

LOCATION:
Orlando, FL + Dubsdread

REFERRAL:
Dubsdread Instagram

ABOUT:
Lorem Ipsum Lorem psum

WEDDING DETAILS:
Lorem Ipsum Lorem psum

EMAIL ADDRESS:
Lorempsum@gmail.com

Submitted From:
https://28north.co/contact

Bride's Name:
Jordan Parks

Groom's Name:
Russel Westbrooke

Wedding Date:
01/03/2026

Location:
Jacksonville, FL Epping Forest Yacht Club

How'd You Find Us:
Vendor Preferred List

Tell Us About You Two:
Lorem Ipsum Lorem psum

Give Us All Your Dream Wedding Details:
Lorem Ipsum Lorem psum

Email Address:
jimanysdas@yahoo.com

Bride's Name:
Jenny

Groom's Name:
George

Wedding Date:
06/21/2025

Location:
Howey Mansion

How'd You Find Us:
The best coordinator

Tell Us About You Two:
Misc misc misc misc misc

Give Us All Your Dream Wedding Details:
Misc misc misc misc misc

Email Address:
superman123123@gmail.com

Submitted From:
https://28north.co/contact

Joel_Kuhn · January 31, 2025, 3:16am

UPDATE:
I found out why sometimes there was two colons ( :: ) and why sometimes there is only one. It depended on whether the form was submitted on mobile or desktop. I've made all forms like this format:

Bride's Name:
Jordan Parks

Groom's Name:
Russel Westbrooke

Wedding Date:
01/03/2026

Location:
Jacksonville, FL Epping Forest Yacht Club

How'd You Find Us:
Vendor Preferred List

Tell Us About You Two:
Lorem Ipsum Lorem psum

Give Us All Your Dream Wedding Details:
Lorem Ipsum Lorem psum

Email Address:
jimanyasds@yahoo.com

VinodGubbala · January 31, 2025, 4:53am

Thanks for the details.
Here is the updated version of the snippet

I used {note} to hide the part you dont want to see while executing the snippet.
I used the flag "i" in extractregex to match it with case insensitive.

I have assigned the form name with the values you need.

{note: preview=no}
{clipboard_data="Bride's Name:
Jordan Parks

Groom's Name:
Russel Westbrooke

Wedding Date:
01/03/2026

Location:
Jacksonville, FL Epping Forest Yacht Club

How'd You Find Us:
Vendor Preferred List

Tell Us About You Two:
Lorem Ipsum Lorem psum

Give Us All Your Dream Wedding Details:
Lorem Ipsum Lorem psum

Email Address:
jimanyasds@yahoo.com"}

{`Bride's Name`=extractregex(clipboard_data, "BRIDE'S NAME[:]+\n(\S+)", "i")}
{`Groom's Name`=extractregex(clipboard_data, "GROOM'S NAME[:]+\n(\S+)", "i")}
{`Wedding Date`=extractregex(clipboard_data, "WEDDING DATE[:]+\n(.+)", "i")}

{endnote}Hey {formtext: name=Bride's Name},

Thank you for your inquiry! Congrats to you and {formtext: name=Groom's Name}. We're still available for your wedding on {formtext: name=Wedding Date}. Below is our pricing.

Thank you!

Joel_Kuhn · January 31, 2025, 1:35pm

SUCCESS! Thank you so much for your effort on this.

One final question:

Regardless of the format the date is extracted in, is it possible to display Wedding Date in Long-Form (Spelled-Out) Format (Example: December 31st, 2025 instead of 12/31/25). I prefer to use Long Format in my messaging as opposed to just numbers.

Thank you!

Joel_Kuhn · February 2, 2025, 4:27pm

BUMP:

Just checking to see if anyone knows how to display a date extracted using regex in Long Format (December 31st, 2025), even if it was extracted in numerical format (12/31/25)?

Thank you!

Abdalla_Mahmoud · February 2, 2025, 7:32pm

@Joel_Kuhn You can use datetimeparse and datetimeformat as follows:

{formtext: name=date; default=12/31/25}
{=datetimeformat(datetimeparse(date, "MM/DD/YY"), "MMMM Do, YYYY")}

Please replace date with the variable you used to assign the result of the extractregex function.

Let me know if that helps.

Joel_Kuhn · February 2, 2025, 7:58pm

Thank you so much for the response, Abdalla! Unfortuantely, I'm having trouble integrating it into my snippet. I'm sorry- I'm very new! Below is the snippet I am trying to use. Could you be more specific as to how I can use the code you provided in my snippet?

**Additionally, is is possible to also just extract the month used in the clipboard text, for use in the "Wedding Month" form field?

Thank you very much.

{note: preview=no}
{clipboard_data={clipboard}}

{Bride's Name=extractregex(clipboard_data, "BRIDE'S NAME[:]+\n(\S+)", "i")}
{Groom's Name=extractregex(clipboard_data, "GROOM'S NAME[:]+\n(\S+)", "i")}
{Wedding Date=extractregex(clipboard_data, "WEDDING DATE[:]+\n(.+)", "i")}

{endnote}Hey {formtext: name=Bride's Name},

Thank you for your inquiry! Congrats to you and {formtext: name=Groom's Name}. We're still available for your wedding on {formtext: name=Wedding Date}. {formtext: name=Wedding Month} is one of our favorite months to photograph weddings! Below is our pricing.

Thank you!

Abdalla_Mahmoud · February 2, 2025, 8:12pm

Hi @Joel_Kuhn.

Sure, I have rewrote the snippet for you, including the wedding month field:

{note: preview=no}
{clipboard_data="Bride's Name:
Jordan Parks

Groom's Name:
Russel Westbrooke

Wedding Date:
01/03/2026

Location:
Jacksonville, FL Epping Forest Yacht Club

How'd You Find Us:
Vendor Preferred List

Tell Us About You Two:
Lorem Ipsum Lorem psum

Give Us All Your Dream Wedding Details:
Lorem Ipsum Lorem psum

Email Address:
jimanyasds@yahoo.com"}

{`Bride's Name`=extractregex(clipboard_data, "BRIDE'S NAME[:]+\n(\S+)", "i")}
{`Groom's Name`=extractregex(clipboard_data, "GROOM'S NAME[:]+\n(\S+)", "i")}
{`Wedding Date`=datetimeformat(datetimeparse(extractregex(clipboard_data, "WEDDING DATE[:]+\n(.+)", "i"), "MM/DD/YY"), "MMMM Do, YYYY")}
{`Wedding Month`=datetimeformat(datetimeparse(extractregex(clipboard_data, "WEDDING DATE[:]+\n(.+)", "i"), "MM/DD/YY"), "MMMM")}

{endnote}Hey {formtext: name=Bride's Name},

Thank you for your inquiry! Congrats to you and {formtext: name=Groom's Name}. We're still available for your wedding on {formtext: name=Wedding Date}. {formtext: name=Wedding Month} is one of our favorite months to photograph weddings! Below is our pricing.

Thank you!

Let me know if that works for you.

Joel_Kuhn · February 2, 2025, 8:39pm

Wonderful!! Thank you so much.

Upon testing, the Wedding Date is being changed to 2020, regardless of the correct year. You can see this also happened in the example snippet. (2026 was changed to 2020)

Could you advise as to why or if this can be fixed?

Thank you!

Abdalla_Mahmoud · February 3, 2025, 9:41am

Hi @Joel_Kuhn

Sorry, the problem is in the example value of the clipboard_data, If we updated the value of the clipboard_data example here to 01/03/26 such that it matches the format you required in your question, this should fix the issue as follows:

{note: preview=no}
{clipboard_data="Bride's Name:
Jordan Parks

Groom's Name:
Russel Westbrooke

Wedding Date:
01/03/26

Location:
Jacksonville, FL Epping Forest Yacht Club

How'd You Find Us:
Vendor Preferred List

Tell Us About You Two:
Lorem Ipsum Lorem psum

Give Us All Your Dream Wedding Details:
Lorem Ipsum Lorem psum

Email Address:
jimanyasds@yahoo.com"}

{`Bride's Name`=extractregex(clipboard_data, "BRIDE'S NAME[:]+\n(\S+)", "i")}
{`Groom's Name`=extractregex(clipboard_data, "GROOM'S NAME[:]+\n(\S+)", "i")}
{`Wedding Date`=datetimeformat(datetimeparse(extractregex(clipboard_data, "WEDDING DATE[:]+\n(.+)", "i"), "MM/DD/YY"), "MMMM Do, YYYY")}
{`Wedding Month`=datetimeformat(datetimeparse(extractregex(clipboard_data, "WEDDING DATE[:]+\n(.+)", "i"), "MM/DD/YY"), "MMMM")}

{endnote}Hey {formtext: name=Bride's Name},

Thank you for your inquiry! Congrats to you and {formtext: name=Groom's Name}. We're still available for your wedding on {formtext: name=Wedding Date}. {formtext: name=Wedding Month} is one of our favorite months to photograph weddings! Below is our pricing.

Thank you!

If you need to use a different source/target date formats, please consider changing them in this formula: datetimeformat(datetimeparse(extractregex(clipboard_data, "WEDDING DATE[:]+\n(.+)", "i"), "MM/DD/YY"), "MMMM Do, YYYY").

Let me know if you need any more help.

Joel_Kuhn · February 3, 2025, 12:51pm

Thank you, Abdalla.

Unfortunately, the client can send the date in either 01/03/26 format or 1/3/2026 format, as it's simply a text box on their end as opposed to a calendar clicker.

Is there a way to set up the snippet to be able to handle either format?

Abdalla_Mahmoud · February 3, 2025, 1:32pm

@Joel_Kuhn One option here is checking the length of the parsed input as follows:

{note: preview=no}
{clipboard_data="Bride's Name:
Jordan Parks

Groom's Name:
Russel Westbrooke

Wedding Date:
01/03/2026

Location:
Jacksonville, FL Epping Forest Yacht Club

How'd You Find Us:
Vendor Preferred List

Tell Us About You Two:
Lorem Ipsum Lorem psum

Give Us All Your Dream Wedding Details:
Lorem Ipsum Lorem psum

Email Address:
jimanyasds@yahoo.com"}

{`Bride's Name`=extractregex(clipboard_data, "BRIDE'S NAME[:]+\n(\S+)", "i")}
{`Groom's Name`=extractregex(clipboard_data, "GROOM'S NAME[:]+\n(\S+)", "i")}
{`Wedding Date`=extractregex(clipboard_data, "WEDDING DATE[:]+\n(.+)", "i")}
{`Wedding Date Formatted`=datetimeformat(datetimeparse(`Wedding Date`, "MM/DD/YYYY" if len(`Wedding Date`) > 8 else "MM/DD/YY"), "MMMM Do, YYYY")}
{`Wedding Month`=datetimeformat(datetimeparse(extractregex(clipboard_data, "WEDDING DATE[:]+\n(.+)", "i"), "MM/DD/YY"), "MMMM")}

{endnote}Hey {formtext: name=Bride's Name},

Thank you for your inquiry! Congrats to you and {formtext: name=Groom's Name}. We're still available for your wedding on {formtext: name=Wedding Date Formatted}. {formtext: name=Wedding Month} is one of our favorite months to photograph weddings! Below is our pricing.

Thank you!

Joel_Kuhn · February 3, 2025, 2:04pm

Amazing. You've helped me tremendously. Thank you very much!