Search Results

How to calculate percentage non zero value occurrence base on value col 1 and 2
2017 a 0
2017 a 2
2017 a 4
2017 a 2
2017 a 0
2017 b 2
2017 b 6
2016 a 2
2016 a 2
2016 b 2
2016 b 8
2016 b...

Thanks, that much cleaner.
ow=$(date +"%s")
echo "NOW = ${now}";
file=$(ls -1r *.txt|head -1)
echo "file name is $file"
#filename 201710030549.txt
echo ${file:0:8}
fdate=$(date -d ${file:0:8}...

not awk solution but simple shell approach
#!/bin/bash
read -p "Enter the name : " name
echo "Hi, $name"
command=`curl -v -H 'Authorization: WS 00eWxhTuhoHMBcA' -H 'Accept: application/json' ...

I'm trying to calculate datediff between string from filename and current date,
i got problem with storing variable from date command

now=$(date +"%s")
echo "NOW = ${now}";
file=$(ls -1Ap...

i have simple program that generate log file 1 line every sec, i need to do grep for specific record then redirect to another file.

#!/bin/bash
for i in `seq 1 20`;
do
...

i have some set of date data inside csv files and need to convert the timezone,

08302016113611861
08302016113623442
08302016113541570
08302016113557732
08302016113548439
08302016112853115...

Work perfect, many thanks
root@svr:/var/tmp# more sample.txt
151442
15144200113571
190370299
2010
212526
212527
212529
212533
212534
212538
212546
212547

root@svr:/var/tmp# awk...

many thanks Pravin,

Is it possible to print 179 as single line,

171 176
179
182 183
187 189
1900 1901
1903 1907

Work perfect, and good finding for my mistake many thanks

I have 100k data like this bellow , i want to group data to range

171
172
173
174
175
176
179
182
183
187
188
189
1900
1901
1903
1904
1905
1906

Working perfect .. Many thanks

Sample input
19:08:12.172; Cat1 74598; Cat2 1366; Cat3 227; Cat4 389; Cat5 572; Cat6 2228; Cat7 1039; Cat8 25;
19:08:22.173; Cat1 75589; Cat2 1388; Cat3 233; Cat4 393; Cat5 582; Cat6 2253; Cat7...

thanks it's working well and also very fast. never think it's can be done by single line awk. i want to know also how to calculate the number of record base on value on column 1 and 2 , so the data...

i have some giga texts data, samples data below


803,7282012,343
703,7282013,0
600,7282012,0
600,7282012,0
600,7282012,0
600,7282012,0
803,7282012,277
600,7282012,0
403,7282012,0...

How to convert decimal value to hex and than take 1st digits as variable
sample data

84844294,5,6
51291736,2,3
84844294,5,6
51291736,2,3


i can use {printf "%x,%d\n",$1,$2} but than i...

a. i mean file scanning will be done in hourly basis ( the cron job )
b. i am not sure with the standard format .. just guessing
-2 digit day 2 digit month 4 digit year 2 digit hour 2 digit...

Did you get your reverse tunnel working? Can your share any error during execute last command?

I want to listed files every hours and check the missing sequence

my file format is

CV.020220131430.txt
CV.020220131440.txt
CV.020220131450.txt

CV.ddmmyyhhm.txt


how to check if i...

lftp give very good solution for this case , but i still have some issue with lftp

I want to download only the files that newer than latest local files( last downloaded from previous task) ,...

I have an application that collect data from 10 server every minutes and stored to mysql db,. there are about 10K record from each server on every minutes. that data will need to stored in 1 month....

I have system that generate files every 1 hours , i only have ftp connection from my local server to remote .


$ ls -al
-rw-r--r-- 1 water None 0 Feb 7 18:09 a.0800
-rw-r--r-- 1 water None 0...

[root@localhost ~]# cat t.txt
2,3,4,5,A,2012-01-01 00:00:28
2,6,4,5,A,2012-01-02 00:00:28
2,7,4,5,A,2012-01-02 02:00:28


[root@localhost ~]# awk -F"," '{OFS=",";print $2,"";printf("%s",...

I have directory that has some billion file inside , i tried copy some files for specific date but it's always did not respond for long time and did not give any result.. i tried everything with...

Thank you.. but i can got the wrong output and also did not work for Name field more than 1 word( ie. Andi ruby) and when the field has empty value
$ awk -V | head -1
GNU Awk 4.0.0

$ cat...

thank you can not imagine if we can use regex as field separator,

sometimes the script is not working i check there is special character for each record set...