Cleaning Data

Format Date/Time (US)

Normalize any date specified in the input with the following format
MM/DD/YYYY

If you don't have the information output: N/A

Input: "{{date}}"
Output:

Copy this prompt to the clipboard

Your input

Example Inputs

1. ‘03-21-2022’

2. ‘July 4, 1776’

3. ‘12/25/2021’

4. ‘’

‍

Output

Example Outputs

1. 03/21/2022

2. 04/07/1776

3. 12/25/2021

4. N/A

‍

How to find this variable?

Dates can be sourced from documents, databases, or digital records where standardized formats are not always used. Ensuring uniformity in date formatting helps in maintaining consistency across records and communications.

‍

Get lemlist updates and news
SHARE THIS ARTICLE
Thanks! You've successfully subscribed to lemlist newsletter
Oops! Something went wrong while submitting the form.

Related prompts

View all prompts
Personalization

Fun fact about your leads

This is some text inside of a div block.
This is some text inside of a div block.
This is some text inside of a div block.
This is some text inside of a div block.
This is some text inside of a div block.
This is some text inside of a div block.
Generate a fun fact based on info about your lead.
Use this prompt
Used 
291
 times
Personalization

Get 3 pain points from your leads

This is some text inside of a div block.
This is some text inside of a div block.
This is some text inside of a div block.
This is some text inside of a div block.
This is some text inside of a div block.
This is some text inside of a div block.
Generate 3 problems that your leads have
Use this prompt
Used 
1823
 times
Identify leads

ICP matchmaker

This is some text inside of a div block.
This is some text inside of a div block.
This is some text inside of a div block.
This is some text inside of a div block.
This is some text inside of a div block.
This is some text inside of a div block.
Determine how likely it is that a lead matches your ICP
Use this prompt
Used 
593
 times
Text Manipulation

Spintax for signatures

This is some text inside of a div block.
This is some text inside of a div block.
This is some text inside of a div block.
This is some text inside of a div block.
This is some text inside of a div block.
This is some text inside of a div block.
Use Spintax, a text generation method, to select one signature option randomly from a list.
Use this prompt
Used 
329
 times
Identify leads

Define leads' generation

This is some text inside of a div block.
This is some text inside of a div block.
This is some text inside of a div block.
This is some text inside of a div block.
This is some text inside of a div block.
This is some text inside of a div block.
Identify the lead's generation (Gen Z, Gen Y, etc.)
Use this prompt
Used 
857
 times
Cleaning Data

Space Removal

This is some text inside of a div block.
This is some text inside of a div block.
This is some text inside of a div block.
This is some text inside of a div block.
This is some text inside of a div block.
This is some text inside of a div block.
Use a regular expression to clean multiple spaces with a single space
Use this prompt
Used 
756
 times
Identify leads

Identify Seniority

This is some text inside of a div block.
This is some text inside of a div block.
This is some text inside of a div block.
This is some text inside of a div block.
This is some text inside of a div block.
This is some text inside of a div block.
Decide if someone with their given years of experience is a “Junior” (less than 5 years) or “Senior” (more than 5 years)
Use this prompt
Used 
685
 times
Personalization

Icebreaker from company description

This is some text inside of a div block.
This is some text inside of a div block.
This is some text inside of a div block.
This is some text inside of a div block.
This is some text inside of a div block.
This is some text inside of a div block.
Brief and impactful summary of a company’s activities, drawn from a provided description
Use this prompt
Used 
537
 times
Personalization

Personalized and engaging P.S. line

This is some text inside of a div block.
This is some text inside of a div block.
This is some text inside of a div block.
This is some text inside of a div block.
This is some text inside of a div block.
This is some text inside of a div block.
Craft a personalized and engaging P.S. line for an email
Use this prompt
Used 
768
 times
Cleaning Data

Normalize Phone Number

This is some text inside of a div block.
This is some text inside of a div block.
This is some text inside of a div block.
This is some text inside of a div block.
This is some text inside of a div block.
This is some text inside of a div block.
Format and normalize phone numbers to e164, international, and national formats
Use this prompt
Used 
628
 times
Text Manipulation

Spin Syntax

This is some text inside of a div block.
This is some text inside of a div block.
This is some text inside of a div block.
This is some text inside of a div block.
This is some text inside of a div block.
This is some text inside of a div block.
Select one of the provided text options randomly from the input list, ensuring the selection is unbiased
Use this prompt
Used 
422
 times
