«

Hi

I got a string as follows

str=
-0.1400,0.2910,-0.2742,-0.2904,0.1087,0.0323,-0.1355,-0.1221,-0.2164,-0.2128#0.0834,-0.4026,-0.2563,-0.0145,-0.3120,-0.2324,-0.1320,-0.0246,-0.1383,-0.1964#0.0711,-0.1743,-0.0128,0.0122,-0.1154,-0.1392,-0.1910,0.0543,-0.0450,-0.0685


i need a code in asp so the output is in the following format


-0.1400,0.0834,0.0711#0.2910,-0.4026,-0.1743#-0.2742,-0.2563,-0.0128#-0.2904,-0.0145,0.0122#0.1087,-0.3120,-0.1154#0.0323,-0.2324,-0.1392#-0.1355,-0.1320,-0.1910#
-0.1221,-0.0246,0.0543#-0.2164,-0.1383,-0.0450#-0.2128,-0.1964,-0.0685


please help

Regards
kalyan kamesh

wrote:
> Hi
>
> I got a string as follows
>
> str=
> -0.1400,0.2910,-0.2742,-0.2904,0.1087,0.0323,-0.1355,-0.1221,-0.2164,-0.2128#0.0834,-0.4026,-0.2563,-0.0145,-0.3120,-0.2324,-0.1320,-0.0246,-0.1383,-0.1964#0.0711,-0.1743,-0.0128,0.0122,-0.1154,-0.1392,-0.1910,0.0543,-0.0450,-0.0685
>
>
> i need a code in asp so the output is in the following format
>
>
> -0.1400,0.0834,0.0711#0.2910,-0.4026,-0.1743#-0.2742,-0.2563,-0.0128#-0.2904,-0.0145,0.0122#0.1087,-0.3120,-0.1154#0.0323,-0.2324,-0.1392#-0.1355,-0.1320,-0.1910#
> -0.1221,-0.0246,0.0543#-0.2164,-0.1383,-0.0450#-0.2128,-0.1964,-0.0685
>
>
> please help
>
> Regards
> kalyan kamesh

Here you go:

<%
str =
"-0.1400,0.2910,-0.2742,-0.2904,0.1087,0.0323,-0.1355,-0.1221,-0.2164,-0.2128#0.0834,-0.4026,-0.2563,-0.0145,-0.3120,-0.2324,-0.1320,-0.0246,-0.1383,-0.1964#0.0711,-0.1743,-0.0128,0.0122,-0.1154,-0.1392,-0.1910,0.0543,-0.0450,-0.0685"

splitstr = split(str,"#")

firstarr = split(splitstr(0),",")
secondarr = split(splitstr(1),",")
thirdarr = split(splitstr(2),",")
newstr = ""
for i = 0 to ubound(firstarr)
newstr = newstr & firstarr(i) & "," & secondarr(i) & "," & thirdarr(i)
& "#"
next
response.write left(newstr,len(newstr)-1)
%>

--
Mike Brind

