i am a visua basic programmer. i have a problem. i tried to solve it but didnt succeed. we received a credit card details in a text file which is very big. some 100 of records and in between many tab / spaces are there. what i have to sort is take card no, name, amount , transaction id. but the file containing to many column. please help in takeing the information from the file.

it have many customer and customer wise transaction.