Convert to upper case first letter of each word in column 2 Post: 302417901

Sponsored Content

Top Forums Shell Programming and Scripting Convert to upper case first letter of each word in column 2 Post 302417901 by pseudocoder on Saturday 1st of May 2010 10:08:21 AM

05-01-2010

Registered User

Hope you will also give my solution a chance, as I have put too much effort in it.

capitalize

Code:

# capitalize each word in a string
function capitalize(input,    result, words, n, i, w)
{
	result = ""
	n = split(input, words, " ")
	for (i = 1; i <= n; i++) {
		w = words[i]
		w = toupper(substr(w, 1, 1)) substr(w, 2)
		if (i > 1)
			result = result " "
		result = result w
	}
	return result
}

# main program, for testing
{ print capitalize($0) }

Code:

$ awk -F"," '{$2=tolower($2); print $2}' file | nawk -f capitalize > tfile1
$ awk -F"," '{print $2}' file > tfile2
$ touch ofile
$ exec 3< tfile2
$ while read line1
do
read line2 <&3
sed ''/"$line2"/s//"$line1"/'' file | grep "$line1" >> ofile
done < tfile1
$ rm tfile1 tfile2

A question for the awk pro's:
While I was trying to avoid creating of temporary files, I managed to put the output of the first two commands in two variables

Code:

formatted=$(the first awk command here)
tosed=$(the second awk command here)

, but I didn't manage to split the content, so I'd really like to know how to put it in two shell arrays instead.

pseudocoder

View Public Profile for pseudocoder

Find all posts by pseudocoder

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

after i convert upper case to lowercase

If user chosen to tolower then it should convert file name to lower or vice versa. when file names converted it should put into appropriate subdirectories. e.g when files converted it then seperate them out with file etension where it will seperate them out . such as file.pdf, phone.doc both...

2. UNIX for Dummies Questions & Answers

How to add a space after an Upper case letter

Hi I have two questions. 1. how to convert "EverythingIsFine" to "Everything Is Fine" in a txt file. 2. how to convert everything to upper case letter and reverse, I hope there is a general purpose script for this.

3. Shell Programming and Scripting

how to convert value in a variable from upper case to lower case

Hi, I have a variable $Ctrcd which contains country names in upper case and i want to convert them into lower case. I have tried so many solutions from already existing threads but couldn't get the correct one. Can anybody help me with this..... Thanks a lot..

4. Shell Programming and Scripting

convert upper case to lower case in ascript

I have a package to install and the installation script which does it . The files/directories names in the script are all lower case but the actual package has everything in upper case - file names, directories . I don't want to rename directories and files in the package - it has a lot of them . ...

5. Shell Programming and Scripting

Script to Convert Upper case to Lower case

Hi All I have a script which extracts values from a Database (A persons name) and puts it into a variable in my script IE: $NAME However the Value in the DB is all in uppercase and contains the users first name and last name EG: > echo $NAME GRAHAM BOYLE > What I need is only the...

6. Shell Programming and Scripting

Convert first character of each word to upper case

Hi, Is there any function(Bash) out there that can convert the first character of each word to upper case?...

7. UNIX for Dummies Questions & Answers

To convert Lower case to Upper Case

There is a script where we pass the parameter in lower case: say: . ./scriptName pArameter #!/bin/ksh echo "`date` Entering $0 Reloading the $1 table " mname1=$1 (code to login MYSQL Database) Truncate table $mname1; exit ! Since now there is a limitaion of MYSQL that it accept...

8. 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...

9. Shell Programming and Scripting

Upper case letter match

Hi, im able to search for string in a file (ex: grep -w "$a" input.txt). but i have to search for the uppercase of a string in a file where upper case of the file content matches something like below. where upper("$a")== converted to upper case string in (input.txt) can someone please provide...

10. Shell Programming and Scripting

Change first letter of a word from lower case to upper case

Hi all, I am trying to find a way to change first letter in a word from lower case to upper case. It should be done for each first word in text or in paragraph, and also for each word after punctuation like . ; : ! ?I found the following command sed -i 's/\s*./\U&\E/g' $@ filenamebut...

LEARN ABOUT DEBIAN

igawk

IGAWK(1)							 Utility Commands							  IGAWK(1)

NAME

       igawk - gawk with include files

SYNOPSIS

       igawk [ all gawk options ] -f program-file [ -- ] file ...
       igawk [ all gawk options ] [ -- ] program-text file ...

DESCRIPTION

       Igawk is a simple shell script that adds the ability to have ``include files'' to gawk(1).

       AWK programs for igawk are the same as for gawk, except that, in addition, you may have lines like

	      @include getopt.awk

       in your program to include the file getopt.awk from either the current directory or one of the other directories in the search path.

OPTIONS

       See gawk(1) for a full description of the AWK language and the options that gawk supports.

EXAMPLES

       cat << EOF > test.awk
       @include getopt.awk

       BEGIN {
	    while (getopt(ARGC, ARGV, "am:q") != -1)
		 ...
       }
       EOF

       igawk -f test.awk

SEE ALSO

       gawk(1)

       Effective AWK Programming, Edition 1.0, published by the Free Software Foundation, 1995.

AUTHOR

       Arnold Robbins (arnold@skeeve.com).

Free Software Foundation					    Nov 3 1999								  IGAWK(1)

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

after i convert upper case to lowercase

Discussion started by: Alex20

2. UNIX for Dummies Questions & Answers

How to add a space after an Upper case letter

Discussion started by: onthetopo

3. Shell Programming and Scripting

how to convert value in a variable from upper case to lower case

Discussion started by: manmeet

4. Shell Programming and Scripting

convert upper case to lower case in ascript

Discussion started by: vz6zz8

5. Shell Programming and Scripting

Script to Convert Upper case to Lower case

Discussion started by: grahambo2005

6. Shell Programming and Scripting

Convert first character of each word to upper case

Discussion started by: harchew

7. UNIX for Dummies Questions & Answers

To convert Lower case to Upper Case

Discussion started by: ambarginni

8. Shell Programming and Scripting

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

Discussion started by: dockline

9. Shell Programming and Scripting

Upper case letter match

Discussion started by: p_satyambabu

10. Shell Programming and Scripting

Change first letter of a word from lower case to upper case

Discussion started by: georgi58

LEARN ABOUT DEBIAN

igawk