11-04-2016
I'm guessing that you might have common column headings somewhere that you want to merge in, but in that case, what rule would you want to apply:-
- file1 always?
- file2 always?
- file2 if value is bigger/smaller?
- value only if matched?
- the sequence for records to be added?
- anything else?
Is this something that could be covered with the
paste command perhaps? You might need to prefix your file2 data with
,, to make the column counts match, perhaps with
sed -i '2,$ s/^/,,/' file2 or some variation?
Does that help? It still doesn't get over the question of matching columns either and might not do what you want at all. It would help if we had more test data and the various options explained.
Kind regards,
Robin
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Can anyone help me how to include COLUMN HEADER when spooling file to .CSV format through SQL statement.
Thanks,
Akbar (4 Replies)
Discussion started by: s1a2m3
4 Replies
2. Shell Programming and Scripting
Hi All
I am trying to combine columns from multiple text files into a single file using paste command but the record length being unequal in the different files the data is running over to the closest empty cell on the left. Please see below.
What can i do to resolve this ?
File 1 File... (15 Replies)
Discussion started by: venky_ibm
15 Replies
3. Shell Programming and Scripting
Hi all,
I am pretty new at this so be gentle. Also, if there is any chance you could explain what the code you use is actually doing, that would really help me out, Im learning after all :)
So I am trying to convert a selected column of numbers from input file1 into a row in output file2
... (3 Replies)
Discussion started by: StudentServitor
3 Replies
4. Shell Programming and Scripting
Hello All,
I have several column files like this
$cat a_b_s1.xls
1wert
2tg
3asd
4asdf
5asdf
$cat c_d_s2.xls
1wert
2tg
3asd
4asdf
5asdf
desired put put
$cat combined.txt
s1 s2 (2 Replies)
Discussion started by: avatar_007
2 Replies
5. Shell Programming and Scripting
Hi All,
The below sar -u command generates multiple column headers in csv file
Expected output should print column headers only once in the csv file
shell script:
$cat sar_cpu_EBS.sh
#!/bin/bash
while ; do
sar -u 15 1 | awk '/^/ {print $1,$2,$4,$6,$7}' | tr -s ' ' ',' >>... (6 Replies)
Discussion started by: a1_win
6 Replies
6. Shell Programming and Scripting
Hello,
I have a spec file that contains a lot of strings that looks like this:
PC DELL OptiPlex 3010MT i3 3220/2GB/500GB/DVD-RW/FREE DOS / 5Y NBD
Intel i3 3220 (Dual Core, 3.30GHz, 3MB, w/ HD2500 Graphics), 2GB (1x2GB) DDR3 PC3-1600MHz, 500GB HDD SATA III 7200rpm, DVD+/-RW (16x),... (9 Replies)
Discussion started by: g9100
9 Replies
7. Shell Programming and Scripting
Hi,
I have two text files with approximately 6000 rows each. I wish the bind these two files into a single column in a new text file like this:
File 1:
EQTN
AFAF
SPACA8
equatorin
...
File 2:
DA3
DA5
FAM38B2
HsT748
... (2 Replies)
Discussion started by: bronzyroo
2 Replies
8. UNIX for Beginners Questions & Answers
This is a question that is related to one I had last August when I was trying to sort/merge two files by millsecond time column (in this case column 6).
The script (below) that helped me last august by RudiC solved the puzzle of sorting/merging two files by time, except it gets lost when the... (0 Replies)
Discussion started by: aachave1
0 Replies
9. UNIX for Beginners Questions & Answers
Dear UNIX experts,
I'm a command line novice working on a Macintosh computer (Bash shell) and have neither found advice that is pertinent to my problem on the internet nor in this forum.
I have hundreds of .csv files in a directory. Now I would like to copy the subset of files that contains... (8 Replies)
Discussion started by: rcsapo
8 Replies
10. UNIX for Beginners Questions & Answers
file1:
Name,Threshold,Curr Samples,Curr Error%,Curr ART
GETHome,100,21601,0.00%,47
GETregistry,100,21592,0.00%,13
GEThomeLayout,100,30466,0.00%,17
file2:
Name,Threshold,Curr Samples,Curr Error%,Curr ART
GETHome,100,21601,0.00%,33
GETregistry,100,21592,0.00%,22... (6 Replies)
Discussion started by: Raghuram717
6 Replies
LEARN ABOUT DEBIAN
rdswap
RDSWAP(1) General Commands Manual RDSWAP(1)
["NAME"]
rdswap - a multi-language RD documents support tool
["SYNOPSIS"]
rdswap [ -h | -v ] filename ...
["DESCRIPTION"]
This tool is written to support you to write multi-language documents using the Ruby-Document-Format (RD).
The idea for such a tool was originated by Minero Aoki, how has thought about, how to make life easier for developers who have to write and
maintain scripts in more than one language.
You have to specify at least two filenames on the command line. One containing the Ruby script, the second containing a translated RD. If
the script does not end with `.rb', it has to be the first filename mentioned on the command line! In opposition, all files containing
translations must not ending with `.rb'! They should use a extension that describes the language. So that would give us the following pic-
ture:
o sample.rb : Script contains the original documentation.
o sample.jp : Documentation written in Japanese.
o sample.de : Translation to German.
The tool doesn't care about the language extensions. You can name them as you like! So the file containing the Japanese translation above,
could also be names e.g. `sample.japan' or even `japantranslation.japan'.
For every translation file, a new file will be created. The name is build from the script filename plus the language extension. So regard-
ing the example above, following files would be created:
o sample.rb.jp
o sample.rb.de
or, given the alternative translation filename as mentioned above...
o sample.rb.japan
["How does it work?"]
The contents of all files will be split into source and RD blocks. The source of the translation files, will be discarded! Every RD block
may be of a certain type. The type will be taken from the contents directly following the `=begin' on the same line. If there is only a
lonely `=begin' on a line by itself, the type of the block is `nil'. That means in
# File sample.rd
:
=begin
bla bla
=end
:
=begin whatever or not
blub blub
=end
:
the first block would be of type `nil' and the second one of type `whatever or not'.
Block types are important for the translation. If a source will be generated from a script and a translation file, only these blocks are
taken from the translation files, that comes in the right sequence and contains the same type as the block in the script! For example:
# File sample.rb
:
=begin gnark
Some comment
=end
:
=begin
block 2
=end
:
=begin
block 3
=end
:
# File sample.de
:
=begin
Block zwei
=end
:
=begin
Block drei
=end
:
Here, the first block of `sample.rb' will *not* be translated, as there is no translation block with that type in sample.de! So the first
block would be inserted as-it-is into the translated script. The blocks afterwards, however, are translated as the block type does match
(it is `nil' there).
Attention: In a translation file, a second block will only be used, if a first one was already used (matched). A third block will only be
used, if a second one was used already!
That means, if the first block of `sample.de' would be of type e.g. `Never match', then no block would ever be taken to replace anyone of
`sample.rb'.
["OPTIONS"]
["-h"]
shows this help text.
["-v"]
shows some more text during processing.
["filename"]
means a file, that contains RD and/or Ruby code.
["EXAMPLES"]
rdswap -v sample.rb sample.ja sample.de
rdswap -v sample.ja sample.rb sample.de
rdswap -v sample.ja sample.de sample.rb
rdswap -v sample.??
["AUTHORS"]
Clemens Hintze <c.hintze@gmx.net>.
June 2012 RDSWAP(1)