Mike Brind wrote:
> wrote:
> > Hi
> >
> > I got a string as follows
> >
> > str=
> > -0.1400,0.2910,-0.2742,-0.2904,0.1087,0.0323,-0.1355,-0.1221,-0.2164,-0.2128#0.0834,-0.4026,-0.2563,-0.0145,-0.3120,-0.2324,-0.1320,-0.0246,-0.1383,-0.1964#0.0711,-0.1743,-0.0128,0.0122,-0.1154,-0.1392,-0.1910,0.0543,-0.0450,-0.0685
> >
> >
> > i need a code in asp so the output is in the following format
> >
> >
> > -0.1400,0.0834,0.0711#0.2910,-0.4026,-0.1743#-0.2742,-0.2563,-0.0128#-0.2904,-0.0145,0.0122#0.1087,-0.3120,-0.1154#0.0323,-0.2324,-0.1392#-0.1355,-0.1320,-0.1910#
> > -0.1221,-0.0246,0.0543#-0.2164,-0.1383,-0.0450#-0.2128,-0.1964,-0.0685
> >
> >
> > please help
> >
> > Regards
> > kalyan kamesh
>
> Here you go:
>
> <%
> str =
> "-0.1400,0.2910,-0.2742,-0.2904,0.1087,0.0323,-0.1355,-0.1221,-0.2164,-0.2128#0.0834,-0.4026,-0.2563,-0.0145,-0.3120,-0.2324,-0.1320,-0.0246,-0.1383,-0.1964#0.0711,-0.1743,-0.0128,0.0122,-0.1154,-0.1392,-0.1910,0.0543,-0.0450,-0.0685"
>
> splitstr = split(str,"#")
>
> firstarr = split(splitstr(0),",")
> secondarr = split(splitstr(1),",")
> thirdarr = split(splitstr(2),",")
> newstr = ""
> for i = 0 to ubound(firstarr)
> newstr = newstr & firstarr(i) & "," & secondarr(i) & "," & thirdarr(i)
> & "#"
> next
> response.write left(newstr,len(newstr)-1)
> %>
>
> --
> Mike Brind


Hi Mike

Thanks for response
but my series in str is dynamic...what should i do in that case

Regards
kalyan

kali...@gmail.com wrote:
> Mike Brind wrote:
> > wrote:
> > > Hi
> > >
> > > I got a string as follows
> > >
> > > str=
> > > -0.1400,0.2910,-0.2742,-0.2904,0.1087,0.0323,-0.1355,-0.1221,-0.2164,-0.2128#0.0834,-0.4026,-0.2563,-0.0145,-0.3120,-0.2324,-0.1320,-0.0246,-0.1383,-0.1964#0.0711,-0.1743,-0.0128,0.0122,-0.1154,-0.1392,-0.1910,0.0543,-0.0450,-0.0685
> > >
> > >
> > > i need a code in asp so the output is in the following format
> > >
> > >
> > > -0.1400,0.0834,0.0711#0.2910,-0.4026,-0.1743#-0.2742,-0.2563,-0.0128#-0.2904,-0.0145,0.0122#0.1087,-0.3120,-0.1154#0.0323,-0.2324,-0.1392#-0.1355,-0.1320,-0.1910#
> > > -0.1221,-0.0246,0.0543#-0.2164,-0.1383,-0.0450#-0.2128,-0.1964,-0.0685
> > >
> > >
> > > please help
> > >
> > > Regards
> > > kalyan kamesh
> >
> > Here you go:
> >
> > <%
> > str =
> > "-0.1400,0.2910,-0.2742,-0.2904,0.1087,0.0323,-0.1355,-0.1221,-0.2164,-0.2128#0.0834,-0.4026,-0.2563,-0.0145,-0.3120,-0.2324,-0.1320,-0.0246,-0.1383,-0.1964#0.0711,-0.1743,-0.0128,0.0122,-0.1154,-0.1392,-0.1910,0.0543,-0.0450,-0.0685"
> >
> > splitstr = split(str,"#")
> >
> > firstarr = split(splitstr(0),",")
> > secondarr = split(splitstr(1),",")
> > thirdarr = split(splitstr(2),",")
> > newstr = ""
> > for i = 0 to ubound(firstarr)
> > newstr = newstr & firstarr(i) & "," & secondarr(i) & "," & thirdarr(i)
> > & "#"
> > next
> > response.write left(newstr,len(newstr)-1)
> > %>
> >
> > --
> > Mike Brind
>
>
> Hi Mike
>
> Thanks for response
> but my series in str is dynamic...what should i do in that case
>
> Regards
> kalyan

The example you gave shows three sets of 10 values delimited by #.
Each of the values within each set is delimited by a comma. Which
part(s) are dynamic? The number of sets? The number of values? Are
the number of values always the same regardless of the number of sets?
Will the number of values change between sets?

