How to extract Date in a string [Closed]

Report
Posts
3
Registration date
Thursday January 30, 2014
Status
Member
Last seen
January 30, 2014
-
 Blocked Profile -
Dear Friends,


I need your help in extracting data in a string.

Example : Student name , Class, section, DOB, Address, email ID.

Sachin Nabar, Bcom, A, 3-May-87, Jaynagar, Bangalore, somemailaddress@gmail.com
Ravi Balu Mule, BA, 20-Dec-90, 2phase, Maruthi nagar, anotheremailaddress@yahoo.co.in

Kindly Do needful.

Thanks & Regards,
Eravon

p.s. email address altered by moderator for security reasons.

1 reply


Ok, you can use the built in function on the tol bar of "text to columns". Look at the example below. If you have any questions, let us know.

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!