I have 3 files that contain the following information (sql output from Oracle database stored in a txt file):
File1.txt :
Code:
alter table "SYS"."INT_COST_PRICE" enable row movement;
alter table "SYS"."INT_SOH" enable row movement;
alter table "SYSMAN"."XX_ACI_SKURTP" enable row movement;
second file contains the following information (source same as above):
File2.txt
Code:
alter table "SYS"."INT_COST_PRICE" shrink space compact;
alter table "SYS"."INT_SOH" shrink space compact;
alter table "SYSMAN"."XX_ACI_SKURTP" shrink space compact;
Third file contains the following information (source same as above):
File3.txt
Code:
alter table "SYS"."INT_COST_PRICE" disable row movement;
alter table "SYS"."INT_SOH" disable row movement;
alter table "SYSMAN"."XX_ACI_SKURTP" disable row movement;
I would like to combine the files together into one single file and having an output as shown below (with blank lines after every 3 lines:
Final_output_file.txt
Code:
alter table "SYS"."INT_COST_PRICE" enable row movement;
alter table "SYS"."INT_COST_PRICE" shrink space compact;
alter table "SYS"."INT_COST_PRICE" disable row movement;
alter table "SYS"."INT_SOH" enable row movement;
alter table "SYS"."INT_SOH" shrink space compact;
alter table "SYS"."INT_SOH" disable row movement;
alter table "SYSMAN"."XX_ACI_SKURTP" enable row movement;
alter table "SYSMAN"."XX_ACI_SKURTP" shrink space compact;
alter table "SYSMAN"."XX_ACI_SKURTP" disable row movement;
hi,
I want to combine two lines in same file. If the line ends with '&' it should belongs to previous line only
Here i am writing example.
Ex1:
line 1 : return abcdefgh&
line 2 : ijklmnopqr&
line 3 : stuvw&
line 4 : xyz
output should be
line 1: return abcdefghijklmnopqrstuvwxyz
... (11 Replies)
I'm rather new to programming, and am attempting to combine lines from 2 files in a way that is way beyond my expertise - any help would be appreciated!
I need to take a file (file1) and add columns to it from another file (file2). However, a line from file2 should only be added to a given line... (3 Replies)
Hi All,
I need to find and list the last 5 days files in that exact name with "MIM" and copy to another directory.
please help me in this there is around 30000 files
Thanks
Murali (7 Replies)
Hi Gurus,
I need to list only the files with out certain extension.
For eg from the following list of files:
I need to only list:
Thanks
Shash (7 Replies)
Hi all
I am trying to loop through a directory of files using a given search pattern. some of the files will be duplicated due to the pattern, but of the duplicate files i wanted to move the older files to another location.
Is there any straightforward way of doing this ?
One of ways I... (1 Reply)
Hi All,
I need to find all files in a directory which are containing specific pattern. Thing is that file name should not consider if pattern is only in commented area.
all contents which are under /* */ are commented
all lines which are starting with -- or if -- is a part of some sentence... (13 Replies)
I have to create a new CSV file based on the value listed on the 3rd column from different CSV files. This is what I need:
1. I should substitute the first column from each file, excluding the headers, with the file name InputXX.
2. Then, I need to look for rows with 0 on the third column in... (7 Replies)
Discussion started by: Xterra
7 Replies
LEARN ABOUT DEBIAN
alzabo::runtime::uniquerowcache
Alzabo::Runtime::UniqueRowCache(3pm) User Contributed Perl Documentation Alzabo::Runtime::UniqueRowCache(3pm)NAME
Alzabo::Runtime::UniqueRowCache - Implements a row cache for Alzabo
SYNOPSIS
use Alzabo::Runtime::UniqueRowCache;
Alzabo::Runtime::UniqueRowCache->clear();
DESCRIPTION
This is a very simple caching mechanism for "Alzabo::Runtime::Row" objects that tries to ensure that for there is never more than one row
object in memory for a given database row.
To use it, simply load it.
It can be foiled through the use of "Storable" or other "deep magic" cloning code, like in the "Clone" module.
The cache is a simple hash kept in memory. If you use this module, you are responsible for clearing the cache as needed. The only time it
is cleared automatically is when a table update or delete is performed, in which case all cached rows for that table are cleared.
In a persistent environment like mod_perl, you should clear the cache on a regular basis in order to prevent the cache from getting out of
sync with the database. A good way to do this is to clear it at the start of every request.
METHODS
All methods provided are class methods.
* clear
This clears the entire cache
* clear_table( $table_object )
Given a table object, this method clears all the cached rows from that table.
* row_in_cache( $table_name, $row_id )
Given a table name and a row id, as returned by the "Alzabo::Runtime::Row->id_as_string" method, this method returns the matching row
from the cache, if it exists. Otherwise it returns undef.
* delete_from_cache( $table_name, $row_id )
Given a table name and a row id, as returned by the "Alzabo::Runtime::Row->id_as_string" method, this method returns the matching row
from the cache.
* write_to_cache( $row_object )
Given a row object, this method stores it in the cache.
AVOIDING THE CACHE
If you want to not cache a row, then you can pass the "no_cache" parameter to any table or schema method that creates a new row object or a
cursor, such as "Alzabo::Runtime::Table->insert()", "Alzabo::Runtime::Table->rows_where()".
AUTHOR
Dave Rolsky, <autarch@urth.org>
perl v5.8.8 2007-12-23 Alzabo::Runtime::UniqueRowCache(3pm)