--
Mike Brind

Mike

The number of sets are dynamic...each set has exactly 10 values all the
time separated by comma

Kalyan kamesh

kali...@gmail.com wrote:
> Mike Brind wrote:
> > kali...@gmail.com wrote:
> > > Hi

> > > I got a string as follows

> > > str=
> > > -0.1400,0.2910,-0.2742,-0.2904,0.1087,0.0323,-0.1355,-0.1221,-0.2164,-0.2128#0.0834,-0.4026,-0.2563,-0.0145,-0.3120,-0.2324,-0.1320,-0.0246,-0.1383,-0.1964#0.0711,-0.1743,-0.0128,0.0122,-0.1154,-0.1392,-0.1910,0.0543,-0.0450,-0.0685

> > > i need a code in asp so the output is in the following format

> > > -0.1400,0.0834,0.0711#0.2910,-0.4026,-0.1743#-0.2742,-0.2563,-0.0128#-0.2904,-0.0145,0.0122#0.1087,-0.3120,-0.1154#0.0323,-0.2324,-0.1392#-0.1355,-0.1320,-0.1910#
> > > -0.1221,-0.0246,0.0543#-0.2164,-0.1383,-0.0450#-0.2128,-0.1964,-0.0685

> > > please help

> > > Regards
> > > kalyan kamesh

> > Here you go:

> > <%
> > str =
> > "-0.1400,0.2910,-0.2742,-0.2904,0.1087,0.0323,-0.1355,-0.1221,-0.2164,-0.2128#0.0834,-0.4026,-0.2563,-0.0145,-0.3120,-0.2324,-0.1320,-0.0246,-0.1383,-0.1964#0.0711,-0.1743,-0.0128,0.0122,-0.1154,-0.1392,-0.1910,0.0543,-0.0450,-0.0685"

> > splitstr = split(str,"#")

> > firstarr = split(splitstr(0),",")
> > secondarr = split(splitstr(1),",")
> > thirdarr = split(splitstr(2),",")
> > newstr = ""
> > for i = 0 to ubound(firstarr)
> > newstr = newstr & firstarr(i) & "," & secondarr(i) & "," & thirdarr(i)
> > & "#"
> > next
> > response.write left(newstr,len(newstr)-1)
> > %>

> > --
> > Mike Brind

> Hi Mike

> Thanks for response
> but my series in str is dynamic...what should i do in that case

> Regards
> kalyan

>The example you gave shows three sets of 10 values delimited by #.
>Each of the values within each set is delimited by a comma. Which
>part(s) are dynamic? The number of sets? The number of values? Are
>the number of values always the same regardless of the number of sets?
>Will the number of values change between sets?

>--
>Mike Brind
> wrote:
> Mike
>
> The number of sets are dynamic...each set has exactly 10 values all the
> time separated by comma
>
> Kalyan kamesh

First off, please don't use the reply link at the bottom of the post in
google groups - it wipes out what you are replying to. Use the Reply
link that is revealed when you click Show Options next to a poster's
name. Loads of poster's get caught out with that. Google really ought
to sort their interface out

Back to your question - you need to read them into a 2 d array, then
read then back out in the order that you want. This should do it:

splitstr = split(str,"#")
cols=9
rows=ubound(splitstr)

dim myarray()
redim myarray(cols,rows)

for y = 0 to rows
arr = split(splitstr(y),",")
for x = 0 to cols
myarray(x,y) = arr(x)
next
next
newstr = ""
for i = 0 to cols
for j = 0 to rows
newstr = newstr & myarray(i,j)
if j = rows then
newstr=newstr
else
newstr = newstr & ","
end if
next
newstr = newstr & "#"
next
response.write left(newstr,len(newstr)-1)
%>

--
Mike Brind

