Search Results

Hi Don,
Thanks a lot for yours quick replay.

Hi Don,

If 2 extra fields $7(SUM1) and $8(SUM2) is there how can we will
Display combination of 4 field unique record and along with concatenate 5th and 6th field and summations of 7 and 8...

Hi Rudic,
can you please help me how can i assign TMP (TMP=$1|$3 or $1|$2) veriable instead of $3 want to pass two values condition $1 and $2 or $1 and $3 if it is matching then dispaly subtotal...

Hi Rudic,
If we have multiple filed (4 to 30)
can we addition all the filed wise and display the total and subtotal
Please let me know if we can use for loop.
Appreciate ur replay

Thanks a lot for your quick replay

---------- Post updated at 08:46 AM ---------- Previous update was at 06:59 AM ----------

Hi Rudic,
if the field has 6 digit it removed the decimal when...

As per my requirement few 4th and fifth field has , separator
like
15,234.00
12,345.00
23,354.00

---------- Post updated at 05:39 AM ---------- Previous update was at 05:37 AM ----------
...

if the 4th and fifth filed are below mention number getting wrong output please help me out of this

111|KKK|ASH|10.25|15,123.00
115|AKKK|ASH|20.15|14,123.00
115|AKKK|ASH|30.00|15,123.00...

If the 4th and the 5th filed are floating point then how should i do the the addition below mentioned syntax i am using unabe to add geetting error
bc |SUM1+=$4
bc |SUM2+=$5
...

Thanks a lot Vgresh99 for ur replay Is it possible to add a header
ACN|NAME|CTY|CTY|NO1-----------|NO2-------
we can add header using echo can we use same in awk

Table
ACN|NAME|CITY|CTY|NO1|NO2
115|AKKK|ASH|IND|10|15
115|AKKK|ASH|IND|20|20
115|AKKK|ASH|IND|30|35
115|AKKK|ASH|IND|30|35
112|ABC|FL|USA|15|15
112|ABC|FL|USA|25|20
112|ABC|FL|USA|25|45
i...

Hi RudiC Appreciate ur replay now i can able to write a script as per requirement but the out put display three extra garbage line at the top which i removed tail+3
is it possible to add code...

below output should be display
First 3 filed will be display unique and last two field should be concatenate

115|AKKK|ASH|10|20|30|30|15|20|35|35
112|ABC|FL|15|25|25|15|20|45

Please use CODE...

sort -t "|" file |awk -F "|" 'a!~$1{print x}a=$1'
please add subtotal in blank line according to name wise each name wise

Write shell script above mentioned table output should be below mentioned table
Please arrange the record group wise then subtotal no1 and no2 name wise and then grand total no1 and no2 name...

Write shell script above mentioned table output should be
Please arrange the record group wise then subtotal no1 and no2 name wise and then grand total no1 and no2 name wise.Ignore the any...

please ignore the space consider the | separtor

111AKKK|SHA|20|25
111|AKKK|SHA|15|35
112|ABC|FL|25|45
112|ABC|FL|15|15
115|AKKK|ASH|10|15
115|AKKK|ASH|20|20
112|ABC|FL|25|20
115|AKKK|ASH|30|35
111|AKKK|SHA|10|45
112|ABC|KL|15|15...