making the first character of word using uppercase using awk and sed


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting making the first character of word using uppercase using awk and sed
# 1  
Old 10-17-2011
making the first character of word to uppercase using awk and sed

I want to make the first character of some words to be uppercase. I have a file like the one below.

uid,givenname,sn,cn,mail,telephonenumber
mattj,matt,johnson,matt johnson,mattj@gmail.com
markv,mark,vennet,matt s vennet,markv@gmail.com
mikea,mike,austi,mike austin,mike@gmail.com

I want to make the 2nd,3rd and 4th fields to start with upper case. Second entry has a middle initial which has to made an uppercase too. Entries from the second row should be modified till the end of the file for all the entries. What would be the easiest way to do this. expected result is.

uid,givenname,sn,cn,mail,telephonenumber
mattj,Matt,Johnson,Matt Johnson,mattj@gmail.com
markv,Mark,Vennet,Matt S Vennet,markv@gmail.com
mikea,Mike,Austi,Mike Austin,mike@gmail.com

Thanks
Matt

Last edited by matt12; 10-17-2011 at 10:14 AM..
# 2  
Old 10-17-2011
# 3  
Old 10-17-2011
Hi matt12,

Try:
Code:
$ cat infile
uid,givenname,sn,cn,mail,telephonenumber
mattj,matt,johnson,matt johnson,mattj@gmail.com
markv,mark,vennet,matt s vennet,markv@gmail.com
mikea,mike,austi,mike austin,mike@gmail.com
$ perl -F"," -lane 'BEGIN { $" = "," } if ($. == 1) { print; next } for ( @F[1..3] ) { s/\b(\w)/ucfirst $1/ge } print "@F"' infile
uid,givenname,sn,cn,mail,telephonenumber
mattj,Matt,Johnson,Matt Johnson,mattj@gmail.com
markv,Mark,Vennet,Matt S Vennet,markv@gmail.com
mikea,Mike,Austi,Mike Austin,mike@gmail.com

Regards,
Birei

Last edited by birei; 10-17-2011 at 10:46 AM..
# 4  
Old 10-17-2011
That command actually did get me the expected results. Thank you so much Birei.
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Finding a word with awk or sed

Hello, in a AIX system : AIX CDRATE01 2 7 00FAB3114C00 my following commande give the result : LISTE /tmp/RESS **************************************************************** Liste TYPE = XXXXXXX EX = YYYY VER ... (13 Replies)
Discussion started by: sam01
13 Replies

2. Shell Programming and Scripting

SED (or other) upper to lowercase, with first letter of first word in each sentence uppercase

The title pretty much defines the problem. I have text files that are all in caps. I would like to convert them to lowercase, but have the first letter of the first word in each sentence in uppercase. I already have SED on the server for fixing / tweaking text files, but I'm open to other... (5 Replies)
Discussion started by: dockline
5 Replies

3. Shell Programming and Scripting

Making use of multiple cores for running sed and awk scripts

Hi All, After reading that the sort command in Linux can be made to use many processor cores just by using a simple script which I found on the internet, I was wondering if I can use similar techniques for programs like the awk and sed? #!/bin/bash # Usage: psort filename <chunksize>... (7 Replies)
Discussion started by: shoaibjameel123
7 Replies

4. Shell Programming and Scripting

sed or awk to print 2nd last word

Hi, I have a file which has the following /usr/new/xyz/abc /us1/neb/yxr/def /usr/bin/cloud1/fgh /net/bin1/txt1/kdq I want to do something like this /usr/new/xyz/abc xyz /us1/neb/yxr/def yxr /usr/bin/cloud1/fgh cloud1 /net/bin1/txt1/kdq txt1 I need to add the 2nd last word to the... (3 Replies)
Discussion started by: matbrow
3 Replies

5. Shell Programming and Scripting

Make the first character uppercase

Input: hello world monkey Output should be: Hello World Monkey How can it be done with perl,sed,awk or bash? (9 Replies)
Discussion started by: cola
9 Replies

6. Shell Programming and Scripting

Getting the first word using sed,awk or perl

Input: root:x:0: daemon:x:1: bin:x:2: sys:x:3: adm:x:4: tty:x:5: disk:x:6: lp:x:7: mail:x:8: Output: root daemon bin sys adm tty (8 Replies)
Discussion started by: cola
8 Replies

7. Shell Programming and Scripting

Uppercase/lowercase comparison of one character per line with awk??

Another frustrating scripting problem from a biologist trying to manipulate a file with several millions line. For each of the line I need to compare the uppercase A or C or G or T with the lowercase a or c or g or t. If there are more uppercases, a + should be added to a new column, otherwise a -... (10 Replies)
Discussion started by: ivpz
10 Replies

8. Shell Programming and Scripting

Uppercase word in PERL

how do i print uppercase words in a string in PERL For example $str=" welcome to UNIX programming" should print UNIX $str="WELCOME to unix programming" should print WELCOME i itried the following /\s+\w+\b/ $str Can u help me in to get a uppercase word in PERL (3 Replies)
Discussion started by: vkca
3 Replies

9. UNIX for Dummies Questions & Answers

using grep and to remove all word with uppercase

I try to write a small script that looks in the file tt for all the words that start with m in lowercase and in which there is no uppercase. #!/bin/sh grep ^m\.*\.\.* tt (4 Replies)
Discussion started by: cfg
4 Replies

10. Shell Programming and Scripting

only uppercase first character?

should be a simple question, I am trying to uppercase every first character in a word on the list. abc google cnn services My first thought was sed 'y/^/^/', but it changed all the characters, not just the first character. any thoughts? (7 Replies)
Discussion started by: fedora
7 Replies
Login or Register to Ask a Question