10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Dear Masters,
I want to remove all lines with blank spaces
input file:
a|abc|0|1
a|abc|2|3
b||3|5
c|def||7
d|def|0|1
Expected:
a|abc|0|1
a|abc|2|3
d|def|0|1
I did this
awk -F'|' '!/^$/' input (4 Replies)
Discussion started by: radius
4 Replies
2. Shell Programming and Scripting
Hi All,
The output file contains data as below.
"20141023","CUSTOMER" ,"COMPANY" ,"IN0515461" ,"" ,"JOSHUA"
There are spaces in between the ending " and ,. The number of spaces is random.
How can I remove that from the file so that the final output is:... (4 Replies)
Discussion started by: aarsh.dave
4 Replies
3. Shell Programming and Scripting
Hi team,
Here's a requirement for me.
Here are the list of files i have in a unix directory.
W 2 A D_2014.csv
W 3 A D_2014.csv
W 4 A D_2014.csv
/home/kmani00-> uname -a
AIX sliyyvxx 1 6 00F613E54C00
/home/kmani00->
The file names has to be without spaces as follows.
W2AD_2014.csv... (1 Reply)
Discussion started by: kmanivan82
1 Replies
4. Shell Programming and Scripting
Hi, suppose I have the following data:
albert music=top40 age=20
bob music=punk rock age=25
candy music=r n b age=22
dave music=mozart or bach only age=30
I want to extract and manipulate the music column but it's got spaces in it. How can I substitute the space with an underscore... (2 Replies)
Discussion started by: almonds
2 Replies
5. Shell Programming and Scripting
Gents,
Please can you help me.. to remove blank spaces :)
Input
ABSOLUTE , ,FALSE ,1035 ,28 ,669 ,1817.0 ,CORREL BEFORE ,1
ABSOLUTE , ,FALSE ,1035 ,28 ,686 ,1817.0 ,CORREL BEFORE ,1
ABSOLUTE , ,FALSE ,1035 ,28 ,670 ,1819.0 ,CORREL BEFORE ,1
ABSOLUTE , ,FALSE ... (4 Replies)
Discussion started by: jiam912
4 Replies
6. Shell Programming and Scripting
Hi folks,
I need to remove spaces at the end of each line in a *.txt file. it looks like this
word 1
word 2
.
.
.
word n
i found some sed commands but any of them didnt work so far
thank you for your posts (6 Replies)
Discussion started by: Jimmy7
6 Replies
7. UNIX for Dummies Questions & Answers
hey,
I have this file:
ATOM 2510 HG12 VAL 160 8.462 15.861 1.637
ATOM 2511 HG13 VAL 160 9.152 14.510 0.725
ATOM 2512 CG2 VAL 160 6.506 16.579 -0.088
ATOM 2513 HG21 VAL 160 5.499 16.421 -0.478
ATOM 2514 HG22 VAL 160 6.417 16.984 ... (4 Replies)
Discussion started by: kanikasharma
4 Replies
8. Shell Programming and Scripting
Hi All,
I have a comma seperated file.
I wanna remove the spaces from column 2. I mean i don't wanna remove the spaces those are presnt in column 1.
ex:
emp name, emp no, salary
abc k, abc 11, 1000 00
bhk s, bhk 22, 2000 00
the output should be:
emp name, emp no, salary
abc k, abc11,... (4 Replies)
Discussion started by: javeed7
4 Replies
9. Shell Programming and Scripting
I have a file with only one field something like this :
213.45
220.65
240.47
345.67
320.45
I want to remove all spaces in between. Is there any unix command for that ?Thanks in advance.. (2 Replies)
Discussion started by: jacks
2 Replies
10. Shell Programming and Scripting
Hi,
Here is sample data which I have:
column#1 column#2 column#3
001A 50005 ROCKER ADJ 00010000100018UTIRR
001A 50020 CRANKSHAFT 0003445ES
001A 52201 SPARKPLUG ... (4 Replies)
Discussion started by: tayyabq8
4 Replies
PERLDBMFILTER(1) Perl Programmers Reference Guide PERLDBMFILTER(1)
NAME
perldbmfilter - Perl DBM Filters
SYNOPSIS
$db = tie %hash, 'DBM', ...
$old_filter = $db->filter_store_key ( sub { ... } );
$old_filter = $db->filter_store_value( sub { ... } );
$old_filter = $db->filter_fetch_key ( sub { ... } );
$old_filter = $db->filter_fetch_value( sub { ... } );
DESCRIPTION
The four "filter_*" methods shown above are available in all the DBM modules that ship with Perl, namely DB_File, GDBM_File, NDBM_File,
ODBM_File and SDBM_File.
Each of the methods works identically, and is used to install (or uninstall) a single DBM Filter. The only difference between them is the
place that the filter is installed.
To summarise:
filter_store_key
If a filter has been installed with this method, it will be invoked every time you write a key to a DBM database.
filter_store_value
If a filter has been installed with this method, it will be invoked every time you write a value to a DBM database.
filter_fetch_key
If a filter has been installed with this method, it will be invoked every time you read a key from a DBM database.
filter_fetch_value
If a filter has been installed with this method, it will be invoked every time you read a value from a DBM database.
You can use any combination of the methods from none to all four.
All filter methods return the existing filter, if present, or "undef" if not.
To delete a filter pass "undef" to it.
The Filter
When each filter is called by Perl, a local copy of $_ will contain the key or value to be filtered. Filtering is achieved by modifying the
contents of $_. The return code from the filter is ignored.
An Example: the NULL termination problem.
DBM Filters are useful for a class of problems where you always want to make the same transformation to all keys, all values or both.
For example, consider the following scenario. You have a DBM database that you need to share with a third-party C application. The C
application assumes that all keys and values are NULL terminated. Unfortunately when Perl writes to DBM databases it doesn't use NULL
termination, so your Perl application will have to manage NULL termination itself. When you write to the database you will have to use
something like this:
$hash{"$key "} = "$value ";
Similarly the NULL needs to be taken into account when you are considering the length of existing keys/values.
It would be much better if you could ignore the NULL terminations issue in the main application code and have a mechanism that
automatically added the terminating NULL to all keys and values whenever you write to the database and have them removed when you read from
the database. As I'm sure you have already guessed, this is a problem that DBM Filters can fix very easily.
use strict;
use warnings;
use SDBM_File;
use Fcntl;
my %hash;
my $filename = "filt";
unlink $filename;
my $db = tie(%hash, 'SDBM_File', $filename, O_RDWR|O_CREAT, 0640)
or die "Cannot open $filename: $!
";
# Install DBM Filters
$db->filter_fetch_key ( sub { s/ $// } );
$db->filter_store_key ( sub { $_ .= "