How to extract Date in a string

Closed
Eravon Posts 3 Registration date Thursday January 30, 2014 Status Member Last seen January 30, 2014 - Jan 30, 2014 at 05:44 AM
 Blocked Profile - Jan 30, 2014 at 10:36 AM
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 response

Blocked Profile
Jan 30, 2014 at 10:36 AM
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.

0