Search Results

Search: Posts Made By: Shenbaga.d
2,350
Posted By Shenbaga.d
Grep spacing issue
Hi,

I'm trying to match html strings using grep commend and I'm not able to eliminate the extra spaces. This is working when there is no space. Can anyone help me what am I missing here?
I'm...
1,447
Posted By Shenbaga.d
Hi Ravinder, i have tested and it is working...
Hi Ravinder,

i have tested and it is working as i expect.

Thank you very much!!
1,447
Posted By Shenbaga.d
Match the value & print lines from the match
Hello,

I have a file contains two columns. I need to print the lines after “xxx” so i'm trying to match "xxx" & cut the lines after that. I'm trying with the grep & cut command, if there any...
1,569
Posted By Shenbaga.d
i've enter example. i can use excel but its huge...
i've enter example. i can use excel but its huge data so i can't work in excel...
1,569
Posted By Shenbaga.d
awk cmd for vlookup in Mysql
Hi,

Is there possible to do vlookup in Mysql one table from another table based on one column values and placed the data in same table?

if it is possible in mysql itself pls share links for...
969
Posted By Shenbaga.d
Get the awk cmd for two condition
Hi All,

i have following cmd to get a “n/a” value from one particular column, but if i need to take one column n/a value with based on other column this cmd will help?

ex:
col1 col2 ...
751
Posted By Shenbaga.d
if i stored it in any variable and try to print...
if i stored it in any variable and try to print that variable its giving 1 why?
Count1=$(awk -F"\t" '$3=="n/a"{print NR }' file_name.tsv)
Count_1=`echo $Count1 | awk -F, {'print NF'}`
751
Posted By Shenbaga.d
Help me to find the "n/a" record row no
Hi,

I need to find the "n/a" value presented row no. in my file i have following code but it gives all the row no. even i tried removing n/a by blank value and try to find the blank value it also...
2,114
Posted By Shenbaga.d
Yes, why becos in future any conditions needs to...
Yes, why becos in future any conditions needs to added means it will use.
2,114
Posted By Shenbaga.d
will this work for floating point also? and...
will this work for floating point also?

and if i want to add one more condition like col5 has < 79 then it have 0 values. and i need to print in separate col. like

input file.txt
...
2,114
Posted By Shenbaga.d
Help me to find a greater than or smaller than values
Hi,

i need to find one of the value from my file is in between two numbers, that is the value is greater than 34 and smaller than 50,

Ex: File.txt
col1 col2 col3 col4
1 Name1 93 w...
5,683
Posted By Shenbaga.d
Hi vgresh, ur code is working for on column if i...
Hi vgresh, ur code is working for on column if i add ine more then its replace "1" in that column,

Hi Rudic ur code is working fine ,

Both guys Thank you for helping me
5,683
Posted By Shenbaga.d
yes it present in 3d col only
yes it present in 3d col only
5,683
Posted By Shenbaga.d
HI, i tried to fild the NA values and still...
HI,

i tried to fild the NA values and still finding to replace the fist col1 values to NA

awk -F\\t '{ if (NR == 1) { for (i=1;i<=NF;i++){if ($i=="col3") { c=i } } };if (NR != 1) {if ($c ~...
5,683
Posted By Shenbaga.d
Find a blank field and replace values to NA
Hi All,

i have a file like
col1 col2 col3
13 24 NA
12 13 14
11 12 13
14 22 NA
18 26 NA

in this file if i found "NA" other values in the line are also replace by NA

Could you help me!
714
Posted By Shenbaga.d
What changes need to do in this awk
hi all,
following awk command is working perfect for three input files but if i need to increase the no. of input files and changed in the "[$2]/3" to how many files i'm adding, but its not working...
958
Posted By Shenbaga.d
Hi RudiC, when we do in putty or cmd prom....
Hi RudiC,

when we do in putty or cmd prom. its giving perfect ans. But if I want it in .tsv file its giving like this. Please try it.
958
Posted By Shenbaga.d
Why its printing like this?
Hi,
when i use the following awk i will get the output like double time printed values and the 2nd time only its giving data,
please help me to find this
for ex: awk code:
file_name=$1...
734
Posted By Shenbaga.d
Help Me! to find the the different
Hi,

here i have given the input files and output files, and awk command
awk 'FNR==NR {a[$1]=$4;next} $1 in a {if ($4==a[$1]) t=0; else {t=$4-a[$1]};print $0,t}' file1.tsv file2.tsv

i have to...
1,242
Posted By Shenbaga.d
Hi, here i have given the input files and...
Hi,

here i have given the input files and output files, and awk command
awk 'FNR==NR {a[$1]=$4;next} $1 in a {if ($4==a[$1]) t=0; else {t=$4-a[$1]};print $0,t}' file1.tsv file2.tsv

i have to...
1,242
Posted By Shenbaga.d
To find and compare the data
hi ,

from the awk command i'm getting the output where the 2nd column of both are match in row wise,
if it present in that same column some where else, I cannot get the correct output.
awk...
1,090
Posted By Shenbaga.d
Hi Raja, if i'm using the code which you...
Hi Raja,

if i'm using the code which you posted, i'm getting following result, the Result with the input.

39.2133 11 14150524 Sa 37.88
0 12 12311440 Sa 0
114.993 13 12441731 Sa 121.66...
1,090
Posted By Shenbaga.d
Hi pravin, the result is printing different...
Hi pravin,

the result is printing different the value is different,
that is not in the order as like in input, and it is printing in vertical line

---------- Post updated at 01:34 PM...
1,090
Posted By Shenbaga.d
Cannot get the correct ans. Using awk in taking average
Hi all,

I think so I’m getting the result is wrong, while using following awk commend,

colval=$(awk 'FNR>1 && NR==FNR{a[$2]=$4;next;} FNR>1 {a[$2]+=$4; print $2"\t"a[$2]/3}'
filename_f.tsv...
2,145
Posted By Shenbaga.d
Thanks Raja its working fine
Thanks Raja its working fine
Showing results 1 to 25 of 46

 
All times are GMT -4. The time now is 10:48 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy