I have data in a list and each entry in the list is seperated as follows:
XXXXX,XX/XX/XXXX
Where the X represents a number. The data after the comma is supposed to be a date and could possibly be null. I need to take the first part of the data before the comma (XXXXX) and compare it to a value. If the value matches the XXXXX then I need to check if the data after the comma is not null for that entry in the list and continue from there. What is the best way to go about doing this? thanks.