awk and tr troubles


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting awk and tr troubles
# 1  
Old 07-29-2011
awk and tr troubles

I am trying to make all the fields containing lower case letters upper case and the third field of a file display ** instead.
I have this:

Code:
 awk '{printf "%s %s ** %d %d\n", $1, $2, $4, $5}' database.txt | tr '[:lower:]' '[:upper:]' < database.txt

And that only changes it to upper case, other way around then it would display just the stars. Is there any way of doing BOTH?
# 2  
Old 07-29-2011
not understand your question. Could you please provide the sample database.txt and expect output directly?
# 3  
Old 07-29-2011
Remove "< database.txt"
Code:
 awk '{printf "%s %s ** %d %d\n", $1, $2, $4, $5}' database.txt | tr '[:lower:]' '[:upper:]'

# 4  
Old 07-29-2011
That did the trick, thank you. I also have a problem with changing delimiters between fields.
Code:
 awk -F"-" '{print $1 $2 $3 $4 $5 $6}' database.txt

is what I have, and have been fooling around with it but I don't get any results.
# 5  
Old 07-29-2011
Do you mean Output Field Separator (OFS)? Then:
Code:
awk 'BEGIN {OFS="-"} { print $1, $2 ... }'


Last edited by yazu; 07-29-2011 at 01:54 AM..
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

Troubles with OpenSSH

Hi, I am trying to login from one AIX server to another without using a password, a basic configuration, however it doesn't seem to work. All things are in place. I have both a public and private key in the ~/.ssh folder and also have an "authorized_keys" file on the target-server containing... (5 Replies)
Discussion started by: Hille
5 Replies

2. Shell Programming and Scripting

G/AWK and ksh troubles

Alright, so I've been banging my head against the wall for the past 7 hours trying to figure this out :wall:. What I'm trying to do is "unwrap" periodic coordinates from a molecular simulation to put them back in their unit cell box. I've accomplished that little bit of magic easily enough, but... (6 Replies)
Discussion started by: DEC014
6 Replies

3. BSD

PF troubles on OpenBSD 5.0

I am setting up a system as an ADSL gateway. ADSL is working fine. PF is not forwarding for some reason. # ifconfig lo0: flags=8049<UP,LOOPBACK,RUNNING,MULTICAST> mtu 33196 priority: 0 groups: lo inet6... (0 Replies)
Discussion started by: John Tate
0 Replies

4. UNIX for Dummies Questions & Answers

Cron troubles

I am aware this question has been answered time and again. I feel I have tried everything I have seen on the net and really need help to get this working. Same old story. Shell script, working from command but not from cron. I need my script to take values from a .properties file. Tried... (2 Replies)
Discussion started by: airalpha
2 Replies

5. Shell Programming and Scripting

Encoding troubles

Hello All I have a set of files, each one containing some lines that follows that regex: regex='disabled\,.*\,\".*\"'and here is what file says about each files: file <random file> <random file> ASCII text, with CRLF line terminatorsSo, as an example, here is what a file ("Daffy Duck - The... (3 Replies)
Discussion started by: tukuyomi
3 Replies

6. Shell Programming and Scripting

if-statement troubles

I try to compare the day and month of someones birthday with the day and month of today, so my little bash script can send a mail to the person that has its birthday that day. The first line of the file birthdays looks like this: firstname,lastname,01/01/1990,.... The variable birthday's... (4 Replies)
Discussion started by: doc.arne
4 Replies

7. HP-UX

cron troubles

I have a cronjob that I need to run everyday and it needs to have todays date inputed, here is what I have, but is not working as expected.......... 23 02 * * * cd /path;./RequestSummaryReport.sh $(date +%Y-%m-%d) the output from mail gives me............. Date: Fri, 8 Feb 2008 02:12:07... (4 Replies)
Discussion started by: theninja
4 Replies

8. UNIX for Dummies Questions & Answers

ssh2 troubles

I'm trying to set up a secure and trusted connection between 2 boxes running solaris using ssh2. I've run ssh-keygen2 on the local box and on the remote box, created the identification file ( IdKey id_dsa_2048_a ) on the local machine and copied across the public key file from the local to... (5 Replies)
Discussion started by: PaulC
5 Replies

9. UNIX for Dummies Questions & Answers

Password Troubles

I'm very new to UNIX (I just started working with Terminal 2 days ago) and I don't know the system very well. I'm having trouble whenever I am asked for a password. I simply... can't type. I press keys on the keyboard but no characters appear on the screen. For example, when I log onto... (5 Replies)
Discussion started by: alexmiller
5 Replies

10. Programming

Troubles with HPUX

Hello I created an application in c language for HP-UX operative system,and it runs on a 32 bits PARISC processor. My problem is that I have to run this same application but now in a 64 bits Parisc processor. But I am not able to compile the application with the 64 bit server, and I only could use... (1 Reply)
Discussion started by: masterboy6666
1 Replies
Login or Register to Ask a Question