Sponsored Content
Full Discussion: formatting a file headache
Top Forums UNIX for Dummies Questions & Answers formatting a file headache Post 302107362 by ynneycat on Friday 16th of February 2007 09:03:54 AM
Old 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

extremely headache

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

DHCP client & ipchains headache

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

A very headache problem

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

sed make me headache... need help!

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

sed headache

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

scripting headache... loops & variables

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

Friday afternoon headache

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

ssh command headache

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

Formatting file data to another file (control character related)

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

Beginner: script headache

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
aliases(4)							   File Formats 							aliases(4)

NAME
aliases, addresses, forward - addresses and aliases for sendmail SYNOPSIS
/etc/mail/aliases /etc/mail/aliases.db /etc/mail/aliases.dir /etc/mail/aliases.pag ~/.forward DESCRIPTION
These files contain mail addresses or aliases, recognized by sendmail(1M) for the local host: /etc/passwd Mail addresses (usernames) of local users. /etc/mail/aliases Aliases for the local host, in ASCII format. Root can edit this file to add, update, or delete local mail aliases. /etc/mail/aliases.{dir , pag} The aliasing information from /etc/mail/aliases, in binary ndbm(3C) format for use by sendmail(1M). The program newaliases(1M) main- tains these files. /etc/mail/aliases.db The aliasing information from /etc/mail/aliases, in binary, Berkeley DataBase format for use by sendmail(1M). The program maintains these files. Depending on the configuration of the AliasFile option in /etc/mail/sendmail.cf, either the single file aliases.db or the pair of files aliases.{dir, pag} is generated by newaliases(1M). As shipped with Solaris, sendmail(1M) supports both formats. If neither is speci- fied, the Berkeley DataBase format which generates the single .db file is used. ~/.forward Addresses to which a user's mail is forwarded (see Automatic Forwarding). In addition, the NIS name services aliases map mail.aliases, and the NIS+ mail_aliases table, both contain addresses and aliases available for use across the network. Addresses As distributed, sendmail(1M) supports the following types of addresses: Local Usernames username Each local username is listed in the local host's /etc/passwd file. Local Filenames pathname Messages addressed to the absolute pathname of a file are appended to that file. Commands |command If the first character of the address is a vertical bar (|), sendmail(1M) pipes the message to the standard input of the command the bar precedes. Internet-standard Addresses username@domain If domain does not contain any `.' (dots), then it is interpreted as the name of a host in the current domain. Otherwise, the message is passed to a mailhost that determines how to get to the specified domain. Domains are divided into subdomains separated by dots, with the top-level domain on the right. For example, the full address of John Smith could be: js@jsmachine.Podunk-U.EDU if he uses the machine named jsmachine at Podunk University. uucp Addresses ... [host!] host!username These are sometimes mistakenly referred to as ``Usenet'' addresses. uucp(1C) provides links to numerous sites throughout the world for the remote copying of files. Other site-specific forms of addressing can be added by customizing the sendmail.cf configuration file. See sendmail(1M) for details. Stan- dard addresses are recommended. Aliases Local Aliases /etc/mail/aliases is formatted as a series of lines of the form aliasname:address[, address] aliasname is the name of the alias or alias group, and address is the address of a recipient in the group. Aliases can be nested. That is, an address can be the name of another alias group. Because of the way sendmail(1M) performs mapping from upper-case to lower-case, an address that is the name of another alias group must not contain any upper-case letters. Lines beginning with white space are treated as continuation lines for the preceding alias. Lines beginning with # are comments. Special Aliases An alias of the form: owner-aliasname : address sendmail directs error-messages resulting from mail to aliasname to address, instead of back to the person who sent the message. sendmail rewrites the SMTP envelope sender to match this, so owner-aliasname should always point to alias-request, and alias-request should point to the owner's actual address: owner-aliasname: aliasname-request aliasname-request address An alias of the form: aliasname: :include:pathname with colons as shown, adds the recipients listed in the file pathname to the aliasname alias. This allows a private list to be maintained separately from the aliases file. NIS and NIS+ Domain Aliases The aliases file on the master NIS server is used for the mail.aliases NIS map, which can be made available to every NIS client. The mail_aliases table serves the same purpose on a NIS+ server. Thus, the /etc/mail/aliases* files on the various hosts in a network will one day be obsolete. Domain-wide aliases should ultimately be resolved into usernames on specific hosts. For example, if the following were in the domain-wide alias file: jsmith:js@jsmachine then any NIS or NIS+ client could just mail to jsmith and not have to remember the machine and username for John Smith. If a NIS or NIS+ alias does not resolve to an address with a specific host, then the name of the NIS or NIS+ domain is used. There should be an alias of the domain name for a host in this case. For example, the alias: jsmith:root sends mail on a NIS or NIS+ client to root@podunk-u if the name of the NIS or NIS+ domain is podunk-u. Automatic Forwarding When an alias (or address) is resolved to the name of a user on the local host, sendmail(1M) checks for a ~/.forward file, owned by the intended recipient, in that user's home directory, and with universal read access. This file can contain one or more addresses or aliases as described above, each of which is sent a copy of the user's mail. Care must be taken to avoid creating addressing loops in the ~/.forward file. When forwarding mail between machines, be sure that the des- tination machine does not return the mail to the sender through the operation of any NIS aliases. Otherwise, copies of the message may "bounce." Usually, the solution is to change the NIS alias to direct mail to the proper destination. A backslash before a username inhibits further aliasing. For instance, to invoke the vacation program, user js creates a ~/.forward file that contains the line: js, "|/usr/ucb/vacation js" so that one copy of the message is sent to the user, and another is piped into the vacation program. The ~/.forward file can be used to specify special "per user" extensions by creating a .forward+extension file in the home directory. For example, with an address like jsmith+jerry@jsmachine, the sendmail(1M) utility recognizes everything before the "+" as the actual username (jsmith) and everything after it, up to the "@" symbol, as the extension (jerry) which is passed to the mail delivery agent for local use. The default value of the ForwardPath processing option in sendmail(1M) is: O ForwardPath=$z/.forward.$w+$h:$z/.forward+$h:$z/.forward.$w:$z /.forward where $z is the macro for the user's home directory, $w is the macro for the local machine name and $h is the extension. For example, for mail using the address, jsmith+jerry@jsmachine, the sendmail(1M) utility checks each of the four following file names, in the order given, to see if it exists and if it has "safe" permissions, that is, that neither the file nor any of its parent directories are group- or world- writable: ~jsmith/.forward.jsmachine+jerry ~jsmith/.forward+jerry ~jsmith/.forward.jsmachine ~jsmith/.forward The first file that meets the conditions is used to forward the mail, that is, all the entries in that file receive a copy of the mail. The search is then stopped. FILES
/etc/passwd Password file /etc/nsswitch.conf Name service switch configuration file /etc/mail/aliases Mail aliases file (ascii) /etc/mail/aliases.db Database of mail aliases (binary) /etc/mail/aliases.dir Database of mail aliases (binary) /etc/mail/aliases.pag Database of mail aliases (binary) /etc/mail/sendmail.cf sendmail configuration file ~/.forward Forwarding information file ATTRIBUTES
See attributes(5) for descriptions of the following attributes: +-----------------------------+-----------------------------+ | ATTRIBUTE TYPE | ATTRIBUTE VALUE | +-----------------------------+-----------------------------+ |Availability |SUNWsndmr | +-----------------------------+-----------------------------+ SEE ALSO
passwd(1), uucp(1C), vacation(1), newaliases(1M), sendmail(1M), ndbm(3C), getusershell(3C), passwd(4), shells(4), attributes(5) NOTES
Because of restrictions in ndbm(3C), a single alias cannot contain more than about 1000 characters (if this format is used). The Berkeley DataBase format does not have any such restriction. Nested aliases can be used to circumvent this limit. For aliases which result in piping to a program or concatenating a file, the shell of the controlling user must be allowed. Which shells are and are not allowed are determined by getusershell(3C). SunOS 5.11 8 May 2006 aliases(4)
All times are GMT -4. The time now is 12:43 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy