Combining your original script with k_manimuthu's solution you might end up with something like this:
Code:
#!/bin/ksh
set -A allHosts $(ls -1 *.out | awk -F\. '{print $1}' | sort -u | uniq)
echo "host,accounts,max,pwd,standard"
for h in ${allHosts[@]}; do
OLDIFS="$IFS"
IFS="
" # Actual newline in quotes
set -A F1 `cat ${h}.account.out`
set -A F2 `cat ${h}.max.out`
set -A F3 `cat ${h}.pwd.out`
set -A F4 `sed -e 's/^ *//' -e 's/ */ /' ${h}.standard.out`
IFS="$OLDIFS"
i=0
# get maximum number of lines from the above files and iterate here
while [ $i -lt ${#F4[@]} ]
do
echo "$h",${F1[$i]},${F2[$i]},${F3[$i]},${F4[$i]}
let i=i+1
h="" # Blank host for 2nd and subsequent lines
done
done
Chubler_XL,
Thank you for taking the time to reply. Think I may have kludged something together like this? Eh, I have a lot of temp files floating about at the moment! Ok, way too many temp files floating about as I tried out diff trains of thought. But not as neat as your solution.
Quote:
Originally Posted by RudiC
OK, multiple hostn files. Try
Code:
for FN in *.out
do H=${FN%%.*}
if [ ! "$H" = "$OH" ]
then OH=$H
{
echo "host,accounts,max,pwd,standard"
echo $H | paste -d, - $H*.out | sed 's/, \+/,/'
} > $H.result
fi
done
RudiC,
Could you please break it down for me what is going on here:
Code:
for FN in *.out
do H=${FN%%.*}
if [ ! "$H" = "$OH" ]
then OH=$H
I sorta understand it, Assign H to FN and strip off everything until the .out ?
And I'm sorry, my mind is failing at the if statement there. Trying to pick up what I can
Thank you.
I've got two large csv text table files with different number of columns each.
I have to compare them based on first two columns and create resulting file
that would in case of matched first two columns include all values from first one and all values (except first two colums) from second one. I... (5 Replies)
Hi,
I have different files of the same type, as:
Time:
100
snr:
88
perf:
10
other:
222
Each of these files are created periodically.
What I need to do is to merge all of them into one but having the following form: (2 Replies)
SHELL SCRIPT
Hi,
I have 3 separate files within a folder. Every File contains data in a single column like
File1 contains data
mayank
sushant
dheeraj
File2 contains
DSA_AT
MG_AT
FLAT_09
File3 contains data
123123
232323 (2 Replies)
Hello everyone!!
I am not completely new to shell script but I havent been able to find the answer to my problem and I'm sure there are some smart brains here up for the challenge :D.
I have several CSV files that I need to combine into one, but I also need to know where each row came from.... (7 Replies)
Hi,
I need to create a .csv file from information that i have in two different tab delimited .txt file. I just want to select some of the columns of each .txt file and paste them into a .cvs file.
My files look like:
File 1
transcript_id Seq. Description Seq. Length ... (2 Replies)
Hi , I want to compare first 3 columns of File A and File B and create a new file File C which will have all rows from File B and will include rows that are present in File A and not in File B based on First 3 column comparison.
Thanks in advance for your help.
File A
A,B,C,45,46... (2 Replies)
Hi,
I have a file of csv data, which looks like this:
file1:
1AA,LGV_PONCEY_LES_ATHEE,1,\N,1,00020460E1,0,\N,\N,\N,\N,2,00.22335321,0.00466628
2BB,LES_POUGES_ASF,\N,200,200,00006298G1,0,\N,\N,\N,\N,1,00.30887539,0.00050312... (10 Replies)
Hi, I am newbie in shell script.
I need your help to solve my problem.
Firstly, I have 2 files of csv and i want to compare of the contents then the output will be written in a new csv file.
File1:
SourceFile,DateTimeOriginal
/home/intannf/foto/IMG_0713.JPG,2015:02:17 11:14:07... (8 Replies)
I am trying to parse two csv files and make a match in one column then print the entire file to a new file and append an additional column that gives description from the match to the new file. If a match is not made, I would like to add "NA" to the end of the file
Command that Ive been using... (6 Replies)
Discussion started by: dis0wned
6 Replies
LEARN ABOUT PLAN9
index
0intro 0intro intro 0intro 2a 2a 6a 2a 8a 2a ka 2a va 2a xa 2a 2c2c 6c 2c 8c 2c kc 2c vc 2c xc 2c 2l 2l 6l 2l 8l 2l kl 2l vl 2l xl2l 81/2 81/2 label 81/2 window 81/2 wloc 81/2 acid acid acme acme
awd acme win acme 8al alef alef alef kal alef val alef ar ar artart art2pic art ascii ascii unicode ascii awk awk basename base-name bc bc bind bind mount bind unmount bind bundle bundle c++c++ c++/2c c++ c++/2l c++ c++/8c c++ c++/8l c++ c++/kc c++ c++/kl
c++ c++/vc c++ c++/vl c++ cal cal calendar calendar cat cat read
cat char char rschar char 1/2char char chgrp chgrp chmod chmod
cmp cmp comm comm con con cu con rx con telnet con xmr con xmscon cp cp mv cp cpp cpp cpu cpu date date db db dc dc dd dd dela-tex deroff deroff deroff diff diff doctype doctype du du echoecho ed ed emacs emacs eqn eqn factor factor primes factor filefile fmt fmt fone fone fortune fortune freq freq 4s games 5s
games ana games catclock games clock games festoon games fire-works games fsim games games games life games mandel games plumbgames smiley games swar games grap grap graph graph grep grep gsgs hoc hoc hp hp join join broke kill kill kill ktrans ktrans lexlex look look lp lp lc ls ls ls aliasmail mail edmail mail mailmail seemail mail sendmail mail smtp mail smtpd mail to mail vis-mon mail vwhois mail lookman man man man mc mc membername mk mkmk mkdir mkdir mothra mothra netstat netstat news news nm nm p p
page page netkey passwd passwd passwd pcc pcc pic pic tpic picplot plot ppp ppp pppclient ppp pppserver ppp pr pr kprof profprof prof proof proof ps ps psu ps pbd pwd pwd pwd cd rc eval rcexec rc exit rc flag rc rc rc rfork rc shift rc wait rc whatis rc
~ rc rm rm B sam sam sam sam.save sam sed sed seq seq size size
sleep sleep sort sort spell spell sprog spell spin spin split
split start stop stop stop strings strings strip strip md5sum sumsum sum syscall syscall tail tail 32vfs tapefs cpiofs tapefstapefs tapefs tapfs tapefs tarfs tapefs tpfs tapefs v10fs tapefs
v6fs tapefs tar tar tbl tbl tcs tcs tee tee iwhois tel tel teltest test bibtex tex dvips tex dviselect tex latex tex mf tex textex time time touch touch tr tr nroff troff troff troff tweaktweak twig twig uniq uniq units units ki vi vi vi xi vi wc wc whowho whois who xd xd yacc yacc yesterday yesterday
05-16-2019
