Hi, This is the sample of the data: T.G No. L-5786 December 29, 2010 ASIAN vs. ET AL. Sample output on should be all special character will be remove. and the date will be converted as 12292010. Output: TGNL5786Y12292010 Description: TGNL5786 - Head Y - Consistent Indicator of date. Date - 12292010 December will be 12 Date is 29 and Year is 2010. the month word will always be converted into its numeric value. January - 01