05-01-2009
I've give you an example, since data is senstive. It is a fixed width file downloaded from Mainframe via FTP. This is the what the file would look like (in Unix Env).
Col1 Char5
Col2 Char5
Col3 Char20
Col4 Char5
Expected Format:
12345abcdeMy name is Jack SmitSVY01
Actual Format
12345abcdMy name is
Jack SmitSVY01
There was an embedded (\n) after "My name is" and automatically forced a new line...furthermore, each record has a (\n) as its record delimter (not visibly shown).
I would like to remove the embedded LF (\n) BUT not the record delimiter.
Thanks
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I have a fixed width flatfile with 5 columns, i will load file from oracle database to the flatfile for every 15 min at the end of the file, i want to insert a record by calling a shell script for inserting a record.
please can any one help me.
Thanks. (1 Reply)
Discussion started by: limou
1 Replies
2. UNIX Desktop Questions & Answers
I am trying to parse a Fixed width file with data as below. I am trying to assign column values from each record to variables. When I parse the data, the spaces in all coumns are dropped. I would like to retain the spaces as part of the dat stored in the variables. Any help is appreciated.
I... (4 Replies)
Discussion started by: sate911
4 Replies
3. Shell Programming and Scripting
Hi champs!
I have a fixed width file in which the records appear like this
11111 <fixed spaces such as 6> description for 11111 <fixed spaces such as 6> some more field to the record of 11111
22222 <fixed spaces such as 6> description for 22222 <fixed spaces such as 6> some more field to the... (8 Replies)
Discussion started by: enigma_1
8 Replies
4. Shell Programming and Scripting
Hi everyone,
I have been working on a pretty laborious shellscript (with bash) the last couple weeks that parses my firewall policies (from a Juniper) for me and creates a nifty little columned output. It does so using awk on a line by line basis to pull out the appropriate pieces of each... (4 Replies)
Discussion started by: cixelsyd
4 Replies
5. Shell Programming and Scripting
Hi All,
I have created a script which generates FIXED-WIDTH file by executing Oracle query.
SELECT RPAD(NVL(col1,CHR(9)),20)||NVL(col2,CHR(9))||NVL(col3,CHR(9) FROM XYZ
It generates the data file with proper alignment. But if same file i transfer to windows server or Mainframe... (5 Replies)
Discussion started by: Amit.Sagpariya
5 Replies
6. Shell Programming and Scripting
Hi Guys
I am checking the treads to get the answer but i am not able to get the answer for my question.
I have two files. First file is a pattern file and the second file is the file i want to search in it. Output will be the lines from file2.
File1:
P2797f12af 44751228... (10 Replies)
Discussion started by: anshul_er
10 Replies
7. Shell Programming and Scripting
Hi there,
CTL Port IO Rate(IOPS) Read Rate(IOPS) Write Rate(IOPS) Read Hit(%) Write Hit(%) Trans. Rate(MB/S) Read Trans. Rate(MB/S) Write Trans. Rate(MB/S) 09:36:48
0 A 136 0 135 97 100 ... (6 Replies)
Discussion started by: gray380
6 Replies
8. UNIX for Advanced & Expert Users
actually i am trying to find the lenght of fixed width file record reading from teradata db but its not working can u guys help me out?
code which i wrote---
colmn_lngth=`cat $RPT_FILE | awk -F~ '{print $1}'`
rm $RPT_FILE
while read line
do
result=`echo $line | wc -m`
... (4 Replies)
Discussion started by: Seshendranath
4 Replies
9. Shell Programming and Scripting
Hi All ,
I have a requirement where I need to remove duplicates from a fixed width file which has multiple key columns .Also , need to capture the duplicate records into another file .
File has 8 columns.
Key columns are col1 and col2.
Col1 has the length of 8 col 2 has the length of 3.
... (5 Replies)
Discussion started by: saj
5 Replies
10. Shell Programming and Scripting
Hi All,
I need to join fixed width files on a column which is position 1 to 3 and need to have all the records from file1
file1.txt
Cu1nullL1L2
Cu2nullL1L2
Cu3nullL1L2
file2.txt
Cu1B1B2
Cu3B1B2
output.txt
Cu1L1B1L2B2
Cu2L1L2
Cu3L1B1L2B3
I tried but not getting the expected... (12 Replies)
Discussion started by: shash
12 Replies
LEARN ABOUT DEBIAN
html::microformats::format::hcard
HTML::Microformats::Format::hCard(3pm) User Contributed Perl Documentation HTML::Microformats::Format::hCard(3pm)
NAME
HTML::Microformats::Format::hCard - the hCard microformat
SYNOPSIS
use HTML::Microformats::DocumentContext;
use HTML::Microformats::Format::hCard;
my $context = HTML::Microformats::DocumentContext->new($dom, $uri);
my @cards = HTML::Microformats::Format::hCard->extract_all(
$dom->documentElement, $context);
foreach my $card (@cards)
{
print $card->get_fn . "
";
}
DESCRIPTION
HTML::Microformats::Format::hCard inherits from HTML::Microformats::Format. See the base class definition for a description of property
getter/setter methods, constructors, etc.
Additional Method
o "to_vcard"
This method exports the hCard as a vCard 3.0. It requires RDF::vCard to work, and will throw an error at run-time if it's not
available.
o "to_vcard4"
This method exports the hCard as a vCard 3.0. It requires RDF::vCard to work, and will throw an error at run-time if it's not
available.
o "to_vcard4_xml"
This method exports the hCard as a vCard XML. It requires RDF::vCard and XML::LibXML to work, and will throw an error at run-time if
it's not available.
MICROFORMAT
HTML::Microformats::Format::hCard supports hCard as described at <http://microformats.org/wiki/hcard>, with the following additions:
o vCard 4.0 terms
This module includes additional property terms taken from the latest vCard 4.0 drafts. For example the property 'impp' may be used to
mark up instant messaging addresses for a contact.
The vCard 4.0 property 'kind' is used to record the kind of contact described by the hCard (an individual, an organisation, etc). In
many cases this is automatically inferred.
o Embedded species microformat
If the species microformat (see HTML::Microformats::Format::species) is found embedded within an hCard, then this is taken to be the
species of a contact.
o Embedded hMeasure
If the hMeasure microformat (see HTML::Microformats::Format::hMeasure) is found embedded within an hCard, and no 'item' property is
provided, then the measurement is taken to pertain to the contact described by the hCard.
RDF OUTPUT
Data is returned using the W3C's vCard vocabulary (<http://www.w3.org/2006/vcard/ns#>) with some supplemental terms from Toby Inkster's
vCard extensions vocabulary (<http://buzzword.org.uk/rdf/vcardx#>) and occasional other terms.
After long deliberation on the "has-a/is-a issue", the author of this module decided that the holder of a vCard and the vCard itself should
be modelled as two separate resources, and this is how the data is returned. Some information about the holder of the vCard can be inferred
from information about the vCard; for instance, the vCard's fn property can be used to determin the holder's foaf:name. This module uses
FOAF (<http://xmlns.com/foaf/0.1/>) to represent information about the holder of the vCard.
BUGS
Please report any bugs to <http://rt.cpan.org/>.
SEE ALSO
HTML::Microformats::Format, HTML::Microformats.
AUTHOR
Toby Inkster <tobyink@cpan.org>.
COPYRIGHT
Copyright 2008-2011 Toby Inkster
This library is free software; you can redistribute it and/or modify it under the same terms as Perl itself.
DISCLAIMER OF WARRANTIES
THIS PACKAGE IS PROVIDED "AS IS" AND WITHOUT ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, WITHOUT LIMITATION, THE IMPLIED WARRANTIES OF
MERCHANTIBILITY AND FITNESS FOR A PARTICULAR PURPOSE.
perl v5.14.2 2011-12-06 HTML::Microformats::Format::hCard(3pm)