Extract data according to keys from filename mentioned in file
Hello experts, I want to join a file with files whosE names are mentioned in one of the columns of the same file.
File 1
file number 1
file number 2
file number 3
I want to read each line of File, make a key of cols 2 and 3, and then extract data for the key from the filename mentioned in the 4th column. The filenames have spaces as I have shown. Also I want the headers in the output.
out_t1
out_t2
out_t3
This is what I want to do:-
Not sure how to take out the 4th column and 1st column from first file, also to extract the header.
Please assist.
Last edited by Scrutinizer; 03-03-2015 at 03:23 PM..
Reason: Changed unclear code tags to one set of code tags per sample file
Following is input:
<P
align="justify"
><FONT size="+1" color="#221E1F">the tiny bundles of hairs that protrude from them. Waves in the fluid of the inner ear stimulate the hair cells. Like the rods and cones in the eye, the hair cells convert this physical stimulation into neural im<FONT... (2 Replies)
I am trying to find a way to create a script which will extract the first line of a file and then rename the file (or create a new file with the same content as the old file) using the first line as the name. The first line being a single word, that is. I am hopeless at programming, if anyone can... (5 Replies)
Hi, i have a filename CRED20102009.txt in a server
20102009 is the date of the file ddmmaaaa format
the complete route is
/dprod/informatica/Fuentes/CRED20102009.csv
i want to extract the date to create a new file named Parameters.txt
I need to create Parameters.txt with this... (6 Replies)
I have 2 text files where I need to parse data from file 2 using the data from file 1. Below are my sample files
File 1 (tab delimited)
257 350
670 845
725 1025
767 820
...
....
....
file 2 (tab delimited)
220..450 TA AB650 ABCED
520..850 GA AB720 ABCDE
700..1100 TC AB820 ABCDE... (2 Replies)
Hi,
Here is my question: suppose I have files like
1990_8xdaily_atmos.nc
1991_8xdaily_atmos.nc
1992_8xdaily_atmos.nc
1993_8xdaily_atmos.nc
1990_daily_atmos.nc
1991_daily_atmos.nc
1992_daily_atmos.nc
1993_daily_atmos.nc
1990_month_atmos.nc
1991_month_atmos.nc
1992_month_atmos.nc... (1 Reply)
Hi All,
Thanks in Advance
I am working on a shell script. I need some assistance.
My Requirement:
1) There are some set of files in a directory like given below
OTP_UFSC_20120530000000_acc.csv
OTP_UFSC_20120530000000_faf.csv
OTP_UFSC_20120530000000_prom.csv... (0 Replies)
Hi,
I have some files with these patterns:
WI_SCOPE_DATA_CHANGE_2017-09-12_15-30-40.txt
WI_SCOPE_BACK_COMPLETE_QUEUE_2017-09-12_15-31-40.txt
WI_SCOPE_CURRENT_CHECK_QUEUE_2017-09-12_15-32-40.txt
WI_SCOPE_DAILY_PARTY_2017-09-12_15-33-40.txt
I want to extract date from filename and save it... (1 Reply)
Hi,
I want to extract part of filename, for eg:
File="010020004_S-TOR-Sort-CASAP_20170519_121504_0007.TXT"
here i need first 5 words of file i.e.
FilePart="$(echo "${File%"${File#******}"}")"
Echo $FilePart
010020004_S-TOR-Sort-CASAP
But what if i get filename like below:
... (3 Replies)