QTP datasheet Help

[Brian T.]

Thank You Saket this was helpful, just wanted to give you a little more info. The data I'm trying to retreive is in a webelement field and I have a UserID parameter in my datatable. The ID i'm trying to retrieve is not the only data in that field here is an example of what would be in that field and how do I just capture the ADID and insert it in the UserID parameter of the datable.........
test request for fixes; test; ADID=XXX4XXX . Default Password=XXX-XXXXXXX

The ADID will always change from test to test but it will always be displayed after ADID=

Thanks,
Brian