ProgrammingThis forum is for all programming questions.
The question does not have to be directly related to Linux and any language is fair game.
Welcome to LinuxQuestions.org, a friendly and active Linux Community.
You are currently viewing LQ as a guest. By joining our community you will have the ability to post topics, receive our newsletter, use the advanced search, subscribe to threads and access many other special features. Registration is quick, simple and absolutely free. Join our community today!
Note that registered members see fewer ads, and ContentLink is completely disabled once you log in.
Well, using shell scripting you can simply concatenate values by putting them one after another, followed by a comma. For example, every time you read a value in a row, you can append this value to a string, then put a comma, then add the new value and so on. Here is an example of what I'm talking about:
while read line
#if echo $line | grep -q stat # for bash version < 3
if [[ "$line" =~ "stat" ]] # for bash version >= 3
echo -n $number
echo $(echo $line | cut -d ' ' -f3)
if [ -z $number ]
number=$(echo $line | cut -d ' ' -f3),
number=$number$(echo $line | cut -d ' ' -f3),
done < testfile # the name of your input file here
Here, you read a "line", extract the "number" and append it to the previous number (if any) followed by a comma. When you encounter a line containing the string "stat", you echo the "valid/invalid" part, unset the previous "number" and start a new line of output. Hope this helps.