Parse Strings To Get Selected Output

I have a field with following value :

USE TESTTABLE
GO
CREATE TABLE Example (
Description varchar(500))
GO
INSERT INTO [TESTTABLE].[dbo].[Example] ([Description])
VALUES ('hello This is a test query.

[Code] ....

I want to extract three things from the above data stored ina single field

1. LAST NAME (All characters before COMMA till a special character is met)
2. FIRST NAME (All characters AFTER COMMA till a special character is met)
2. ID (All numbers after the word ID. Ignore all special characters before and after the numbers)

The Output will be :

FIRST NAME LAST NAME ID
John Doe 123456
John Doe 123456
John Doe 123456

How can I use substrings to extract this data in SQL 2005