Search Results

Hello ken6503,

Could you please try following and let me know if this helps.

awk -F", " '($2 ~ /\.[0-9]{3}+/){print $1,$2}' Input_file
Output will be as follows.

xyz, 123456.789
Also I...

That is a good start. The ERE you are using is matching a decimal point followed by two decimal digits (which as you have found only matches lines with exactly two decimal places) at the end of the...

try this...

awk -F, '{split($2,Arr,".")}length(Arr[2])>2' test

awk -F"," '$2 ~ /\.[0-9][0-9][0-9]/' test

Hello ken6503,

Could you please try following and let me know if this helps you.

awk -F"," 'function abs(value){sum+=value;return sum} {abs($8)}{;print sum OFS $8} END{printf("%.2f\n",sum)}' ...

awk -F "," '$8 < 0{$8=$8*-1} {sum+=$8} END {printf "%.2f\n", sum}' file

How about {sum+=$8<0?-$8:$8}?

You need to declare/define the abs function if you want to use it.

Interesting solutions so far :b:

Here is my try, in perl:
perl -pe 'if($. == 1 || eof) {s/,/ /g}' file

Indeed, sed is the most suitable for this application, when removing trailing comma's only on the first and last line.

Yet, here is another approach using awk, removing trailing comma's only on...

Hello All/Ken6503,

One more approach here which is based on that if first or last lines will always have consecutive 4 commas as like shown Input_file, then following may help in same too.

awk...

What a funny contest.
On the same way :
$ awk 'FNR == 1 && NR != 1{last=NR-1}NR == FNR{next}FNR == 1 || FNR ==last{gsub(",",X)} 1 ' file.txt file.txt

RavinderSingh13: Interesting approach ...
awk 'gsub(/,/, _, $1) && gsub (/,/, _, $NF)' RS="" FS="\n" OFS="\n" file

The shortest way :
$ awk -v last=$(wc -l <file.txt) 'NR==1 || NR==last{gsub(",","")}1' file.txt

Hello Ken6503,

Could you please try following too and let me know if this helps you.

awk '{for(i=1;i<=NF;i++){if(i==1 || i==NF){gsub(/,/,X,$i);print $i} else {print $i};}}' RS="" FS="\n" ...

Try also
awk 'FNR == 1 || FNR == c {c = NR-1; gsub(",",X)} FNR < NR' file file

Another approach by reading file twice:-
awk 'NR==FNR{++c;next}FNR==1||FNR==c{gsub(",",X)}1' file file

awk doesn't know about the last line when it works on the last line, only afterwards. So it's not THAT easy in awk:
awk 'LAST {print LAST}; NR==1 {gsub (/,/,_)}; {LAST = $0} END {gsub (/,/, _,...

Your sample file has an empty first line, so no commas, and the following wouldn't work:
sed '1s/,//g;$s/,//g' file
ABC HEADER TOTAL RECORDS ARE 2.00
C,300,ABC,BC,
C,400,ABC,TO,
ABC TRAILER....

-n tests the following token for non-empty.
But the [ ] is a test command, and does not see the empty value of $p at all, but it sees a "" as an empty token.
The result for -n without a following...

You are welcome. If you try:
( set -x; [ -n $p ] && [ -n "$p" ])
+ '[' -n ']'
+ '[' -n '' ']'
You'll notice that the first one evaluates to -n and the second one to -n ''

In the first case the...

Thanks, I have updated my code in post#2.

Another variation
while read p
do
[ -n "$p" ] && para="$para,'$p'"
done < file
para=${para#,}


---
Small correction to MadeInGermany's suggestion:
para="${para:+"${para}",}'$p'"

Hello Ken6503,

You haven't shown us the expected output, so I am not sure either we need to put both conditions of having number of fields lesser than 5 + $NF(last field's) value should be grater...

That may be the most correct way but a quick way to get the same output is to just append the new value and the field separator inside of $1.


mute@tiny:~$ awk 'NF<5{$1=$1 FS "XXX"}1' FS=, OFS=,...

Assuming that the first field will always be exactly one of those three characters, you could also try something like:
awk -F'|' '{print > ($1=="D"?d:$1=="H"?h:t)}' d="$det_name" h="$hea_name"...