Skip to Content
0
Former Member
Feb 23, 2009 at 02:26 PM

Repeater split comma seperated field into multiple fields

772 Views

I have an sql statement which get some rows with fields. In the last field LINE all information is ; seperated so ( 318.0012, 3, test, 4 etc)

What a want to do is split these values and put them into fields.

I know you can do string list to xml parser, but that is not the solution i am looking for.

SQL_Read_Orders_from_Kardex.Results{/Rowsets/Rowset/Row}

Is this row there is the field LINE.

Is it possible to let the repeater split the values? And assign these values to a new xml output document?