1 of 1 people found this helpful
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],"."))
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) 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
Email split3colmns_v10.2.twbx 14.4 KB
Thanks for the reply Sujay.
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
Your cal shows like this.
Yeah I tried the same when I am discussing with my colleagues.
Thanks for your help!