4 Replies Latest reply on Jun 5, 2018 11:52 PM by naveen kumar

# How can we divide Email list column into three separate columns

Hello everyone,

for example: If naveen@CGI.in is the data present in emaillist column.

how can we get into three separate columns 1.Name, 2.Company and 3.Country

I am using split, but could able to get the company value only.

SPLIT( [Email list], "@", 1 )  -- this calculation gives us name from emaillist

SPLIT( [Email list], ".", 2 )  -- this calculation gives us Country from emaillist

but I am not able to get the company value only.

Please let me know the solution or suggest few other ways to achieve this.

Thanks,

Naveen.

• ###### 1. Re: How can we divide Email list column into three separate columns

Hey Naveen Kumar

You need to play with the strings

Assume naveen@CGI.in is [Test]

name - LEFT([Test],FIND([Test],"@")-1)

company - MID([Test],FIND([Test],"@")+1,LEN([Test])-FIND([Test],".")+1)

country - RIGHT([Test],LEN([Test])-FIND([Test],"."))

Best,

Sujay

If this post assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution.  Thank you.

1 of 1 people found this helpful
• ###### 2. Re: How can we divide Email list column into three separate columns

Hi Navin

1) split the Email list with custom Split it will separate name and remaining sting as emaillist split 1 and emaillist split 2 respectively

2) now again custom split the emaillist split 2 using custom split as . it will separate company and region

Please find the sheet 1 of attached twbx

Regards,

Anupam

1 of 1 people found this helpful
• ###### 3. Re: How can we divide Email list column into three separate columns

You have shown me the other way to achieve this. I was looking for ways other than split fun.

Your calculation is close to what I am expecting for.

But I want this to be dynamic, you know sometimes the length present in the data for columns may vary 4 or 5 or 6 . There shouldn't be "." , that should be BT only coming in company column