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}'

#!/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
...

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

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'

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

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

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

awk '{print $1}' file.xml

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

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

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?