11-08-2012
When you use EXCEL files I bet there's strange DOS/Windows style control characters in there torpedoing unix like solutions like pamu's. Pls get rid of those exotic chars first. Search this forum; there's many a thread dealing with DOS char removal.
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Hi, everyone,
Let's say, we have
xxx.txt
A 1 2 3 4 5
C 1 2 3 4 5
E 1 2 3 4 5
yyy.txt
A 1 2 3 4 5
B 1 2 3 4 5
C 1 2 3 4 5
D 1 2 3 4 5
E 1 2 3 4 5
First I match the first column I find intersection (A,C, E), then I want to take those lines with ACE out from yyy.txt, like
A 1... (11 Replies)
Discussion started by: kaixinsjtu
11 Replies
2. Ubuntu
Dear All,
I am new to this forum and please ignore my little knowledge :p
I have two types of data (a subset is given below)
data version 1:
439798 2 1
451209 1 2
508696 2 1
555760 2 1
582757 1 2
582889 1 2
691827... (2 Replies)
Discussion started by: evoll
2 Replies
3. Shell Programming and Scripting
Hey guys,
I have two files. file1 and file2.
file1:
a,1
b,2
c,343
d,343
e,4343
f,4544
file 2:
a,
d,
e,
Now i need to find the common data between these files from file1.
i.e
a,1 (8 Replies)
Discussion started by: jaituteja
8 Replies
4. Shell Programming and Scripting
Hi all,
I have 2 files
one file contain data like this in one column
AST3
GSTY4
JST3
second file containign data like this in 2 columns
AST3(PAXXX),GSTY4(PAXXY) it is used in diabetes
KST4 it is used in blood... (6 Replies)
Discussion started by: manigrover
6 Replies
5. Shell Programming and Scripting
Hi all
I have following file which I have to edit for research purpose
file:///tmp/moz-screenshot.png body, div, table, thead, tbody, tfoot, tr, th, td, p { font-family: "Liberation Sans"; font-size: x-small; } Drug: KRP-104 QD Drug: Placebo Drug: Metformin|Drug:... (15 Replies)
Discussion started by: Priyanka Chopra
15 Replies
6. Shell Programming and Scripting
Hi all
I have to compare two files and find common entries
First file is like this
XVY
CVY
ZYN
MNA
In second file I have to search these entries in even number of columns
5 XVY 7 hdfj 8 CVY 9
if there is common entries then out put shuld be
5 XVY(approved) 7 hdfj 8... (11 Replies)
Discussion started by: manigrover
11 Replies
7. Shell Programming and Scripting
Hi Solved these kind of issues using these codes But these are not wrking for my attached files can anybody check........
awk 'NR==FNR{X++;next}{if(X){print}}' file1 file2
awk 'NR==FNR{X=$0;next}{n=split($1,P," ");sub($1,"",$0);for(i=1;i<=n;i++){if(X]){print P,$0}}}' file1 FS="\t" file2
... (6 Replies)
Discussion started by: Priyanka Chopra
6 Replies
8. Shell Programming and Scripting
Hi all
I have 2 files:
first file
AABC
TTYP
JKBH
CVBN
NHJK
KJHM
Second file is
AABC,XCYU,JUHD Alllele1 GACXT It is approved study
TTYP,JKBH Allele2 PPRD It is clinical trial study
JKBH Allele2 PPRD ... (5 Replies)
Discussion started by: Priyanka Chopra
5 Replies
9. Shell Programming and Scripting
Hi,
I have two files with the below values.
file1
305231921 1.0 ben/Ben_Determination_Appeals
1348791394 2.0 ben/Ben_Determination_Appeals]
1305231921 1.0 ben/Cancel_Refund_Payment_JLRS
1348791394 2.0 ben/Cancel_Refund_Payment_JLRS
1305231921 ... (2 Replies)
Discussion started by: Vikram_Tanwar12
2 Replies
10. Shell Programming and Scripting
Hi,
I have 10 files which needs to be print common words from those all files.
Is there any command to find out. (2 Replies)
Discussion started by: munna_dude
2 Replies
LEARN ABOUT OSF1
mkmanifest
mkmanifest(1) General Commands Manual mkmanifest(1)
NAME
mkmanifest - mtools utility to create a shell script to restore UNIX file names from DOS
SYNOPSIS
mkmanifest [files]
OPTIONS
None
OPERANDS
A list of UNIX file names to be converted to DOS name format.
DESCRIPTION
The mkmanifest command creates a shell script that aids in the restore of UNIX file names that were overwritten by DOS file name restric-
tions. DOS file names are uppercase only, cannot exceed 8 character names, 3 character extensions and do not support device names or non-
alphanumeric characters.
Not all UNIX file names are supported in the DOS world. The mtools commands may have to change UNIX names to fit the DOS file name conven-
tions. Most commands provide the verbose option (-v), that displays new file names if they have been changed. The following table shows
some examples of file name conversions:
-----------------------------------------------
UNIX name DOS name Reason for the change
-----------------------------------------------
thisisatest THISISAT file name too long
file.stuff FILE.STU extension too long
prn.txt XRN.TXT PRN is a device name
.abc X.ABC null file name
hot+cold HOTXCOLD illegal character
-----------------------------------------------
EXIT STATUS
The following exit values are returned: Success. Failure.
EXAMPLES
Assume you have the following UNIX files that you want to copy to a DOS diskette using the mcopy command.
very_long_name 2.many.dots illegal: good.c prn.dev Capital
The mcopy command converts these file names to the following:
very_lon 2xmany.dot illegalx good.c xprn.dev capital
To restore the previous file names, use the mkmanifest command as follows: mkmanifest very_long_name 2.many.dots illegal:
good.c prn.dev Capital > manifest
The previous mkmanifest command line produces 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
The good.c file name did not require conversion, hence it was not included in the output.
If these files were copied from diskette to another UNIX system, and you wanted to restore the original names, retain a copy of the mani-
fest file (captured output) so that it can be used to convert the file names again.
FILES
Executable file
SEE ALSO
Commands: mcopy(1), mtools(1)
mkmanifest(1)