Mike Brind wrote:
> kali...@gmail.com wrote:
> > Mike Brind wrote:
> > > kali...@gmail.com wrote:
> > > > Hi
>
> > > > I got a string as follows
>
> > > > str=
> > > > -0.1400,0.2910,-0.2742,-0.2904,0.1087,0.0323,-0.1355,-0.1221,-0.2164,-0.2128#0.0834,-0.4026,-0.2563,-0.0145,-0.3120,-0.2324,-0.1320,-0.0246,-0.1383,-0.1964#0.0711,-0.1743,-0.0128,0.0122,-0.1154,-0.1392,-0.1910,0.0543,-0.0450,-0.0685
>
> > > > i need a code in asp so the output is in the following format
>
> > > > -0.1400,0.0834,0.0711#0.2910,-0.4026,-0.1743#-0.2742,-0.2563,-0.0128#-0.2904,-0.0145,0.0122#0.1087,-0.3120,-0.1154#0.0323,-0.2324,-0.1392#-0.1355,-0.1320,-0.1910#
> > > > -0.1221,-0.0246,0.0543#-0.2164,-0.1383,-0.0450#-0.2128,-0.1964,-0.0685
>
> > > > please help
>
> > > > Regards
> > > > kalyan kamesh
>
> > > Here you go:
>
> > > <%
> > > str =
> > > "-0.1400,0.2910,-0.2742,-0.2904,0.1087,0.0323,-0.1355,-0.1221,-0.2164,-0.2128#0.0834,-0.4026,-0.2563,-0.0145,-0.3120,-0.2324,-0.1320,-0.0246,-0.1383,-0.1964#0.0711,-0.1743,-0.0128,0.0122,-0.1154,-0.1392,-0.1910,0.0543,-0.0450,-0.0685"
>
> > > splitstr = split(str,"#")
>
> > > firstarr = split(splitstr(0),",")
> > > secondarr = split(splitstr(1),",")
> > > thirdarr = split(splitstr(2),",")
> > > newstr = ""
> > > for i = 0 to ubound(firstarr)
> > > newstr = newstr & firstarr(i) & "," & secondarr(i) & "," & thirdarr(i)
> > > & "#"
> > > next
> > > response.write left(newstr,len(newstr)-1)
> > > %>
>
> > > --
> > > Mike Brind
>
> > Hi Mike
>
> > Thanks for response
> > but my series in str is dynamic...what should i do in that case
>
> > Regards
> > kalyan
>
> >The example you gave shows three sets of 10 values delimited by #.
> >Each of the values within each set is delimited by a comma. Which
> >part(s) are dynamic? The number of sets? The number of values? Are
> >the number of values always the same regardless of the number of sets?
> >Will the number of values change between sets?
>
> >--
> >Mike Brind
> > wrote:
> > Mike
> >
> > The number of sets are dynamic...each set has exactly 10 values all the
> > time separated by comma
> >
> > Kalyan kamesh
>
> First off, please don't use the reply link at the bottom of the post in
> google groups - it wipes out what you are replying to. Use the Reply
> link that is revealed when you click Show Options next to a poster's
> name. Loads of poster's get caught out with that. Google really ought
> to sort their interface out
>
> Back to your question - you need to read them into a 2 d array, then
> read then back out in the order that you want. This should do it:
>
> splitstr = split(str,"#")
> cols=9
> rows=ubound(splitstr)
>
> dim myarray()
> redim myarray(cols,rows)
>
> for y = 0 to rows
> arr = split(splitstr(y),",")
> for x = 0 to cols
> myarray(x,y) = arr(x)
> next
> next
> newstr = ""
> for i = 0 to cols
> for j = 0 to rows
> newstr = newstr & myarray(i,j)
> if j = rows then
> newstr=newstr
> else
> newstr = newstr & ","
> end if
> next
> newstr = newstr & "#"
> next
> response.write left(newstr,len(newstr)-1)
> %>
>
> --
> Mike Brind


Thanks Mike it worked great...thanks for u r reply

Thanks & Regards
kalyan kamesh