Search Results

Search: Posts Made By: radius
1,084
Posted By radius
Data Pivot
Good Day,

I have file input
6285296582710|20170509|INDOTEL
6285296835209|20170509|INDOTEL
6285296940311|20170509|INDOTEL
6285297027737|20170509|MULTIFLAG
6285297027737|20170509|DELTA...
876
Posted By radius
thanks, it works sir
thanks, it works sir
876
Posted By radius
Print Based on File Name
Morning,

I have an issue to print files based on file name
my input file
20170516_WATERSONGS.txt
20170509_MULTIFLAG.txt

every file consist of list of number, for ex 20170516_WATERSONGS.txt...
4,718
Posted By radius
Print Based on File Name
Morning,

I have an issue to print files based on file name
my input file
20170516_WATERSONGS.txt
20170509_MULTIFLAG.txt

every file consist of list of number, for ex 20170516_WATERSONGS.txt...
624
Posted By radius
Add New Column Based on Files Name
Dear Sir,

I need to add new column (last column) based on files name.

my files name
20170809_target_tdc_pmx4.xls
20170809_target_tdc_pmx5.xls
20170809_target_tdc_pmx6.xls

for example file...
1,185
Posted By radius
it works, thanks for the explanation...
it works, thanks for the explanation :b::b::b::b::b:
1,185
Posted By radius
Transpose the data
Hi All,

I have sort of a case to transpose data from rows to column
input data

Afghanistan|10000|1
Albania|25000|4
Algeria|25000|7
Andorra|10000|4
Angola|25000|47
Antigua and...
2,434
Posted By radius
Join file with awk
I have a problem of joining 2 files with different position of key column

file1
INDIA|LEFT|123
USA|RIGHT|345
CHINA|LEFT|234

file2
123|HIGH
345|LOW

expected output
INDIA|LEFT|123|HIGH...
1,573
Posted By radius
Compare with 2 tables
I have 3 file inputs,

file1
20160302|5485368299953|96|510101223440252|USA|5485368299953|6|800|2300|0
20160530|5481379883742|7|510101242850814|USA|5481379883742|5|540|2181|1500...
1,423
Posted By radius
Cross Tab
I need help to do cross tab

file input
20160101|ASIA|CHINA|2000
20160101|ASIA|INDIA|3000
20160102|ASIA|CHINA|4000
20160103|ASIA|CHINA|2000
20160103|AFRIKA|ZAMBIA|2000...
25,446
Posted By radius
huge thanks Sir Don, its solved
huge thanks Sir Don, its solved
25,446
Posted By radius
How to Connect to Teradata and Run in Shell Script?
Hi Master,

I need to create dan run script in linux to get data from teradata

I did this

---------- Post updated at 02:28 AM ---------- Previous update was at 02:25 AM ----------
...
1,129
Posted By radius
Add number of occurence
Good morning, I need help to add number of occurence based on column 1 & column 5

file input
81161267334|1|100000|81329998077|20150902
81161267334|1|50000|82236060161|20150902...
1,256
Posted By radius
i did this awk -F'|' '{print $1"|"$2}'...
i did this

awk -F'|' '{print $1"|"$2}' input.txt | sort -k2,2nr | awk -F'|' '!a[$1]++'
but the selection was failed
1,256
Posted By radius
Remove lines
I need to remove rows with the last update date (column 2nd) but when it equals (column1 & column 2) , just remove one of them

input.txt

6281271467892|2015-01-07
5555571618533|2015-01-01...
1,932
Posted By radius
big thanks mr ravinder..it helps
big thanks mr ravinder..it helps
1,932
Posted By radius
can you explain the code mr ravinder? I really...
can you explain the code mr ravinder? I really appreciate it
1,932
Posted By radius
if I modify my file f1 ...
if I modify my file
f1

531902021342|610231416030043|FEMALE
531902021421|610231415853764|FEMALE
531902021460|610231406819593|FEMALE
531902021477|610230000021377|FEMALE...
1,932
Posted By radius
Join with awk
I have file 1 (f1)
531902021342|610231416030043
531902021421|610231415853764
531902021460|610231406819593
531902021477|610231410151075
531902021481|610230208405255
531902021484|0...
2,958
Posted By radius
Print vertical to horizontal
Hi Masters,
I need help to change my vertical data to horisontal

input
2015-04-13|JS|741667
2015-04-13|JSJ|2272
2015-04-13|TMS|107099
2015-04-12|JMD|47945
2015-04-13|TM|760024...
1,463
Posted By radius
may you explain the code mr Scrutinizer?
may you explain the code mr Scrutinizer?
1,463
Posted By radius
Join with awk different column
hi guys,

i need help

I need to join file2 to file1 when column 3 in my file1 and column 1 in my file2 in the same string

file1
AA|RR|ESKIM
RE|DD|RED
WE|WW|SUPSS

file2
ESKIM|ES...
1,196
Posted By radius
thanks Mr Walter by the way I tried to count...
thanks Mr Walter

by the way I tried to count total days of month two days ago
total_days=`cal | awk 'FNR>2{d+=NF}END{print d}'

since two days ago is still March, so total_days = 30 not 31
...
1,196
Posted By radius
Select last update data based on file name
Hi All,

I need to remove all files except the most update data based on date on filename

Input
data_AIDS_20150312.txt
data_AIDS_20150311.txt
data_AIDS_20150411.txt
data_AIDS_20140312.txt
...
879
Posted By radius
what does this mean {h[$1]=1 and h[$1]+0}? any...
what does this mean {h[$1]=1 and h[$1]+0}?
any way, big thanks
Showing results 1 to 25 of 139

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