C# String.Split() using a multi-character delimiter in a script task

Question

Post reply

C# String.Split() using a multi-character delimiter in a script task

Pete Bishop

Default port

Points: 1485
More actions
February 9, 2022 at 10:18 am
Go to Answer
#3981479

I have a requirement to split input data into multiple columns, but the data is delimited by multiple characters.
Whereas native C# supports string.Split("|--|") quite happily, I can't seem to get this to work in an SSIS script task as it will only accept a single character as the delimiter string.Split(',') for example.
Am I missing something or is this not available?
Thanks.
kaj

SSCommitted

Points: 1616
More actions
February 9, 2022 at 2:26 pm
Answer
#3981517

Have you tried string.Split(new string[] { "|--|" }) ?
The split function is actually expecting an array of strings.
https://docs.microsoft.com/en-us/dotnet/api/system.string.split?view=netframework-4.5

Viewing 6 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Phil Parkin SSC Guru Points: 247161 More actions · Answer 1

Single quotes are for chars. Use double quotes for string literals ... it should work.

Pete Bishop Default port Points: 1485 More actions · Answer 2

Thanks kaj; that did it.

Wasn't needed in "native" C# but clearly was in the Script Task.

TangoVictor SSChampion Points: 10976 More actions · Answer 3

Here's an example of using a script component as a data source in a dataflow that outputs the delimited string as rows.

There doesn't appear to be an overload method that is simply split(String[]), I think you need to include the string split options, it appears maybe these are optional in regular .Net but required here perhaps.

SSIS does have a scaled down version of .Net. String.Split in an SSIS ScriptComponent only showed me 6 overload methods yet there are 10. Also Script Task and Script Component may differ, not sure. But the following works for a ScriptComponent. At least on my Win 10 laptop.

public override void CreateNewOutputRows()
    {

        var inputData = "Duck|--|Cat|--|Chicken|--|Cow|--|Pig|--|Dog|--|Horse";
        string[] mySep = { "|--|" };
        string[] inputSplit = inputData.Split(mySep,StringSplitOptions.None);
        foreach(var animal in inputSplit)
        {
            Output0Buffer.AddRow();
            Output0Buffer.MyData = animal;
        }
        
    }

This reply was modified 3 years, 4 months ago by TangoVictor.
This reply was modified 3 years, 4 months ago by TangoVictor.

davidson02 Newbie Points: 3 More actions · Answer 4

davidson02

Newbie

Points: 3

February 11, 2022 at 4:32 am

#3981810

Thanks, Kaj.

C# String.Split() using a multi-character delimiter in a script task

Cookies on SQLServerCentral