UNIX : Awk example to strip character of word

The below program will read all the first character of a line and join it together.

#!/bin/bash

F="file.txt"

for i in $(cat $F)
do
          echo $i | awk -F"_" 'BEGIN{ st="" } 
          { for( i=1; i<=NF; i++ )
          { st=st""toupper(substr($i,1,1)) }
          }
           END{ print st }'
done

The program will read a file with "_"(underscore) delimited content. Then all the first character of the line will be striped and joined together.

Eg:

File name : Word_File_Created_by_John"

Output : WFCBJ

Note then small case is also turned to upper case.

The below awk functions are used in this program

toupper() - This will convert the string to upper case
substr() - This will strip the specific character(s) from the string

Comments

UNIX : How to get record count from zipped file

Sometimes we may need to get records count from file . For that we can use wc -l , command with file name. In some situation the file will be in compressed format . wc -l will not directly work with zipped files . In this case we can do zcat the file and pipe the word count command with it. Example : Let say we have a file cricketData.dat.gz To get word count from the file use : zcat cricketData.dat.gz | wc -l This will give the record count.

Scala

Scala is a object oriented functional type programing language. All variables declared in scala is considered as objects.

Excel : How to pad zeros

Today I got a requirement to format the number in excel cell - to left pad number with zeros.i find the following function very useful to do it. In case one to make the number left padded with "0" s give the formula =TEXT(A1,"0000") In case two even more enhanced form to make it left padded with "0" and add two decimal places give the formula as =TEXT(A2,"0000.00")

Tech Info Talks

Search This Blog