07-09-2013
many thanks Subbeh
this doesnt work for me - I get slightly garbled output in 3 columns and it only shows the rows which have matches in all 3 sub-lists. Am I right thinking that this works for 3 sub- lists but not more? I have hundreds...
I will play around with it and see what I can manage
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hello,
Could someone please help me to convert a string(s) of comma separated values into space padded columns in .ksh?
ex.
10-21-2008,someword,blah,127.0.0.1,8,3
10-21-2008,randomword,ick,128.0.111.128,1,0
converted to
10-21-2008 someword blah 127.0.0.1 8... (6 Replies)
Discussion started by: WhotheWhat
6 Replies
2. Shell Programming and Scripting
Hi,
Plz help.
input line
1;20100403;400|2;20100403;4|3;20290903;400|4;20290903;0|5;20290903;0|9;20100304;0|10;20100304;0|11;20100402;0|18;20100304;0
expected output
1;20100403;400
2;20100403;4
3;20290903;400
4;20290903;0
5;20290903;0
9;20100304;0
10;20100304;0
11;20100402;0... (4 Replies)
Discussion started by: suresh3566
4 Replies
3. Shell Programming and Scripting
Dear all,
I have a file in this format (like a matrix)
- A B C .. X
A 1 4 2 .. 2
B 2 6 4 .. 8
C 3 5 5 .. 4
. . . ... .
X . . ... .
and want to convert it into a file with this format:
A A = 1
A B = 4
A C = 2
...
A X = 2
B A = 2
B B = 6
etc (2 Replies)
Discussion started by: TheTransporter
2 Replies
4. Shell Programming and Scripting
How do I loop thru space separated values in a variable?
I hate to use very complicated counter increment logic for this kind of simple problem.
Expected result(using ksh)
$>echo "aaa bbbb cccc" | <looping code here>
var=aaa
var=bbbb
var=cccc
$>echo "aaa bbbb cccc" | while IFS=" "... (12 Replies)
Discussion started by: kchinnam
12 Replies
5. UNIX for Dummies Questions & Answers
Hi,
I have a large number of files which are written as csv (comma-separated values).
Does anyone know of simple sed/awk command do achieve this?
Thanks!
---------- Post updated at 10:59 AM ---------- Previous update was at 10:54 AM ----------
Guess I asked this too soon. Found the... (0 Replies)
Discussion started by: lost.identity
0 Replies
6. Shell Programming and Scripting
Hi, I am converting a comma separated file to fixed field lenght and I am using that:
COLUMNS="25 24 67 26 39 63 20 34 35 14 397"
(
cat $indir/input_file.dat | \
$AWK -v columns="$COLUMNS" '
BEGIN {
FS=",";
OFS="";
split(columns, arr, " ");
}
{
for(i=1; i<=NF;... (5 Replies)
Discussion started by: apenkov
5 Replies
7. Shell Programming and Scripting
Hi,
I need to extract an info in $1 based on a matched pattern in $2,$3,$4, and $5.
The sample input file as follows:-
ID Pat1 Pat2 Pro1 use1
add41 M M M
add87 M M M M
add32 ... (16 Replies)
Discussion started by: redse171
16 Replies
8. Shell Programming and Scripting
Hi,
I am having a file say list1 with a output like below
jun 12 18:23
may 20 18:23
Now i want to pass the above two values into for loop,I have written a script like this.
#!/bin/bash
a=`cat list1`
for i in $a
do
echo "HI $i"
done
expected output:
HI jun 12 18:23 (3 Replies)
Discussion started by: sumanthupar
3 Replies
9. Shell Programming and Scripting
Hi,
I have a list of tables in a file.txt
C_CLAIM
C_HLD
C_PROVIDER
I want the output to be
'C_CLAIM','C_HLD','C_PROVIDER'
Currently I'm usin awk and getting output which is almost correct but still has minor defects
awk -vORS="','" '{ print $1 }' file.txt
The output of... (4 Replies)
Discussion started by: wahi80
4 Replies
10. Shell Programming and Scripting
Hi All,
Hope you are doing Great!!!.
Today i have came up with a problem to say exactly it was for performance improvement.
I have written code in perl as a solution for this to cut in specific range, but it is taking time to run for files thousands of lines so i am expecting
a sed... (9 Replies)
Discussion started by: mad man
9 Replies
LEARN ABOUT BSD
mkmanifest
MKMANIFEST(1) General Commands Manual MKMANIFEST(1)
NAME
mkmanifest - create a shell script to restore Unix filenames
SYNOPSIS
mkmanifest [ files ]
DESCRIPTION
Mkmanifest creates a shell script that will aid in the restoration of Unix filenames that got clobbered by the MSDOS filename restrictions.
MSDOS filenames are restricted to 8 character names, 3 character extensions, upper case only, no device names, and no illegal characters.
The mkmanifest program is compatible with the methods used in pcomm, arc, and mtools to change perfectly good Unix filenames to fit the
MSDOS restrictions.
EXAMPLE
I want to copy the following Unix files to a MSDOS diskette (using the mcopy command).
very_long_name
2.many.dots
illegal:
good.c
prn.dev
Capital
Mcopy will convert the names to:
very_lon
2xmany.dot
illegalx
good.c
xprn.dev
capital
The command:
mkmanifest very_long_name 2.many.dots illegal: good.c prn.dev Capital > manifest
would produce the following:
mv very_lon very_long_name
mv 2xmany.dot 2.many.dots
mv illegalx illegal:
mv xprn.dev prn.dev
mv capital Capital
Notice that "good.c" did not require any conversion, so it did not appear in the output.
Suppose I've copied these files from the diskette to another Unix system, and I now want the files back to their original names. If the
file "manifest" (the output captured above) was sent along with those files, it could be used to convert the filenames.
SEE ALSO
arc(1), pcomm(1), mtools(1)
local MKMANIFEST(1)