02-16-2007
Thanks - Yes, probably should have been really specific
The file I'm working with will have hundreds of lines. The first few lines basically like this (incl headers)
The end of each line always has 6 commas, but before the 6 commas are the subjects each user is enrolled in. There may actually be twenty or more subjects.
It looks like the initial sed you suggested only works if there are two subjects per line. In my real file, the exact number of subjects per line is unpredictable.
User Name,Password,ID,First Name,Last Name,Subject,Other,#User Type,City,#Email,#Some Field,#Another Field
jsmi3279,xxxxxx,123456789,John,Smith,XMLT1005:MATH2987:PHYS4597:FRNC3578:ITLN590:LATN3490,,,,,,
glik2398,xxxxxx,123456789,Gill,Likely,XMLT1001:XMLT1004:MATH2987:PHYS4597,,,,,,
lbro4982,xxxxxx,123456789,Lucinda,Brown,XMLT1001:XMLT1002:ENGL3689:JAPN9257,,,,,,
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
I need to execute command at remote host from my program.
there is rs6000/aix standard command called rexec.
unfortunately rexec ask username and password which must supplied interactively, of course it is impossible runned by program.
So I have to change rexec command format to make user-name... (5 Replies)
Discussion started by: yatno
5 Replies
2. IP Networking
Hi all,
I upgraded my SUSE 6.1 to SUSE 7.1 and at once the following things won't work anymore:
1) My DHCP client is not able anymore to retrieve my IP address from the @home server. It times out all the time. If I use a fixed IP I can get on the net, so there is no physical problem.
2) I... (3 Replies)
Discussion started by: Micky
3 Replies
3. Solaris
guys, need your help~~~~
I am setting up a Sun Enterprise 450 Ultra 4 server
originally I was using Sun solaris 9 1202 version.
but after an accident (i guess becoz i deleted something wrongly), the system cannot boot up.
and now I wana install a FreeBSD(since it is free and it will... (3 Replies)
Discussion started by: MrDJay
3 Replies
4. Shell Programming and Scripting
I've still a little problem with sed.
So, the content of my file.txt is like:
101.10.20.2.1079 > 101.11.2.20.80:
101.10.20.2.1080 > 101.11.2.20.80:
101.10.20.2.1081 > 101.10.20.2..80:
101.05.15.143.1068 > tpo68-96-22-1.no.no.cox.net.4391:
101.05.15.143.1072 >... (5 Replies)
Discussion started by: nymus7
5 Replies
5. UNIX for Dummies Questions & Answers
Hi all,
I've got a thorny sed/regex problem and I thought somebody out there might be able to help.
I'd like to use sed in a Makefile to parse a path string. The path might look like this:
case 1: /mnt/users/bob/build/src
or
case 2: /mnt/users/bob/build/src/foo
or
case 3: ... (4 Replies)
Discussion started by: gnarl
4 Replies
6. Shell Programming and Scripting
Surely there's an easier way to do this, lets see if anyone knows! I am new to scripting so go easy on me!
I have the following script and at the moment it doesn't work and I believe the problem is that I am using a while loop within a while loop. When I run the script using sh -x I can see... (6 Replies)
Discussion started by: StevePace
6 Replies
7. Shell Programming and Scripting
Hi all,
It's been a long week and my brain is clearly not functioning right so hopefully someone can help me out here.
I've got a function in a script which just checks if a MySQL database directory exists or not. Code is as follows:
dbCheck2() {
if ;
then {
:
# carry... (4 Replies)
Discussion started by: _Spare_Ribs_
4 Replies
8. UNIX for Advanced & Expert Users
Good day,
I am trying to run a ssh command on a remote server, but when I run the command the server takes FOREVER... and ends up giving me an error..
then the script also kicks server load up by 100% while it is running..
But if I run the same command on the server it goes pretty quickly and... (3 Replies)
Discussion started by: msullivan
3 Replies
9. Shell Programming and Scripting
I have to write a program to read data from files and then format into another file. However, I face a strange problem related to control character that I can't understand and solve.
The source file is compose of many lines with such format:
T_NAME|P_NAME|P_CODE|DOCUMENT_PATH|REG_DATE
... (3 Replies)
Discussion started by: hk6279
3 Replies
10. Shell Programming and Scripting
Hi,
I am new to shell scripting, but doing my best to learn things. Today doing courses there was exercise like this:
#!/usr/bin/bash
a=$1
b=$2
if ]
then
echo "Conditions are met"
else
echo "Conditions are not met"
fi
I improved it a little, beacuse of curiosity :D to this:
... (8 Replies)
Discussion started by: Rosentine
8 Replies
QUIZ(6) BSD Games Manual QUIZ(6)
NAME
quiz -- random knowledge tests
SYNOPSIS
quiz [-t] [-i file] [question answer]
DESCRIPTION
The quiz utility tests your knowledge of random facts. It has a database of subjects from which you can choose. With no arguments, quiz
displays the list of available subjects.
The options are as follows:
-t Use tutorial mode, in which questions are repeated later if you didn't get them right the first time, and new questions are presented
less frequently to help you learn the older ones.
-i Specify an alternative index file.
Subjects are divided into categories. You can pick any two categories from the same subject. quiz will ask questions from the first cate-
gory and it expects answers from the second category. For example, the command ``quiz victim killer'' asks questions which are the names of
victims, and expects you to answer with the cause of their untimely demise, whereas the command ``quiz killer victim'' works the other way
around.
If you get the answer wrong, quiz lets you try again. To see the right answer, enter a blank line.
Index and Data File Syntax
The index and data files have a similar syntax. Lines in them consist of several categories separated by colons. The categories are regular
expressions formed using the following meta-characters:
pat|pat alternative patterns
{pat} optional pattern
[pat] delimiters, as in pat[pat|pat]pat
In an index file, each line represents a subject. The first category in each subject is the pathname of the data file for the subject. The
remaining categories are regular expressions for the titles of each category in the subject.
In data files, each line represents a question/answer set. Each category is the information for the question/answer for that category.
The backslash character (``'') is used to quote syntactically significant characters, or at the end of a line to signify that a continuation
line follows.
If either a question or its answer is empty, quiz will refrain from asking it.
FILES
/usr/share/games/bsdgames/quiz The default index and data files.
BUGS
quiz is pretty cynical about certain subjects.
BSD
May 31, 1993 BSD