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.
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.