how to count commas in SSIS 2005

• Padam Kumar Tripathi

  SSC-Addicted

  Points: 405

  More actions

  April 2, 2009 at 1:16 pm

  #155501

  i want to count commas after ',R,' (at the end of the row) and but my problem is - row start with word and that word can contain 'R' character. I want to count commas after ",R," in the row.

  ar ,A01008,02189,0646,R,,,,,38

  ab ,A01008,02189,0652,R,,,,,-17

  aa ,A01008,02189,0657,R,,,,,,,,,,,,,-1838

  aa ,A01008,02189,0671,R,,,,,-801

  aa ,A01008,02189,0683,R,,,,,-10

  aa ,A01008,02559,0620,R,,,,,,,,,,,,,,799

  aa ,A01008,02559,0622,R,,,,,,,3551

  aa ,A01008,02559,0626,R,,,,,,,-222

• Matt Simmons

  SSCrazy

  Points: 2846

  More actions

  April 3, 2009 at 7:15 am

  #971517

  You can always reverse the string then count the commas until you encounter the 'R'.

  Regards,
  Matt