08-23-2016
My crystal bowl is somewhat hazy today - you could help by sending some polish. Or - surprise! - by posting all three input files.
And yes - I forwent the test on supplier equality for simplicity of code at the expense of some CPU cycles. Should your manufacturer file become tremdously large, you may add the test into the script.
10 More Discussions You Might Find Interesting
1. UNIX for Advanced & Expert Users
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
, ,... (3 Replies)
Discussion started by: chachabronson
3 Replies
2. UNIX for Dummies Questions & Answers
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 ---
... (1 Reply)
Discussion started by: Sebben
1 Replies
3. Shell Programming and Scripting
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 Replies)
Discussion started by: phil_heath
4 Replies
4. UNIX for Dummies Questions & Answers
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
... (3 Replies)
Discussion started by: jdr0317
3 Replies
5. Shell Programming and Scripting
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... (18 Replies)
Discussion started by: vivek_damodaran
18 Replies
6. Shell Programming and Scripting
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 (4 Replies)
Discussion started by: seqbiologist
4 Replies
7. Shell Programming and Scripting
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.... (10 Replies)
Discussion started by: sukhdip
10 Replies
8. Shell Programming and Scripting
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 (8 Replies)
Discussion started by: ida1215
8 Replies
9. UNIX for Dummies Questions & Answers
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,... (6 Replies)
Discussion started by: A-V
6 Replies
10. UNIX for Beginners Questions & Answers
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... (16 Replies)
Discussion started by: Hope
16 Replies
crystal(6x) XScreenSaver manual crystal(6x)
NAME
crystal - kaleidescope.
SYNOPSIS
crystal [-display host:display.screen] [-visual visual] [-window] [-root] [-grid] [-no-cell] [-centre] [-nx number] [-ny number] [-count
number] [-delay number] [-ncolors number] [-fps]
DESCRIPTION
Moving polygons, similar to a kaleidescope (more like a kaleidescope than the hack called `kaleid,' actually.)
OPTIONS
-visual visual
Specify which visual to use. Legal values are the name of a visual class, or the id number (decimal or hex) of a specific visual.
-window Draw on a newly-created window. This is the default.
-root Draw on the root window.
-grid | -no-grid
Whether to draw grid.
-cell | -no-cell
Whether to draw the cell.
-centre | -no-centre
Whether to center on screen
-nx number
Horizontal Symmetries. -10 - 10. Default: -3.
-ny number
Vertical Symmetries. -10 - 10. Default: -3.
-count number
Count. -5000 - 5000. Default: -500.
-delay number
Per-frame delay, in microseconds. Default: 60000 (0.06 seconds.).
-ncolors number
Number of Colors. Default: 100.
-fps Display the current frame rate and CPU load.
ENVIRONMENT
DISPLAY to get the default host and display number.
XENVIRONMENT
to get the name of a resource file that overrides the global resources stored in the RESOURCE_MANAGER property.
SEE ALSO
X(1), xscreensaver(1)
COPYRIGHT
Copyright (C) 2002 by Jouk Jansen. Permission to use, copy, modify, distribute, and sell this software and its documentation for any pur-
pose is hereby granted without fee, provided that the above copyright notice appear in all copies and that both that copyright notice and
this permission notice appear in supporting documentation. No representations are made about the suitability of this software for any pur-
pose. It is provided "as is" without express or implied warranty.
AUTHOR
Jouk Jansen.
X Version 11 5.15 (28-Sep-2011) crystal(6x)