Populate fields alone once, per field occurance

• Erin.

  SSCertifiable

  Points: 5237

  More actions

  September 25, 2008 at 2:42 pm

  #194152

  For some reason I am having a hard time explaining what I want to do...

  This if for a txt file upload into our Finance software. I have 8 fields I am populating (Box#, Desc, Client#, BoxID, Client#, MatterName, FileDesc, ClientName). The txt file will be comma-delimited, ordered by Box#. Box#, Desc, Client#, BoxID should only be populated alone once per Box# occurrence. I want to leave the last 4 columns blank when the Box# changes, this is to create the box record. Once this row has been created, the different Client# rows will follow.

  Below is my attempt to visual show what I want to do.

  Box#,Desc,Client#,BoxID,Client#,MatterName,FileDesc,ClientName

  1234,AAAA,11111,22222,,,,

  1234,AAAA,11111,22222,111111,BBBBBBBBBB,CCCCCC,DDDDDDDD

  1234,AAAA,11111,22222,222222,EEEEEEEEEE,FFFFFFF,GGGGGGGG

  5678,ZZZZ,99999,88888,,,,

  5678,ZZZZ,99999,88888,777777,YYYYYYYYY,XXXXXX,WWWWWW

  I can get all of these fields, but I don't know how to do the formatting.

  Thanks for any help. I know this isn't has clear as it could be, but I'm sure you can tell I am ready to go home.