AnsweredAssumed Answered

Multiple SQL queries from substring of data

Question asked by vman92 on Jul 23, 2014
Latest reply on Aug 18, 2014 by andrewg@intellinet.com

I am submitting a string of data from an InfoPath form. A merged set of data if you will.

Something like this:  1, 2, 3; 4, 5, 6; 7, 8, 9

Is there a way that I can break this string down and run three insert SQL queries in order to
populate a 3 column table with the set of information separated by semi-colons within the string?

Outcomes