Yes Mr.bean.. i will be using it in only one while loop.. for the while loop runs many times(runs as number of tables present in the file) for eg in mysqldump.sql there are 3 tables so the while loop runs 3 times. so in the 1st run of while loop table11 is copied to a temporary file and closes the file. i will be performing some operations on extracting this file content. in the second run of while loop (we can consider for loop insteaded of while loop running on i<3 incrementing i everytime) table22 is written to same file and process goes on. your code does the job but it will be doing it in one shot. even if i try it in for loop or while loop the code which you sent writes the last table to file everytime. cause its designed to overwrite tables in one run or one shot. in the java code which i sent there is a line called br.readLine(). this line is like a pointer it stops and starts from where it left of in prvious run of loop. so in first run br.readLine write table11 in second run br.readLine write table22 and 3rd table33. hope you understood what i am trying to achieve... :-/
example:
Code:
While [some condition] // i can use for loop too
(condition say when i=0)
do
your code goes here...which writes table11 to tmp.sql
my code goes here which read from this tmp.sql file which has table11 and do some function
done
in the same loop when i=1 table22 is written to temporary file.. and when i=2 table33 is written to file..
---------- Post updated at 02:52 PM ---------- Previous update was at 02:40 PM ----------
is there any code in shell scripting which performs the function of ".contains" of java
i mean
somevariable has a sentence or long line say
Code:
somevariable="this is a line to show CREATE TABLE sometablename is used to create table"
Code:
if(somevariable has "CREATE TABLE")
then
counter++;
fi
---------- Post updated at 02:55 PM ---------- Previous update was at 02:52 PM ----------
i got the answer for .contains...
if [[ $var == *CREATE* ]]
then
echo "its present"
fi
---------- Post updated at 03:20 PM ---------- Previous update was at 02:55 PM ----------
sorry the above one dint workout.. however below one worked :-)
Code:
while read line1
do
if [[ `expr match "$line1" ".*CREATE TABLE.*"` != "0" ]]
then
counter1=`expr $counter1 + 1`
fi
done < counterfile1.sql
Hi,
anyone has any ideas on how do we extract lines from a file with format similiar to this: (based on current time)
Jun 18 00:16:50 .......... ............. ............
Jun 18 00:17:59 .......... ............. ............
Jun 18 01:17:20 .......... ............. ............
Jun 18... (5 Replies)
Hi,
I have one file, say file 1, that has data like below where 19900107 is the date,
19900107 12 144 129 0.7380047
19900108 12 168 129 0.3149017
19900109 12 192 129 3.2766666E-02
... (3 Replies)
consider the following is the contents of the file
cat 11.sql
drop procedure if exists hoop1 ;
Delimiter $$
CREATE PROCEDURE hoop1(id int)
BEGIN
END
$$
Delimiter ;
.
.
.
.
drop procedure if exists hoop2;
Delimiter $$
CREATE PROCEDURE hoop2(id int)
BEGIN
END
$$ (8 Replies)
hi
i have an input file that contains some thing like this
aaa acc aa abc1 1232 aaa abc2....
poo awq aa abc1 aaa aaa abc2
bbb bcc bb abc1 3214 bbb abc3....
bab bbc bz abc1 3214 bbb abc3....
vvv ssa as abc1 o09 aaa abc4....
azx aaq aa abc1 900 aqq abc19....
aaa aa aaaa abc1 899 aa... (8 Replies)
Hi,
I am trying to extract lines from a text file given a text file containing line numbers to be extracted from the first file. How do I go about doing this? Thanks! (1 Reply)
here below is a part of the file
cat fileName.txt
NAME=APP-VA-va_mediaservices-113009-VA_MS_MEDIA_SERVER_NOT_PRESENT-S
FIXED=false
DATE= 2013-02-19 03:46:04.4
PRIORITY=HIGH
RESOURCE NAME=ccm113
NAME=APP-DS-ds_ha-140020-databaseReplicationFailure-S
FIXED=false
DATE= 2013-02-19... (4 Replies)
I have a output file which contains n number of document.Each document has n number of segments and identified using below points
The starting segment is ISA and Ending segment is IEA
Each document has unique number and it will be passed in REF*D9 segment
Each line in sample file is called... (3 Replies)
consider below file contents
cat myOutputFIle.txt
8 CCM-HQE-ResourceHealthCheck:
Resource List :
No RED/UNKNOWN resource Health entries found
----------------------------------------------------------
9 CCM-TraderLogin-Status:
Number of logins: 0... (4 Replies)
Hello,
I have a file ff.txt that looks as follows
*ABNA.txt
356
24
36
112
*AC24.txt
457
458
321
2
ABNA.txt and AC24.txt are the files in the folder named foo1. Based on the numbers in the ff.txt file, I want to extract the lines from the corresponding files in the foo1 folder and... (2 Replies)
Hello!
I'm trying to process a text file and am stuck at 2 extractions. Hoping someone can help me here:
1. Given a line in a text file and given a keyword, how can I extract the word preceeding the keyword using a shell command/script?
For example: Given a keyword "world" in the line: ... (2 Replies)
Discussion started by: seemad
2 Replies
LEARN ABOUT DEBIAN
marc::charset::table
MARC::Charset::Table(3pm) User Contributed Perl Documentation MARC::Charset::Table(3pm)NAME
MARC::Charset::Table - character mapping db
SYNOPSIS
use MARC::Charset::Table;
use MARC::Charset::Constants qw(:all);
# create the table object
my $table = MARC::Charset::Table->new();
# get a code using the marc8 character set code and the character
my $code = $table->lookup_by_marc8(CYRILLIC_BASIC, 'K');
# get a code using the utf8 value
$code = $table->lookup_by_utf8(chr(0x043A));
DESCRIPTION
MARC::Charset::Table is a wrapper around the character mapping database, which is implemented as a tied hash on disk. This database gets
generated by Makefile.PL on installation of MARC::Charset using MARC::Charset::Compiler.
The database is essentially a key/value mapping where a key is a MARC-8 character set code + a MARC-8 character, or an integer representing
the UCS code point. These keys map to a serialized MARC::Charset::Code object.
new()
The consturctor.
add_code()
Add a MARC::Charset::Code to the table.
get_code()
Retrieve a code using a hash key.
lookup_by_marc8()
Looks up MARC::Charset::Code entry using a character set code and a MARC-8 value.
use MARC::Charset::Constants qw(HEBREW);
$code = $table->lookup_by_marc8(HEBREW, chr(0x60));
lookup_by_utf8()
Looks up a MARC::Charset::Code object using a utf8 value.
db()
Returns a reference to a tied character database. MARC::Charset::Table wraps access to the db, but you can get at it if you want.
db_path()
Returns the path to the character encoding database. Can be called statically too:
print MARC::Charset::Table->db_path();
brand_new()
An alternate constructor which removes the existing database and starts afresh. Be careful with this one, it's really only used on
MARC::Charset installation.
perl v5.12.4 2010-09-09 MARC::Charset::Table(3pm)