Script to split a string

• manu.ferry

  Newbie

  Points: 1

  More actions

  June 14, 2011 at 12:33 am

  #237899

  Hi all,

  I have a flat file containing 2 columns as follows:

  1, home|Street|city|country|...

  My question is , I would like to count le number of substring separated with the '|' in home|Street|city|country|...

  in order to import any FF with different layout.

  I guess I need to use a script task ?

  at the end, I would need to have in variables :

  - total number of substring separated by |

  - substring names alone

  If anyone could hep, because I've no experience with C# and VB.

  Thank a lot in advance

• Elliott Whitlow

  SSC Guru

  Points: 102402

  More actions

  June 14, 2011 at 11:37 am

  #1338565

  Sorry, only have a moment, but I think in the script component, a string data type has the SPLIT function which I think will do what you want.

  CEWII

• Nimesh_Parikh

  SSC-Addicted

  Points: 464

  More actions

  June 14, 2011 at 11:55 am

  #1338576

  See if you can find anything useful in this

  http://social.msdn.microsoft.com/forums/en-US/sqlintegrationservices/thread/f50abc2a-50b9-47a8-99d9-458e9e726e52/