Data Formatting Tips

Modified on Tue, 22 Nov 2022 at 02:42 PM

Now that we’ve shown you what the formatting requirements are in the Data Formatting Instructions, here is a list of tips to help you fix many of the formatting issues that you might encounter. Click on the instructions links below to see how you can make bulk changes to your data, avoiding the one-by-one changes you are probably imagining. Any questions, please visit to our Support Center or go back to the Data Formatting Instructions page.


Separating Cells  - instructions

Split Text to Columns feature comes in handy when you want to quickly split the first name and the last name, or the username and domain name from email id, or the domain name from URLs.


BEFORE
AFTER (Member Splash Required Format)

John Smith

John

Smith



Combine Cells - instructions

If you have content in different cells and you want to combine it, a couple of useful functions are CONCATENATE and JOIN.


BEFORE
AFTER (Member Splash Required Format)

3422

Thomas Drive

3422 Thomas Drive



Phone Number Formatting - instructions 

With a little know-how and effort, you can format phone numbers any way you’d like them to appear. 


BEFORE
AFTER (Member Splash Required Format)

1234567890

123- 456-7890



Date Formatting - instructions 

Customize existing dates into the format Member Splash requires with this tool.


BEFORE
AFTER (Member Splash Required Format)

02/16/1986

1986-02-16

 


Calculate Date of Birth - instructions 

Quickly calculate age using the date of birth to determine if a member is an Adult or Child.


BEFORE
AFTER

current date: 11-Feb-2020

date of birth: 24-May-1878

current age in years: 41



Remove Duplicates - instructions 

Removing duplicates is such a common thing people do, that there is now a dedicated option to quickly remove the duplicate records.


BEFORE
AFTER

John Smith
John Smith

John Smith




Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select atleast one of the reasons

Feedback sent

We appreciate your effort and will try to fix the article