Search Results

grep -v "OK" is another option to exclude lines with string "OK".

In your awk command, try printing entire line instead of just first field using just print or print $0

Change your awk to

awk '{a[NR]=$3;b[NR]=$4;row[NR]=$0} END {for (i in a) printf("%s\t%.3f\n", row[i],(1-(b[i]/(7*24*60*a[i]))))}' infile

Or you can modify your awk statement to as below

awk '{for(i=2;i<=NF;i++) {if (substr($i,1,1)=="#") next; else print $1,$i}}'

DIR=/your/directory
for FILE in $(ls $DIR)
do
OLD_DT=$(echo ${FILE##*_} | cut -d. -f 1)
NEW_DT=$(expr substr $OLD_DT 5 4)$(expr substr $OLD_DT 1 4)
RENAMED_FILE=$(echo...

awk solution (can be made better)


awk '{for(i=1;i<=NF;i++) {if($i~/\(/) a=a" "substr($i,1+index($i,"("))} }{gsub(/\)/,"",a);print a;a=""}' infile

awk '{sum+=$2;a[++i]=$1} END{for (i in a) {print a[i]"/"sum}}' infile

You may try the find command


find $HOME -type f -exec ls -l {} \;


or


ls -ltcR $HOME | awk '/^\// {dir=substr($0,1,length($0)-1)} /^-/{$9=dir"/"$9;print}'

x=$(ps -fu myuserid | grep [j]ava | awk '{print $2}')
if [ ! -z $x ]
then
echo process is running
else
echo process not running
fi

#!/usr/bin/ksh
TOTAL_NR_OF_FILES=$(find SMS_* -type f | wc -l)
AVG=$(expr $TOTAL_NR_OF_FILES / 6)

SUFFIX=1
MOVED=0
for FILENAME in $(find SMS_* -type f)
do
if [ $MOVED -eq $AVG ]
then
...

Did you try the tr option to remove control characters?

tr -d [:cntrl:] <filename >output

ls /dev | awk 'match($0,/asm/) {print substr($0,RSTART,RLENGTH)}'

df -k | awk -F":" '/^\//{a=a$1" : ";next} /%/ {a=a$1"\n"} END{print a}' | awk '(NF>0){$5=100-$5; $7="free"; $8=""} 1'

Hi jiam,

1. Did you receive any error message?
2. If you had got back to the prompt after the command executed then check if file outfile is created in current directory

awk -vf1=outfile '/2351/,/2339/ {$2=0} /2338/,/2333/ {$2=1} {a=a$0"\n"} END{print NR>f1; print a>>f1}' infile

Assuming you don't have text separated by spaces or tabs in a single line

awk '{print $1}' file.xml

You need to use awk variable like this:


awk -F, -v td=$temp_date '/1,jobname1/ {$3="completed";$5=td} 1' OFS="," file

awk -F, 'BEGIN{"date +\"%Y%m%d%H%M%S\""|getline d} /1,jobname1/{$3="completed";$5=d} 1' filename

awk -F, '/1,jobname1,in_progress/ {$3="completed"} 1' filename

awk '{print "t"++i" as filler VARCHAR"}' extract_file

awk -F":" '{gsub(/,/,"\n"$1":")}1' file

Could you explain more on what is the issue? What is the output you are getting?

I see that your input and output are .csv files. Did you copy paste the input data from excel to here?

I used a...

When you are on a terminal, just hit \ and enter to continue command in the next line.

Example:

>echo "Hello \
> World! "
Hello World!

You can probably do this if it is okay to create another file and then move it to original file


grep -vf file2 file1 >file3
mv file3 file1

I could see a \r carriage return character from the data you have posted. Was file2.txt transferred from a windows environment to unix?

If yes, please remove the CRLF (carriage return line feed)...

Can you also double check the contents of file2.txt?