08-28-2009
Removing Lines if value exist in first file
I tried a few ways to resolve this using a bash script w/ a loop, no luck.
File1: roughly 6,000 account numbers such as:
1111
1512
1113
123
I also have a dozen or so csv files, w/ the account number in the 4th field. What I would like to do is remove all lines if the account number is contained in File1.
So file looking like this:
1,55,John,2000,abc
1,55,Jane,1113,abc
1,55,Smit,9565,def
1,55,Phil,123,adf
1,55,John,205480,sdf
Would end up looking like this:
1,55,John,2000,abc
1,55,Smit,9565,def
1,55,John,205480,sdf
Any help would be appreciated!
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hello
i have 2 files file1 and file2 as shown below
file1
110010000000206|567810008161509
110010000000207|567810072227627
110010000000208|567811368851555
110010000000209|567811422513652
110010000000210|567812130217683
110010000000211|567813220211182
110010000000212|567813449322589... (4 Replies)
Discussion started by: PradeepRed
4 Replies
2. Shell Programming and Scripting
Hi There,
I've written a script that processes a data file on our system. Basically the script reads a post code from a list file, looks in the data file for the first occurrence (using grep) and reads the line number. It then tails the data file, with the line number just read, and outputs to a... (3 Replies)
Discussion started by: tookers
3 Replies
3. UNIX for Dummies Questions & Answers
I'm trying to find a command which will allow me to remove a range of lines (2-4) from a .dat file from the command line without opening the file.
Someone mentioned using the ex command?
Does anyone have any ideas?
thanks (6 Replies)
Discussion started by: computersaysno
6 Replies
4. Shell Programming and Scripting
Hi Gurus,
I'm a little new to UNIX. How can I do remove the first and last line in a file? Say, supppose I have a file as below:
Code:
1DMA
400002BARRIE
401002CALGARY/LETHBRI
402002CARLETON
500001PORTLAND-AUBRN
501001NEW YORK, NY
502001BINGHAMTON, NY ... (2 Replies)
Discussion started by: naveendronavall
2 Replies
5. UNIX for Dummies Questions & Answers
Hi folks, I have a long string of DNA sequences, and I need to remove several lines, as well as the line directly following them. For example, here is a sample of my starting material:
>548::GY31UMJ02DLYEH rank=0007170 x=1363.5 y=471.0 length=478... (1 Reply)
Discussion started by: kkohl78
1 Replies
6. UNIX for Dummies Questions & Answers
Hi there, normally if I want to remove a user tht I have added to a specific group, i would do the following
this is what my group2 looks like
# grep group2 /etc/group
group2:x:7777:user2,user1,user4
user1 has been defined in a few groups
# id -nG user1
group1 group2 group3
So... (3 Replies)
Discussion started by: rethink
3 Replies
7. Shell Programming and Scripting
I have a reference file that needs to remain static and another file that may or may not have duplicate rows that match the reference file. I need help with a command that will delete any duplicate rows from the second file while leaving reference file intact
For example reference file would... (4 Replies)
Discussion started by: bjdamon
4 Replies
8. Shell Programming and Scripting
Hello Everyone,
I'm currently have a requirement where I've generated a list of files with specific attributes and I need to know what lines are similar between the two files. For example:
-File 1-
line1
line2
line3
-File 2-
line1
line2
line4
line5
-Desires Output-
line1
line2... (5 Replies)
Discussion started by: omnivir
5 Replies
9. Shell Programming and Scripting
Hi,
I have a linux server that was hacked and I have a bunch of files that sporadically contain the following lines through out the file:
<?php eval(base64_decode("Xxxxxxxxxxxxxx/xxxxxxxx"));
I did't put the exact lines of the file in this post. The "Xxxx" are random letters/numbers.... (8 Replies)
Discussion started by: nck
8 Replies
10. Shell Programming and Scripting
I have a file `/tmp/wrk` containing filenames with paths. I want to remove filenames
from this file, for example
remove all filenames containing alja cagr cavt clta cmdo or corl
remove all filenames containing data for days in region `d.2016.001` to `d.2016.207`
remove all filenames... (10 Replies)
Discussion started by: kristinu
10 Replies
LEARN ABOUT DEBIAN
fntsample
fntsample(1) General Commands Manual fntsample(1)
NAME
fntsample - PDF and PostScript font samples generator
SYNOPSIS
fntsample [ OPTIONS ] -f FONT-FILE -o OUTPUT-FILE
fntsample -h
DESCRIPTION
fntsample program can be used to generate font samples that show Unicode coverage of the font and are similar in appearance to Unicode
charts. Samples can be saved into PDF (default) or PostScript file.
OPTIONS
fntsample supports the following options.
--font-file, -f FONT-FILE
Make samples of FONT-FILE.
--font-index, -n IDX
Font index for FONT-FILE specified using --font-file option. Useful for files that contain multiple fonts, like TrueType Collec-
tions (.ttc). By default font with index 0 is used.
--output-file, -o OUTPUT-FILE
Write output to OUTPUT-FILE.
--other-font-file, -d OTHER-FONT
Compare FONT-FILE with OTHER-FONT. Glyphs added to FONT-FILE will be highlighted.
--other-index, -m IDX
Font index for OTHER-FONT specified using --other-font-file option.
--postscript-output, -s
Use PostScript format for output instead of PDF.
--svg, -g
Use SVG format for output. The generated document contains one page. Use range selection options to specify which.
--print-outline, -l
Print document outlines data to standard output. This data can be used to add outlines (aka bookmarks) to resulting PDF file with
pdfoutline program.
--include-range, -i RANGE
Show characters in RANGE.
--exclude-range, -x RANGE
Do not show characters in RANGE.
--style, -t "STYLE: VAL"
Set STYLE to value VAL. Run fntsample with option --help to see list of styles and default values.
--help, -h
Display help text and exit.
Parameter RANGE for -i and -x can be given as one integer or a pair of integers delimited by minus sign (-). Integers can be specified in
decimal, hexadecimal (0x...) or octal (0...) format. One integer of a pair can be missing (-N can be used to specify all characters with
codes less or equal to N, and N- for all characters with codes greather or equal to N). Multiple -i and -x options can be used.
EXAMPLES
Make PDF samples for font.ttf and write them to file samples.pdf:
fntsample -f font.ttf -o samples.pdf
Make PDF samples for font.ttf, compare it with oldfont.ttf and highlight new glyphs. Write output to file samples.pdf:
fntsample -f font.ttf -d oldfont.ttf -o samples.pdf
Make PostScript samples for font.ttf and write output to file samples.ps. Show only glyphs for characters with codes less or equal to
U+04FF but exclude U+0370-U+03FF:
fntsample -f font.ttf -s -o samples.ps -i -0x04FF -x 0x0370-0x03FF
Make PDF samples for font.ttf and save output to file samples.pdf adding outlines to it:
fntsample -f font.ttf -o temp.pdf -l > outlines.txt
pdfoutline temp.pdf outlines.txt samples.pdf
AUTHOR
Copyright (C) 2007 Eugeniy Meshcheryakov <eugen@debian.org>
Homepage: <http://fntsample.sourceforge.net/>
SEE ALSO
pdfoutline(1)
2010-10-14 fntsample(1)