• Thanks Cadavre. This is cool stuff.

    Can your code take two row terminators? pipe (|) and line break ()?

    Example data:

    field1;field2|

    30;38469|

    31;38469|

    32;38469|

    33;38469|

    34;38469|

    I didn't notice the line break in the original data. Very sorry.

    The intent is that my user copies example data from excel and enters into a multiline text box in a webpage. He then hits a button that would transfer the input string (example data) to a stored proc that reads the data and splits into multiple column - multiple rows.

    Thanks for all your help.