Search Results

You passed variable successfully, try like this

awk -v var1="abc123" '$0 ~ var1{x=NR+1}(NR<=x){print}' sftp_log_20150317.log

awk -F"," ' ! $1 ' file

Or

sed -n "/^ *,/p" file

Did you try perl script I had given ?

can you post the output of od -c f2

I receive this o/p, run dos2unix before inputing files
[akshay@nio tmp]$ awk 'FNR==NR{a[$1];next}!($3+0 in a)' f1 FS=',' f2
2,2,333


---------- Post updated at 03:59 PM ---------- Previous...

It can be simplified by just adding zero, no need of match and gsub

[akshay@nio tmp]$ cat f1
1
2
3

[akshay@nio tmp]$ cat f2
a,0001
b,02
c,000
d,01
e,2
f,0005

[akshay@nio tmp]$ awk...

Hi vegasluxor,

Following may help in same.


awk -F, 'FNR==NR{A[$1]=$1;next} {match($2,/.*0[1-9]/);V=$2;gsub(/0/,X,V);gsub(/^$/,0,V);} !(V in A) {print $0}' file1 file2


Output will be...

Not sure if it will make much of a difference, but something like this:
find . -type f -name '*.txt' -exec grep -F 99023 {} + > myresult.text

You can use grep -Fh is you want to omit the file...

-F "," - use comma as the field separator
$4 != "CAR" {$4 = "BIKE"} - if field 4 is not 'CAR' then set field 4 to BIKE (note that this will replace anything that isn't CAR, not just empty ones)
...

Hello,

Following may also help in same.


awk 'NR==3 || NR==4 {$(NF+1)="BIKE"} 1' OFS="," file_name


Output will be as follows.


1,abc,55,CAR
3,bb,dd,CAR
5,ddd,tttt,BIKE...

OR

$ awk -F , '!$4{$4="BIKE"}1' OFS="," file

1,abc,55,CAR
3,bb,dd,CAR
5,ddd,tttt,BIKE
8,ee,55,BIKE

awk -F "," '$4 != "CAR" {$4 = "BIKE"}1' OFS="," file

This may be even better, as it makes the leading comma check compulsory for both fields:grep -E "^(.*,){2}.*, *[0+]{,2}91" file

awk -F, -v c=001 'substr($5,0,3)==c' file

This will print the line if the first three numbers of the 5th field are 001.

Why not using awk ?

$ cat tst2
Date, time, , number 1, number 2, counter...
20130618,912154, ,009912345678,911111111111,10000, , ,abc
20130618,912154, ,009912345678,921111111111,10000, , ,abc...

You could try with the expression similar to this:-grep "^[0-9]*,[0-9]*, ,009[19] inputfile
I think that this translates as:-
^ - from start of line
[0-9] - the digits
* - repeated as many...

Why not use awk???
awk is a good tool for this job. Here is another version.
echo a,b,c,d,e,f,g,h,i | awk 'NR>5 && $1~/f/ {print "yes"}' RS=,
yes
This prints yes if an f is found after 5th ,

Not sure if this is the best way to do it, but it works:
egrep '.*?,.*?,.*?,.*?,.*?,.*f' file

Edit: This is a better way to approach it:
grep '^\([^,]*,\)\{5\}\(.*f\)' file

This will print the line if the letter "f" is in field 6 or more:
echo a,b,c,d,e,f,g,h,i | awk -F, '{ p=0; for (i=6; i<=NF; i++) { if ($i ~ /f/) p=1 } } p'

ts=$1

awk -F, -v T="$ts" 'NR > 1 && T >= $1 && T <= $2' abc.csv

This should come close, but the 1st line in the 2nd file will be split into fields using the wrong value for FS (since field splitting will be done before FS is reset). Assuming that there could be...

How is your SSH authenticating now ? Password or keys ?

If your ssh is configured for password authentication only, I dont think you have to regenerate any keys. Just login with the new password.

If file transfer had a "go faster" button everyone would be pushing it already...

The return code of sftp arrives in $? like any other command. But this won't tell you which file messed up. I'm...

In field 2, match 6 if it is at the beginning (^'$x') or if it is in the middle (,'$x',) or if it is in the end ('$x'$), and print corresponding $1.

Note: Here, $x is interpreted by shell and the...

root# x=6; awk '$2 ~ /^'$x',|,'$x',|,'$x'$/ {print $1}' file

PLEASE use code tags as demanded!
I expect your specification to change again, for the 4th time, e.g. to accomodate for fields in double quotes as normally used in .csv files. And, how and why did...