CSV joining and checking multiple files Post: 302979953

10 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

Joining 2 CSV files together

I need a little help as I am a complete novice at scripting in unix. However, i am posed with an issue... i have two csv files in the following format@ FILE1.CSV: HEADER HEADER Header , , HEADER 001X ,,200 002X ,,300 003X ,,300 004X ,,300 FILE2.CSV: HEADER HEADER Header , ,...

2. UNIX for Dummies Questions & Answers

Joining files based on multiple keys

I need a script (perl or awk..anything is fine) to join 3 files based on three key columns. The no of non-key columns can vary in each file. The columns are delimited by semicolon. For example, File1 Dim1;Dim2;Dim3;Fact1;Fact2;Fact3;Fact4;Fact5 ---- data delimited by semicolon --- ...

3. Shell Programming and Scripting

joining multiple files into one while putting the filename in the file

Hello, I know how to join multiple files using the cat function. I want to do something a little more advanced. Basically I want to put the filename in the first column... One thing to note is that the file is tab delimited. e.g. file1.txt joe 1 4 5 6 7 3 manny 2 3 4 5 6 7 ...

4. UNIX for Dummies Questions & Answers

Joining string on multiple files

Hi guys, I am a forum (and a bit of a unix) newbie, and I currently have a tricky problem lying ahead of me. I have multiple files, and I am looking to join the files on the first column. Example: File 1 andy b 100 amy c 200 amy d 300 File 2 andy c 200 amy c 100 clyde o 50 ...

5. Shell Programming and Scripting

Checking the existance of multiple files

I am trying to execute the following command to check the existance of a file (which has a date timestamp on it). If there are more than one file, then also it should give me 'success' result. if then <do some work> else <no files> fi Since there are more than one...

6. Shell Programming and Scripting

Joining multiple files based on one column with different and similar values (shell or perl)

Hi, I have nine files looking similar to file1 & file2 below. File1: 1 ABCA1 1 ABCC8 1 ABR:N 1 ACACB 1 ACAP2 1 ACOT1 1 ACSBG 1 ACTR1 1 ACTRT 1 ADAMT 1 AEN:N 1 AKAP1File2: 1 A4GAL 1 ACTBL 1 ACTL7

7. Shell Programming and Scripting

checking csv files with empty fields..!

Hi! I need to learn that how a shell script can transverse a csv file n check if any field is empty or not. means its contains two comma or space b/w commas i.e., "" or " ". can anyone help me out how I can do that....

8. Shell Programming and Scripting

Other alternative for joining together columns from multiple files

Hi again, I have monthly one-column files of roughly around 10 years. Is there a more efficient way to concatenate these files column-wise other than using paste command? For instance: file1.txt 12 13 15 12 file2.txt 14 15 18 19 file3.txt 20 21

9. UNIX for Dummies Questions & Answers

Joining different columns from multiple files

Hello again, I am trying to join 3rd column of 3 files into the end on one file and save it separately... my data looks like this file 1 Bob, Green, 80 Mark, Brown, 70 Tina, Smith, 60 file 2 Bob, Green, 70 Mark, Brown, 60 Tina, Smith, 50 file 3 Bob, Green, 50 Mark, Brown,60 Tina,...

10. UNIX for Beginners Questions & Answers

Export Oracle multiple tables to multiple csv files using UNIX shell scripting

Hello All, just wanted to export multiple tables from oracle sql using unix shell script to csv file and the below code is exporting only the first table. Can you please suggest why? or any better idea? export FILE="/abc/autom/file/geo_JOB.csv" Export= `sqlplus -s dev01/password@dEV3...

LEARN ABOUT DEBIAN

dmtxquery

DMTXREAD(1)						      General Commands Manual						       DMTXREAD(1)

NAME

       dmtxquery - extract information from dmtxread output

SYNOPSIS

       dmtxquery PROPERTY [OPTION]... [FILE]...

DESCRIPTION

       dmtxquery extracts information from the XML output from dmtxread for individual or grouped barcode scan results.

PROPERTY

       barcode.count		 count of all barcodes found in image

       barcode.N.BPROP		 print BPROP property of Nth barcode

       message.count		 count of all messages found in image

       message.N.MPROP		 print MPROP property of Nth message

       message.N.barcode.count	 count of all barcodes in Nth message

       message.N.barcode.M	 Mth barcode of Nth message, print all

       message.N.barcode.M.BPROP Mth barcode of Nth message, print BPROP

       BPROP barcode properties:
	  message	 message_number      message_position
	  matrix_size	 data_codewords      error_codewords
	  rotation	 data_regions_count  interleaved_blocks

       MPROP message properties:
	  message	 data_codeword	     error_codeword

OPTIONS

       -V, --version
	      Print program version information.

       --help Display this help message and quit.

STANDARDS

       ISO/IEC 16022:2000

       ANSI/AIM BC11 ISS

BUGS

       Email bug reports to mike@dragonflylogic.com

AUTHOR

       Copyright (C) 2008, 2009 Mike Laughton

								 September 4, 2009						       DMTXREAD(1)

10 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

Joining 2 CSV files together

Discussion started by: chachabronson

2. UNIX for Dummies Questions & Answers

Joining files based on multiple keys

Discussion started by: Sebben

3. Shell Programming and Scripting

joining multiple files into one while putting the filename in the file

Discussion started by: phil_heath

4. UNIX for Dummies Questions & Answers

Joining string on multiple files

Discussion started by: jdr0317