I have two files. File1 contains all of the data I require to be processed, and I need to add another field to this data by matching a common field in File2 and appending a corresponding field to the data in File1 based on the match... So:
File 1:
I want to match the account_code field with the Org Code in File 2:
And then merge the matched Account Name(field 2) into the data in File1 without omitting any records in File1, so output data looks like this:
Any suggestions much appreciated..
Thanks,
Land
Last edited by Franklin52; 02-09-2012 at 04:17 AM..
Reason: Please use code tags for code and data samples, thank you
I have about 20 CSV's that all look like this:
"","","","","","","","","","","","","","","",""What I've been told I need to produce is the exact same thing, but with each file now containing the start_code from every other file where the email matches.
It doesn't matter if any of the other... (1 Reply)
Hi All,
I do have 2 files
file 1 has 4 tab delimited columns
234 a c dfgyu
294 b g fih
302 c h jzh
328 z c san
597 f g son
File 2 has 2 tab delimted columns
234 23
302 24
597 24
I want to merge file 2 with file 1 based on the data common in both files which is the first column so... (6 Replies)
Hi experts,
Would you please help me with this?
I have several files and I need to join the forth field of them based on the common first field.
here's an example...
first file:
280346 39.88 -75.08 547.8
280690 39.23 -74.83 538.7
280729 40.83 -75.08 499.2
280907 40.9 -74.4 507.8... (5 Replies)
I have a csv file that I need to extract some data from depending on another field after reading info from another text file.
The text file would say have 592560 in it.
The csv file may have some data like so
Field 1 Field2 Field3 Field4 Field5 Field6
20009756 1 ... (9 Replies)
I have two files in UNIX.
1st file is Entity and Second File is References. 1st File has only one column named Entity ID and 2nd file has two columns Entity ID | Person ID.
I want to produce a output file where entity id's are matching in both the files.
Entity File
624197
624252
624264... (4 Replies)
Please help me to find out maximum value of a field based on grouping of other fields, as we do in SQL.
Like in SQL if we are having below records :
Client_Name Associate_Name Date1 Value
C1111 A1111 2012-01-17 10
C1111 A1111 ... (1 Reply)
Dear List,
I have a file of csv data which has a different line per compliance check per host. I do not want any omissions from this csv data file which looks like this:
date,hostname,status,color,check
02-03-2012,COMP1,FAIL,Yellow,auth_pass_change... (3 Replies)
Is there a way to read in a two-columned CSV file, and based on the fields in 1st column, output many different files? The input/output looks something like:
input.csv:
call Call Mom.
call Call T-Mobile.
go Go home.
go Go to school.
go Go to gas station.
play Play music.
play Play... (4 Replies)
Hi experts,
I have a csv file which has one field (ID) repeated multiple times with corresponding other field values.
I need to convert this file in a format where for a ID all other values has to be present in single field.
For Eg : Here in below file ID 1 is repeated 3 times with different... (7 Replies)
In the awk below I am trying to print the entire line, along with the header row, if $2 is SNV or MNV or INDEL. If that condition is met or is true, and $3 is less than or equal to 0.05, then in $7 the sub pattern :GMAF= is found and the value after the = sign is checked. If that value is less than... (0 Replies)
Discussion started by: cmccabe
0 Replies
LEARN ABOUT DEBIAN
cfourcc
cfourcc(1) User Commands cfourcc(1)NAME
cfourcc - tool for changing FourCC in Microsoft RIFF AVI files
SYNOPSIS
cfourcc [-i] <file.avi>
cfourcc -u <CODE> <file.avi>
OPTIONS -h Show summary of options.
-d CODE
Sets FOURCC codec decription string.
-f Force changing FOURCC on unsupported file
-i Display FOURCC information (default).
-u CODE
Set FOURCC codec.
None.
DESCRIPTION
Program identifies the codec used in AVI files (*.avi) and allows the user to change the FourCC description code (like fourcc-changer in
Windows). Useful for people working with Microsoft AVI file. A Linux clone of AviC fourcc changer tool.
EXAMPLES
Note that you only need to change the -u codec field most of the time and not touch the -d description:
cfourcc -u DIVX -d DIVX file.avi
ENVIRONMENT
None.
FILES
None.
SEE ALSO ffmpeg(1)mplayer(1)AUTHORS
cfourcc was written by Mohammad Hafiz bin Ismail aka "mypapit" <info@mypapit.net>.
This manual page was written by Jarno Elonen <elonen@debian.org>, for the Debian project (but may be used by others). Updated by Jari Aalto
<jari.aalto@cante.net>. Released under license GNU GPL v2 or (at your option) any later version. For more information about license, visit
<http://www.gnu.org/copyleft/gpl.html>.
cfourcc 2012-04-02 cfourcc(1)