Creating Arrays

I have a Text box where the user is going to be allowed to enter a string of codes separated by some delimiter and also they can copy and paste a list of codes from the Excel spreadsheet.  See below example.

4263,4250,44490,22243,22245,4265,
4263
4250
29701
1305
11295
30457
90995,70246,12345,45678,95544

I can get the delimited values into an array using the Split Method, but how would I get the list into the same array.    I need to pass the values one at a time to a stored proc.    I cannot change the stored proc to accept a string of codes as it is used by other processes.

Can someone please help me.  

Thanks.
linecodes.jpg
sherbug1015Asked:
Who is Participating?
 
Chinmay PatelEnterprise ArchitectCommented:
I don't have an IDE right now but you can try to split using newline character \n or can use Environment.Newline and see if it works for you.
0
 
sherbug1015Author Commented:
I was able to get it to work.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.