Here is a sample of the data I am trying to update

"21,""U"",8,100012714788,1,2,2001-04-18,""ZW"",,367903.00,403212.00,1,4250,2001-04-18,,2008-04-07,2001-04-18,"""",""00BWGG"","""",,,"""""

The U stands for an update, there are other codes for Insert (I) and Delete (D) but I have split these off using a conational split

The only field that wont change will be the "100012714788" all the rest could potentially change