09-19-2018
And what command did you use that produced the output you showed us in post #11?
In addition to what RudiC has already said, we also have to assume that you realize that the sanitized output you showed us from excel has lost all field boundaries. So, any awk script that you might try to use with that sanitized output as an input file is hopelessly incapable of determining which text belongs in which field.
This User Gave Thanks to Don Cragun For This Post:
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Gurus,
I have one file which is having multiple columns and also this file is not always contain the exact columns; sometimes it contains 5 columns or 12 columns. Now, I need to find the difference from that particular file. Here is the sample file:
param1 | 10 | 20 | 30 |
param2 | 10 |... (6 Replies)
Discussion started by: buzzusa
6 Replies
2. Shell Programming and Scripting
pls help
Input:
file1
word1
text1
word2
text2
word3
text3
file2
word1
text11
word3
text13
can u pls help in getting the same
output:
file1 text1 text2 text3 (1 Reply)
Discussion started by: bha148
1 Replies
3. Shell Programming and Scripting
Hi guys,
I'm rather new at using UNIX based systems, and when it comes to scripting etc I'm even newer.
I have two files which i need to compare.
file1: (some random ID's)
451245
451288
136588
784522
file2: (random ID's + e-mail assigned to ID)
123888 xc@xc.com
451245 ... (21 Replies)
Discussion started by: spirm8
21 Replies
4. UNIX for Dummies Questions & Answers
Dear Gurus,
I am very new to UNIX. I appreciate your help to manage my files.
I have 16 files with equal number of columns in it. Each file has 9 columns separated by space. I need to compare the values in the second column of first file and obtain the corresponding value in the 9th column... (12 Replies)
Discussion started by: Unilearn
12 Replies
5. UNIX for Dummies Questions & Answers
I have two text files where the first three columns are exactly the same. I want to compare the fourth column of the text files and if the values are different, print that row into a new output file. How do I go about doing that?
File 1:
100 rs3794811 0.01 0.3434
100 rs8066551 0.01... (8 Replies)
Discussion started by: evelibertine
8 Replies
6. UNIX for Dummies Questions & Answers
Hi,
I have two text files with matching first columns. Some of the values in the second column do not match. I want to write a script to print out the rows (only the first column) where the values in the second column do not match.
Example:
Input 1
A 1
B 2
C 3
D 4
Input 2
A 2
B 2... (6 Replies)
Discussion started by: evelibertine
6 Replies
7. Shell Programming and Scripting
Dear Shell experts,
I have 2 files with structure:
File 1: ID and count
head test_GI_count1.txt
1000094 2
10039307 1
10039641 1
10047177 11
10047359 1
1008555 2
10120302 1
10120672 13
10121776 1
10121865 32
And 2nd file:
head Protein_gi_GeneID_symbol.txt
protein_gi GeneID... (11 Replies)
Discussion started by: smitra
11 Replies
8. Shell Programming and Scripting
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)
Discussion started by: ady_koolz
2 Replies
9. Shell Programming and Scripting
Hi all, I'm trying to match the following two files with the code below:
awk -F, 'NR==FNR {a=$0; next} ($12,$4) in a {print $12,$1,a}' OFS="," file4.csv file3.csv
but the code does not print the entire row from file4 in addition to column 12 and 1 of file3.
file4:
o,c,q,co,ov,b... (1 Reply)
Discussion started by: bkane3
1 Replies
10. UNIX for Beginners Questions & Answers
Hi,
i have 2 files , the data i need to match is in masterfile and i need to pull out column 3 from master if column 1 and 2 match and output entire row to new file
I have tried with join and awk and i keep getting blank outputs or same file
is there an easier way than what i am... (4 Replies)
Discussion started by: axis88
4 Replies
LEARN ABOUT DEBIAN
alien::package::deb
Alien::Package::Deb(3pm) User Contributed Perl Documentation Alien::Package::Deb(3pm)
NAME
Alien::Package::Deb - an object that represents a deb package
DESCRIPTION
This is an object class that represents a deb package. It is derived from Alien::Package.
FIELDS
have_dpkg_deb
Set to a true value if dpkg-deb is available.
dirtrans
After the build stage, set to a hash reference of the directories we moved files from and to, so these moves can be reverted in the
cleantree stage.
fixperms
If this is set to true, the generated debian/rules will run dh_fixperms.
METHODS
init
Sets have_dpkg_deb if dpkg-deb is in the path. I prefer to use dpkg-deb, if it is available since it is a lot more future-proof.
checkfile
Detect deb files by their extention.
install
Install a deb with dpkg. Pass in the filename of the deb to install.
test
Test a deb with lintian. Pass in the filename of the deb to test.
getcontrolfile
Helper method. Pass it the name of a control file, and it will pull it out of the deb and return it.
scan
Implement the scan method to read a deb file.
unpack
Implement the unpack method to unpack a deb file.
getpatch
This method tries to find a patch file to use in the prep stage. If it finds one, it returns it. Pass in a list of directories to
search for patches in.
prep
Adds a populated debian directory the unpacked package tree, making it ready for building. This can either be done automatically, or
via a patch file.
build
Build a deb.
cleantree
Delete the entire debian/ directory.
package
Set/get package name.
Always returns the packge name in lowercase with all invalid characters rmoved. The name is however, stored unchanged.
version
Set/get package version.
When the version is set, it will be stripped of any epoch. If there is a release, the release will be stripped away and used to set the
release field as a side effect. Otherwise, the release will be set to 1.
More sanitization of the version is done when the field is retrieved, to make sure it is a valid debian version field.
release
Set/get package release.
Always returns a sanitized release version. The release is however, stored unchanged.
description
Set/get description
Although the description is stored internally unchanged, this will always return a sanitized form of it that is compliant with Debian
standards.
date
Returns the date, in rfc822 format.
email
Returns an email address for the current user.
username
Returns the user name of the real uid.
savescript
Saves script to debian directory.
gen_postinst
Modifies or creates a postinst. This may include generated shell code to set owners and groups from the owninfo field, and update modes
from the modeinfo field.
AUTHOR
Joey Hess <joey@kitenet.net>
perl v5.14.2 2012-04-05 Alien::Package::Deb(3pm)