11-04-2008
parsing filenames
How can I loose a part of the filename
I want to drop the “_<Number>.sql”
Below I have a listing of file names in a file
Eg :
CREDIT_DEL_033333.sql I want it to be CREDIT_DEL
ATM_DEBIT_CARD_0999999.sql I want it to be ATM_DEBIT_CARD
DELCC_1234567.sql I want it to be DELCC
ALL_CR_DB_TRANS_444444444444.sql ALL_CR_DB_TRANS
ALL_CR_10_TRANS_444444444444.sql ALL_CR_10_TRANS
Any help is appreciated.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,:cool:
I have a list of files in a directory.I need to store them in a file with the prefix of @ by using a command..
ex:@p_po.plb
@p_ebiz_roster_data.plb
any idea pls.
cheers
RRK (2 Replies)
Discussion started by: ravi raj kumar
2 Replies
2. Shell Programming and Scripting
#! /usr/local/bin/perl -w
$ip = "$ARGV";
$rw = "$ARGV";
$snmpg = "/usr/local/bin/snmpbulkget -v2c -Cn1 -Cn2 -Os -c $rw";
$snmpw = "/usr/local/bin/snmpwalk -Os -c $rw";
$syst=`$snmpg $ip system sysName sysObjectID`;
sysDescr.0 = STRING: Cisco Internetwork Operating System Software... (1 Reply)
Discussion started by: popeye
1 Replies
3. UNIX for Dummies Questions & Answers
Using a small script, I automatically generated some text logs. The files ended being undownloadable, unopenable and undeletable. Upon further investigation, the files ended up looking like this:
log\r
log2\r
log3\r
I've tried a few different things, including double slashing before the... (6 Replies)
Discussion started by: shepherdsflock
6 Replies
4. Shell Programming and Scripting
I tried using the following options to parse the *.sh files in a dir
(the name can contain spaces). But each of them breaks:
FILESSH=$(ls /mysh/*.sh)
echo "$FILESSH" | while read FILE ; do --- do something --; done
This does not break for any whitespaces in filenames
for FILE in... (1 Reply)
Discussion started by: amicon007
1 Replies
5. Shell Programming and Scripting
Hey guys,
I have this file generated by me... i want to create some HTML output from it.
The problem is that i am really confused about how do I go about reading the file.
The file is in the following format:
TID1 Name1 ATime=xx AResult=yyy AExpected=yyy BTime=xx BResult=yyy... (8 Replies)
Discussion started by: umar.shaikh
8 Replies
6. Shell Programming and Scripting
Hi
I need to pull out the name of the file from the path.
See, here is my loop that gets the files:
dsxdir="/var/local/dsx/import"
for dsxfile in $dsxdir/*.dsx;
do
dsxlog $reverb --info --module="$module" "$dsxfile"
$dsximp $norule $oprange --dsn=$dsn --dbname=$dbname... (6 Replies)
Discussion started by: ladyAnne
6 Replies
7. UNIX for Dummies Questions & Answers
I have 7 files with 7 different names coming into a specified folder on weekly basis, i need to pick a file one after another and load into oracle table using sql loader. I am using ksh to do this. So in the process if the file has error records and if sql loader fails to load into oracle tables,... (0 Replies)
Discussion started by: vpv0002
0 Replies
8. Shell Programming and Scripting
Hi,
Its been a long time since I've done any shell scripting and I need some help here. Thanks in advance...
I need this as a bourne or csh script running under SCO.
In a folder I have a list of Backup files named with "TarBackup plus a date and time component suffix" like this;
... (2 Replies)
Discussion started by: stanlyn
2 Replies
9. UNIX for Dummies Questions & Answers
I have requirement of parsing file names from given directory based on the pattern ( pattern will be parameter to script and can be any ).
for example, user enterred 2 params :
directory name : /dirname/
filename_pattern : *.dat_????
and there are 2 files in the directory as... (1 Reply)
Discussion started by: freakabhi
1 Replies
10. UNIX for Beginners Questions & Answers
Hello Unix experts:
I have dir where few files are there, i want to sort these files and write the output to some other file but i need filenames with filepath too
eg:
i have filenames like
010020001_S-FOR-Sort-SYEXC_20171218_094256_0004.txt
so i want to sort my files on first 5 fields of... (2 Replies)
Discussion started by: gnnsprapa
2 Replies
LEARN ABOUT PHP
db2_lob_read
DB2_LOB_READ(3) 1 DB2_LOB_READ(3)
db2_lob_read - Gets a user defined size of LOB files with each invocation
SYNOPSIS
string db2_lob_read (resource $stmt, int $colnum, int $length)
DESCRIPTION
Use db2_lob_read(3) to iterate through a specified column of a result set and retrieve a user defined size of LOB data.
PARAMETERS
o $stmt
- A valid stmt resource containing LOB data.
o $colnum
- A valid column number in the result set of the stmt resource.
o $length
- The size of the LOB data to be retrieved from the stmt resource.
RETURN VALUES
Returns the amount of data the user specifies. Returns FALSE if the data cannot be retrieved.
EXAMPLES
Example #1
Iterating through different types of data
<?php
/* Database Connection Parameters */
$db = 'SAMPLE';
$username = 'db2inst1';
$password = 'ibmdb2';
/* Obtain Connection Resource */
$conn = db2_connect($db,$username,$password);
if ($conn) {
$drop = 'DROP TABLE clob_stream';
$result = @db2_exec( $conn, $drop );
$create = 'CREATE TABLE clob_stream (id INTEGER, my_clob CLOB)';
$result = db2_exec( $conn, $create );
$variable = "";
$stmt = db2_prepare($conn, "INSERT INTO clob_stream (id,my_clob) VALUES (1, ?)");
$variable = "THIS IS A CLOB TEST. THIS IS A CLOB TEST.";
db2_bind_param($stmt, 1, "variable", DB2_PARAM_IN);
db2_execute($stmt);
$sql = "SELECT id,my_clob FROM clob_stream";
$result = db2_prepare($conn, $sql);
db2_execute($result);
db2_fetch_row($result);
$i = 0;
/* Read LOB data */
while ($data = db2_lob_read($result, 2, 6)) {
echo "Loop $i: $data
";
$i = $i + 1;
}
$drop = 'DROP TABLE blob_stream';
$result = @db2_exec( $conn, $drop );
$create = 'CREATE TABLE blob_stream (id INTEGER, my_blob CLOB)';
$result = db2_exec( $conn, $create );
$variable = "";
$stmt = db2_prepare($conn, "INSERT INTO blob_stream (id,my_blob) VALUES (1, ?)");
$variable = "THIS IS A BLOB TEST. THIS IS A BLOB TEST.";
db2_bind_param($stmt, 1, "variable", DB2_PARAM_IN);
db2_execute($stmt);
$sql = "SELECT id,my_blob FROM blob_stream";
$result = db2_prepare($conn, $sql);
db2_execute($result);
db2_fetch_row($result);
$i = 0;
/* Read LOB data */
while ($data = db2_lob_read($result, 2, 6)) {
echo "Loop $i: $data
";
$i = $i + 1;
}
} else {
echo 'no connection: ' . db2_conn_errormsg();
}
?>
The above example will output:
Loop 0: THIS I
Loop 1: S A CL
Loop 2: OB TES
Loop 3: T. THI
Loop 4: S IS A
Loop 5: CLOB
Loop 6: TEST.
Loop 0: THIS I
Loop 1: S A BL
Loop 2: OB TES
Loop 3: T. THI
Loop 4: S IS A
Loop 5: BLOB
Loop 6: TEST.
SEE ALSO
db2_bind_param(3), db2_exec(3), db2_execute(3), db2_fetch_row(3), db2_prepare(3), db2_result(3).
PHP Documentation Group DB2_LOB_READ(3)