Cleaning Data

Format Date/Time (EU)

This is some text inside of a div block.
This is some text inside of a div block.
This is some text inside of a div block.
This is some text inside of a div block.
This is some text inside of a div block.
This is some text inside of a div block.
Transform a given date or datetime into a given format.
Use this prompt
Used 
815
 times
Text Manipulation

Adjust the company's creation year by decade

This is some text inside of a div block.
This is some text inside of a div block.
This is some text inside of a div block.
This is some text inside of a div block.
This is some text inside of a div block.
This is some text inside of a div block.
Convert the input year into the corresponding decade format
Use this prompt
Used 
3785
 times
Identify leads

Identify B2B or B2C companies

This is some text inside of a div block.
This is some text inside of a div block.
This is some text inside of a div block.
This is some text inside of a div block.
This is some text inside of a div block.
This is some text inside of a div block.
Analyze companies description to see if they're B2B or B2C
Use this prompt
Used 
4895
 times
Identify leads

Identify SaaS companies

This is some text inside of a div block.
This is some text inside of a div block.
This is some text inside of a div block.
This is some text inside of a div block.
This is some text inside of a div block.
This is some text inside of a div block.
Determine if a company is likely a Software as a Service (SaaS)
Use this prompt
Used 
3458
 times
Identify leads

Estimation of the lead's age

This is some text inside of a div block.
This is some text inside of a div block.
This is some text inside of a div block.
This is some text inside of a div block.
This is some text inside of a div block.
This is some text inside of a div block.
Estimate the probable age range of a lead based on their years of experience
Use this prompt
Used 
2785
 times
Identify leads

Get Company Size

This is some text inside of a div block.
This is some text inside of a div block.
This is some text inside of a div block.
This is some text inside of a div block.
This is some text inside of a div block.
This is some text inside of a div block.
Classify a company’s size based on its employee count into Small, Medium, or Large
Use this prompt
Used 
7568
 times
Personalization

Icebreaker from Job title

This is some text inside of a div block.
This is some text inside of a div block.
This is some text inside of a div block.
This is some text inside of a div block.
This is some text inside of a div block.
This is some text inside of a div block.
Create a short icebreaker from the job title
Use this prompt
Used 
5632
 times
Personalization

One sentence company description

This is some text inside of a div block.
This is some text inside of a div block.
This is some text inside of a div block.
This is some text inside of a div block.
This is some text inside of a div block.
This is some text inside of a div block.
Create a succinct, one-sentence description of a company
Use this prompt
Used 
2657
 times
Cleaning Data

Clean domain name

This is some text inside of a div block.
This is some text inside of a div block.
This is some text inside of a div block.
This is some text inside of a div block.
This is some text inside of a div block.
This is some text inside of a div block.
Refine the specified URL to isolate and standardize the base domain name
Use this prompt
Used 
3874
 times
Cleaning Data

Clean Company Name

This is some text inside of a div block.
This is some text inside of a div block.
This is some text inside of a div block.
This is some text inside of a div block.
This is some text inside of a div block.
This is some text inside of a div block.
Streamline and correct the company name from the input
Use this prompt
Used 
9785
 times
Cleaning Data

Clean First Name

This is some text inside of a div block.
This is some text inside of a div block.
This is some text inside of a div block.
This is some text inside of a div block.
This is some text inside of a div block.
This is some text inside of a div block.
Standardize the first name from input, ensuring correct capitalization and the removal of any superfluous characters
Use this prompt
Used 
6789
 times
Cleaning Data

Clean Last Name

This is some text inside of a div block.
This is some text inside of a div block.
This is some text inside of a div block.
This is some text inside of a div block.
This is some text inside of a div block.
This is some text inside of a div block.
Clean up and format the last name
Use this prompt
Used 
7985
 times
Cleaning Data

Clean the job title of your leads

This is some text inside of a div block.
This is some text inside of a div block.
This is some text inside of a div block.
This is some text inside of a div block.
This is some text inside of a div block.
This is some text inside of a div block.
Extract the core job title from a string by removing extraneous elements like hiring phrases, emojis, and seniority levels, etc.
Use this prompt
Used 
3651
 times