09-02-2012
Adding a delimiter to a variable length file
Hi,
Many thanks for the response. i'm able to get the desired output. but i have a question. i need to write this in .ksh file, wouldn't i need to write a do while loop? bcoz i have some 80k records in the file. Would the command check all the lines?
don't mistake me if i wrong anywhere..
Regards,
Mohankumar.V
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Is there a command that sets a variable length?
I have a input of a variable length field but my output for that field needs to be set to 32 char.
Is there such a command?
I am on a sun box running ksh
Thanks (2 Replies)
Discussion started by: r1500
2 Replies
2. Shell Programming and Scripting
Hi ,
I have a file :
CSCH74000.00
CSCH74000.00
CSCH74100.00
CSCH74000.00
CSCH74100.00
CSCH74000.00
CSCH74000.00
CSCH74100.00
CSCH74100.00
CSCH74100.00
I have to put a delimiter( say comma) in between after 6th character:
CSCH74,000.00
CSCH74,000.00
CSCH74,100.00 (2 Replies)
Discussion started by: sumeet
2 Replies
3. Shell Programming and Scripting
Hi experts.
I got a file (500mb max) and need to pivot it (loading into ORCL) and change BLANK delimiter to PIPE |.
Sometimes there are multipel BLANKS (as a particular value may be BLANK, or simply two BLANKS instead of one BLANK).
thanks for your input!
Cheers,
Layout... (3 Replies)
Discussion started by: thomasr
3 Replies
4. UNIX for Dummies Questions & Answers
Hi, all.
I need to convert a file tab delimited/variable length file in AIX to a fixed lenght file delimited by spaces. This is the input file:
10200002<tab>US$ COM<tab>16/12/2008<tab>2,3775<tab>2,3783
19300978<tab>EURO<tab>16/12/2008<tab>3,28523<tab>3,28657
And this is the expected... (2 Replies)
Discussion started by: Everton_Silveir
2 Replies
5. Shell Programming and Scripting
Im writing a KSH script to read a simple text file and add a delimiter. Ive written the following script but it runs very slow. I initially used the cut command to substring the input record then switched to this version using awk to substring... both run too slow. Any ideas how to make this more... (2 Replies)
Discussion started by: lock
2 Replies
6. Shell Programming and Scripting
Very, very new to unix scripting and have a unique situation. I have a file of records that contain 3 records types:
(H)eader Records
(D)etail Records
(T)railer Records
The Detail records are 82 bytes in length which is perfect. The Header and Trailer records sometimes are 82 bytes in... (3 Replies)
Discussion started by: jclanc8
3 Replies
7. Shell Programming and Scripting
Dear all,
I have basic knowledge of Unix script and her I am trying to process variable length and variable format CSV file.
The file length will depend on the numbers of Earnings/Deductions/Direct Deposits.
And
The format will depend on whether it is Earnings/Deductions or Direct Deposits... (2 Replies)
Discussion started by: chechun
2 Replies
8. Shell Programming and Scripting
Hi,
Can anyone help with a effective solution ?
I need to change a variable length text field (between 1 - 18 characters) to a fixed length text of 18 characters with the unused portion, at the end, filled with spaces.
The text field is actually field 10 of a .csv file however I could cut... (7 Replies)
Discussion started by: dc18
7 Replies
9. Shell Programming and Scripting
Hi,
I have a No Delimiter variable length text file with following schema -
Column Name Data length
Firstname 5
Lastname 5
age 3
phoneno1 10
phoneno2 10
phoneno3 10
sample data - ... (16 Replies)
Discussion started by: Gaurav Martha
16 Replies
10. Shell Programming and Scripting
Hi Team,
I have an issue to split the file which is having special chracter(German Char) using awk command.
I have a different length records in a file. I am separating the files based on the length using awk command.
The command is working fine if the record is not having any... (7 Replies)
Discussion started by: Anthuvan
7 Replies
LEARN ABOUT DEBIAN
sru::response::searchretrieve
SRU::Response::SearchRetrieve(3pm) User Contributed Perl Documentation SRU::Response::SearchRetrieve(3pm)
NAME
SRU::Response::SearchRetrieve - A class for representing SRU searchRetrieve responses
SYNOPSIS
## create response from the request object
my $response = SRU::Response::SearchRetrieve->new( $request );
## add records to the response
foreach my $record ( @records ) { $response->addRecord( $record ); }
## print out the response as XML
print $response->asXML();
DESCRIPTION
SRU::Response::SearchRetrieve provides a framework for bundling up the response to a searchRetrieve request. You are responsible for
generating the XML representation of the records, and the rest should be taken care of.
METHODS
new()
numberOfRecords()
Returns the number of results associated with the object.
addRecord()
Add a SRU::Response::Record object to the response.
$response->addRecord( $r );
If you don't pass in the right sort of object you'll get back undef and $SRU::Error will be populated appropriately.
records()
Gets or sets all the records associated with the object. Be careful with this one :) You must pass in an array ref, and expect an array ref
back.
resultSetId()
resultSetIdleTime()
nextRecordPosition()
diagnostics()
extraResponseData()
echoedSearchRetrieveRequest()
asXML()
asXML(encoding=>"ISO-8859-1")
Returns the object serialized as XML. UTF-8 and UTF-16 are default encodings if you don't pass the encoding parameter. You can define
different encoding in order to parse you XML document correctly.
perl v5.12.4 2009-11-20 SRU::Response::SearchRetrieve(3pm)