Hi,
How to separate numbers and words(with full alphabets) in a particular file and store it in two different files.
Please help me out for this.Using shell scripting.
:confused::confused: (1 Reply)
Hi all,
Please some help over here. I have a Sales.txt file containing info in blocks for
every sold product in the pattern showed below (only for 2 products).
NEW BLOCK
SALE DATA
PRODUCT SERIAL
79833269999 146701011945004
.Some other data
.Some... (17 Replies)
Hi,
I have to write a shell script that converts numbers in to words
below is what i wrote.My script is not running.
-----------------------------------
echo -n "Enter number : "
read n
len= echo $n | wc -c
echo " number in words : "
for ( i=1; i<len; i++ )
do
num=echo $n... (5 Replies)
Hi guys,
I have got a file which doesn't have the same number of columns in each line. I would like to print the second column and the one that begins with 33= and has some numbers after '33='
Can you please help me asap?
Cheers (7 Replies)
Hi All,
I have searched the forum and tried to print only matching(pattern) words from the file, but its printing entire line. I tried with grep -w. I am on sunsolaris.
Eg:
cat file
A|A|F1|F2|A|F3|A
A|F10|F11|F14|A|
F20|A|F21|A|F25
I have to search for F (F followed by numbers) and ... (5 Replies)
Hi,
Sorry in advance for propably a silly question, but I am a bit lost.
On some of the linux job flow I have the following check:
if ($file != 1500) then
echo ERROR
It works ok, all times $file is not equal to 1500 I have the error message.
I try to do something similar... (7 Replies)
Hi. I have a file containing words and numbers associated with them as follows -
c 2
b 5
c 5
b 6
a 10
b 16
c 18
a 19
b 21
c 27
a 28
b 33
a 76
a 115
c 199
c 251
a 567
a 1909 (4 Replies)
Hi All,
I tried to solve this but the result gives me all zeros for one file. I failed to do for all 500 files.
I have some 500 files with the extension .dat I have another set of files; 500 in number with extension .dic I created these .dic files by using sort -u from the actual .dat files.... (2 Replies)
Hi All,
I have a file which looks like this:
abc 1
abc 2
abc 3
abc 4
abc 5
bcd 1
bcd 3
bcd 3
bcd 5
cde 7
This file is just a miniature version of what I really have. Original file is some 1 million lines long.
I have tried to come up with the code for what I wish to accomplish... (1 Reply)
Class::DBI::Query(3pm) User Contributed Perl Documentation Class::DBI::Query(3pm)NAME
Class::DBI::Query - Deprecated SQL manager for Class::DBI
SYNOPSIS
my $sth = Class::DBI::Query
->new({
owner => $class,
sqlname => $type,
essential => @columns,
where_columns => @where_cols,
})
->run($val);
DESCRIPTION
This abstracts away many of the details of the Class::DBI underlying SQL mechanism. For the most part you probably don't want to be
interfacing directly with this.
The underlying mechanisms are not yet stable, and are subject to change at any time.
OPTIONS
A Query can have many options set before executing. Most can either be passed as an option to new(), or set later if you are building the
query up dynamically:
owner
The Class::DBI subclass that 'owns' this query. In the vast majority of cases a query will return objects - the owner is the class of which
instances will be returned.
sqlname
This should be the name of a query set up using set_sql.
where_clause
This is the raw SQL that will substituted into the 'WHERE %s' in your query. If you have multiple %s's in your query then you should supply
a listref of where_clauses. This SQL can include placeholders, which will be used when you call run().
essential
When retrieving rows from the database that match the WHERE clause of the query, these are the columns that we fetch back and pre-load the
resulting objects with. By default this is the Essential column group of the owner class.
METHODS
where()
$query->where($match, @columns);
This will extend your 'WHERE' clause by adding a 'AND $column = ?' (or whatever $match is, isntead of "=") for each column passed. If you
have multiple WHERE clauses this will extend the last one.
perl v5.12.4 2004-04-25 Class::DBI::Query(3pm)