Search Results

Modified vgresh99 script

awk -F';' ' /^;/ {next } FNR>1 { $2=($2) ? "Disabled":"Enabled"}1' OFS=';' file

bashwhile IFS=";" read f1 f2
do
[[ $f2 == "S" ]] && echo "$f1;Disabled" || { echo "$f1;Enabled" ;}
done < file

awkawk -FS=" |;|=" '$2 < 0.4' file
grepgrep "AF=0.[0-3]" file

If value of field is not null still you are subtracting filed 2 and field 5.
awk '{ print (NF<6 ? $1" "$2" "$3" "$2-$4" "$4" "$5 : $0)}' file

Hi Znesotomayor,
you can also save your excel as pipe delimited.Keeping JunJun,Binay as it is.
follow the below steps.

press window tab
type regional and language
go to additional settings...

Hi Balav,
can we break this in two steps.
by sed and awk.
sed -i 's/"//g' file
awk 'BEGIN{print "user,phone,duration,login,ip_address";RS="";OFS=",";FS="="} { print $2 OFS $4 OFS $6 OFS $8 OFS...

by sed
sed -i -e "s/exec/\$query1=\'exec/gi" -e "s/^)/)\'/gi" -e "s/^\/\*.*//gi" file

If that is the case , then you have to set env variables in your script. Just source export PATH=${PATH}:${HOME}/bin (for eg) into your script at the top and it will work.

by awk

echo "user lastname" | awk ' { print substr ($1,1,7) substr($2,1,1) } '

awk '
NF && !/^ / {
ofile = $1
next
}
NF && /^ / {
print $1 >> ofile
close(ofile)
}
'...

Hi
you were quite near:), use below code

echo "hello_come_here_g0f0_ffg0" | rev | cut -d"_" -f3- | rev
echo "Hello_h_be_an_f_g1f1_ffe0" | rev | cut -d"_" -f3- | rev