split field using script

• harri.reddy

  SSCommitted

  Points: 1957

  More actions

  October 25, 2012 at 8:56 pm

  #266123

  hi,

  in my derived column i have 1 column like

  column1 = TH*4.0*375*01**20120521*190100*P*:

  now using script component i need to split this into different field,

  any help?

• Koen Verbeeck

  SSC Guru

  Points: 259115

  More actions

  October 26, 2012 at 12:02 am

  #1553042

  Did you check out the Split method?

  http://msdn.microsoft.com/en-us/library/system.string.split(v=vs.110).aspx

  Need an answer? No, you need a question
  My blog at https://sqlkover.com.
  MCSE Business Intelligence - Microsoft Data Platform MVP