10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
I have a csv file with given details
abc.txt
123,ra,point,,there
232,ba,points,home,pheer
I want to get those values and store them in different variables:
Code:
while read line
do
echo $line |awk -F"," '{print $1" "$2" "$3" "$4" "$5"}'|read dbt_acct val_dt crncy AMT... (11 Replies)
Discussion started by: rahulsk
11 Replies
2. Shell Programming and Scripting
I am trying to remove $1 along with the blank values from the file. Thank you :).
file
R_Index Chr Start End Ref Alt Func.IDP.refGene Gene.IDP.refGene GeneDetail.IDP.refGene Inheritence ExonicFunc.IDP.refGene AAChange.IDP.refGene avsnp147 PopFreqMax ... (5 Replies)
Discussion started by: cmccabe
5 Replies
3. Shell Programming and Scripting
Hello,
I have files with fixed length fields.
12345 12345 12345671234567 10 1234567
12345 12345 123456 1234567 10 1234567
I want to take 1st, 3rd, 4th and 6th string.
Usually 3rd and 4th string are coming as it is on the first row /1234567 and... (3 Replies)
Discussion started by: apenkov
3 Replies
4. Shell Programming and Scripting
I am using below code to validate the source file,code working fine but if any column contains null value then below code throwing error actually it should not.how to customize the below code to handle null null values also.
When I run the script with below source data getting “date error”, as... (2 Replies)
Discussion started by: srivalli
2 Replies
5. Shell Programming and Scripting
Hello;
i have a file contains records such as below, i want to AWK read pre-defined fixed column width and print desired output. so i wrote this command:
input:
Event 9477887 Western Iran
Date Time Err RMS Latitude Longitude Smaj Smin Az Depth Err Ndef Nsta Gap mdist ... (4 Replies)
Discussion started by: saeed.soltani
4 Replies
6. Shell Programming and Scripting
Hello guys,
I have a problem concerning the formatting when performing calculations with variables passed to awk and using fieldwidth definitions and printf.
I have the following code:
awk 'BEGIN{ FIELDWIDTHS = "5 3 7 5 8 8 8" }{if ($7 != "") printf"%s%-s%s%s%s%s%s\n",$1,$2,$3,$4,$5,$6,$7;... (2 Replies)
Discussion started by: origamisven
2 Replies
7. Shell Programming and Scripting
Hi,
I have a pipe seperated file
I want to write a code to display count of lines that have 20th field not null.
nawk -F"|" '{if ($20!="") print NR,$20}' xyz..txt
This displays records with 20th field also null.
I would like output as: (4 Replies)
Discussion started by: pinnacle
4 Replies
8. Shell Programming and Scripting
hi
i try to check if awk returns null
and i dont know how it's works
this is the command
set EndByC = `ls -l $base | awk '/.c$/ {print $9}'`
if ($EndByC=="") then #check if ther is XXX.c directory
echo Sorry ther is no XXX.c folder "in" $base path
echo the XXX.c folder is necessary... (6 Replies)
Discussion started by: frenkelor
6 Replies
9. Shell Programming and Scripting
hi
i have records in my input file like this
aaa|1234||2bc||rahul|tamilnadu
bba|2234||b4c||bajaj|tamilnadu
what i am expecting is in between two pipes if there is no character it should be replaced with null or 0
so my file will look like this
aaa|1234|null|2bc|0|rahul|tamilnadu... (4 Replies)
Discussion started by: trichyselva
4 Replies
10. Shell Programming and Scripting
Hi,
Im trying to write something that will report if a filesytem is over 80% but the problem is the output reports on a dir that is a 9%.
any ideas?
this is what I have
*************************************************
if
then
param=90
else
param=$1
fi
df -kl | grep... (1 Reply)
Discussion started by: collie
1 Replies