change line output

[Elfriede]

Hey guys

i have a mysql query which gives me eg as result:

{Tom 2} {Simon 67} {Phoenix 8} {Sally 12} {Richard 43}

how can i manipulate this list to look like

Tom: 2 Simon: 67 Phoenix: 8 ... ?

many thanks

[Sir_Fz]

Suppose $mylist is the list containing your data (I assume it's a list of lists). You can do the following:

Code: Select all

set output ""
foreach element $mylist {
 # $element is a list containing {"Name" "Score"}
 foreach {a b} $element {break}
 append output "${a}: $b "
}
# now $output is a string containing the data in your desired form

[Elfriede]

many thanks !