output format

Discussion in 'ASP General' started by kalikoi@gmail.com, Mar 29, 2006.

  1. Guest

    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
     
    , Mar 29, 2006
    #1
    1. Advertising

  2. Mike Brind Guest

    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, Mar 29, 2006
    #2
    1. Advertising

  3. Guest

    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
     
    , Mar 29, 2006
    #3
  4. Mike Brind Guest

    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 Brind, Mar 29, 2006
    #4
  5. Guest

    Mike

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

    Kalyan kamesh
     
    , Mar 29, 2006
    #5
  6. Mike Brind Guest

    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
    > 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, Mar 30, 2006
    #6
  7. Guest

    Mike Brind wrote:
    > 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
    > > 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
     
    , Mar 31, 2006
    #7
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Brian Candy
    Replies:
    2
    Views:
    1,169
    Janaka
    Feb 18, 2004
  2. Andy
    Replies:
    7
    Views:
    6,264
    Roedy Green
    May 10, 2004
  3. shannon
    Replies:
    1
    Views:
    8,601
  4. shannon
    Replies:
    0
    Views:
    574
    shannon
    Feb 1, 2006
  5. Replies:
    6
    Views:
    466
    Thomas Ganss
    Jan 15, 2006
Loading...

Share This Page