The answer depends of the key length (first column of file2).
If keys are fixed length, there is no problem to invert the logic.
If keys are variable length, the header and records from file1 will be memorized in a array indexed by record number, we can't use another index because we don't know what part of the record is the key.
For each extraction specified in file 2, we will scan sequentially the array until we found the right record (more time consuming).
I have a flat file and need to count no of records in the file less the header and the trailer record.
I would appreciate any and all asistance
Thanks
Hadi Lalani (2 Replies)
hello mates.
please help me out once again.
i have a html file where i want to fetch out one value from the entire html-code
sample html code:
.....
<b>Amount:<b> 12345</div>
...
now i only want to fetch the 12345 from the html document.
how to i tell sed to get me the value from... (2 Replies)
Hi guys,
Please help me out in this problem. I have two files
FILE1
abc-23 : 4529675
cde-42 : 9824532
dge-91 : 1245367
gre-45 : 9824532
fgr-76 : 4529675
FILE2
4529675 : Gal Glu house-2-be
9824532 : cat mouse
1245367 : sirf surf-2-beta
where FILE2 is a static file with fixed... (5 Replies)
Hi
I am working on a script which needs to scan a sequential file and fetch the row where 2nd column = 'HUB'
Can any one help me with this...
Thanks (1 Reply)
Hi,
I have a task where i need to scan second column of seuential file and fetch first 3 digits of that column
For e.g. FOLLOWING IS THE SAMPLE FOR MY SEQUENTIAL FILE
AU_ID ACCT_NUM CRNCY_CDE
THHSBC001 30045678 THB
THHSBC001 10154267 THB
THHSBC001 ... (2 Replies)
Hi everyone.
I am a newbie to Linux stuff. I have this kind of problem which couldn't solve alone. I have a text file with records separated by empty lines like this:
ID: 20
Name: X
Age: 19
ID: 21
Name: Z
ID: 22
Email: xxx@yahoo.com
Name: Y
Age: 19
I want to grep records that... (4 Replies)
Hello All,
I am working on a script where I need to fetch the value from a log file and log file creates with different name but few thing are common
DEV_INFOMGT161_MULTI_PTC_BLD01.Stage_All_to_stp2perf1.042312114644.log
STP_12_02_01_00_RC01.Stage_stp-domain_to_stp2perf2.042312041739.log
... (2 Replies)
I have 2 files
"File 1" is delimited by ";" and "File 2" is delimited by "|".
File 1 below (3 record shown):
Doc1;03/01/2012;New York;6 Main Street;Mr. Smith 1;Mr. Jones
Doc2;03/01/2012;Syracuse;876 Broadway;John Davis;Barbara Lull
Doc3;03/01/2012;Buffalo;779 Old Windy Road;Charles... (2 Replies)
Hi I am new to shell programming in unix
Please if I can provide help.
I have a file structure of a header record and "N" detail records.
The header record will be the total number of detail records
I need to split the file in 2:
One for the header
Another for all detail records
Could... (1 Reply)
awk 'NR==FNR{arr;next} $0 in arr' /tmp/Data_mismatch.sh /prd/HK/ACCTCARD_20160115.txt
edit by bakunin: seems that one CODE-tag got lost somewhere. i corrected that, but please check your posts more carefully. Thank you. (5 Replies)
Discussion started by: suresh_target
5 Replies
LEARN ABOUT PHP
px_get_record
PX_GET_RECORD(3)PX_GET_RECORD(3)px_get_record - Returns record of paradox databaseSYNOPSIS
array px_get_record (resource $pxdoc, int $num, [int $mode])
DESCRIPTION PARAMETERS
o $pxdoc
- Resource identifier of the paradox database as returned by px_new(3).
o $num
- The record number is an artificial number counting records in the order as they are stored in the database. The first record has
number 0.
o $mode
- The optional $mode can be PX_KEYTOLOWER or PX_KEYTOUPPER in order to convert the keys of the returned array into lower or upper
case. If $mode is not passed or is 0, then the key will be exactly like the field name. The element values will contain the field
values. NULL values will be retained and are different from 0.0, 0 or the empty string. Fields of type PX_FIELD_TIME will be
returned as an integer counting the number of milliseconds starting at midnight. A timestamp ( PX_FIELD_TIMESTAMP) and date (
PX_FIELD_DATE) are floating point respectively int values counting milliseconds respectively days starting at the beginning of
julian calendar. Use the functions px-timestamp2string(3) and px-date2string(3) to convert them into a character representation.
RETURN VALUES
Returns the $num'th record from the paradox database. The record is returned as an associated array with its keys being the field names.
SEE ALSO px_retrieve_record(3).
PHP Documentation Group PX_GET_RECORD(3)