02-16-2007
formatting a file headache
Hello does anyone know how to do the following using some simple unix if possible:
I have a file with the following info as comma separated. It shows username, id number and all the subjects they are enrolled in on the one line. The subjects are separated by colons.
UserName,ID,Subject
jsmith,235456939,MATH29879:PHYS45979
jdoe,750378929,ENGL36899:JAPN92576
I need it to have just one course per user line per user. So that it would look like:
jsmith,235456939,MATH29879
jsmith,235456939,PHYS45979
jdoe,750378929,ENGL36899
jdoe,750378929,JAPN92576
Does anyone have any ideas? I'm pulling my hair out!
Thnx
-J
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
LEARN ABOUT PHP
posix_getpwnam
POSIX_GETPWNAM(3) 1 POSIX_GETPWNAM(3)
posix_getpwnam - Return info about a user by username
SYNOPSIS
array posix_getpwnam (string $username)
DESCRIPTION
Returns an array of information about the given user.
PARAMETERS
o $username
- An alphanumeric username.
RETURN VALUES
On success an array with the following elements is returned, else FALSE is returned:
The user information array
+--------+---------------------------------------------------+
|Element | |
| | |
| | Description |
| | |
+--------+---------------------------------------------------+
| name | |
| | |
| | The name element contains the username of the |
| | user. This is a short, usually less than 16 char- |
| | acter "handle" of the user, not the real, full |
| | name. This should be the same as the $username |
| | parameter used when calling the function, and |
| | hence redundant. |
| | |
|passwd | |
| | |
| | The passwd element contains the user's password |
| | in an encrypted format. Often, for example on a |
| | system employing "shadow" passwords, an asterisk |
| | is returned instead. |
| | |
| uid | |
| | |
| | User ID of the user in numeric form. |
| | |
| gid | |
| | |
| | The group ID of the user. Use the function |
| | posix_getgrgid(3) to resolve the group name and a |
| | list of its members. |
| | |
| gecos | |
| | |
| | GECOS is an obsolete term that refers to the |
| | finger information field on a Honeywell batch |
| | processing system. The field, however, lives on, |
| | and its contents have been formalized by POSIX. |
| | The field contains a comma separated list con- |
| | taining the user's full name, office phone, |
| | office number, and home phone number. On most |
| | systems, only the user's full name is available. |
| | |
| dir | |
| | |
| | This element contains the absolute path to the |
| | home directory of the user. |
| | |
| shell | |
| | |
| | The shell element contains the absolute path to |
| | the executable of the user's default shell. |
| | |
+--------+---------------------------------------------------+
EXAMPLES
Example #1
Example use of posix_getpwnam(3)
<?php
$userinfo = posix_getpwnam("tom");
print_r($userinfo);
?>
The above example will output something similar to:
Array
(
[name] => tom
[passwd] => x
[uid] => 10000
[gid] => 42
[gecos] => "tom,,,"
[dir] => "/home/tom"
[shell] => "/bin/bash"
)
SEE ALSO
posix_getpwuid(3), POSIX man page GETPWNAM(3).
PHP Documentation Group POSIX_GETPWNAM(3)