I know;if delimeter would have been there it would have been peice of cake --
@ygemici,any idea how to put double quotes around column 2 and column 4
try this
Code:
# sed '/^-\|^$/d;$!s/\([^ ]*\) \([^ ]* [^ ]* [^ ]* [^ ]*\) \([^ ]*\) \(.*\)/"\1" "\2" "\3" "\4"/
;$s/\([^ ]*\) \([^ ]* [^ ]* [^ ]*\) \([^ ]*\) \(.*\)/"\1" "\2" "\3" "\4"/' data
"WFI001" "Xxxxxx Control Work Item" "A" "Number of Records"
"WFI001" "Xxxxxx Control Work Item" "B" "Count of Distinct Hook Id"
"WFI001" "Xxxxxx Control Work Item" "C" "Sum of Workitem Num"
"WFI008" "Xxxxxx Control DocTABA" "A" "Number of Records"
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)
I have a fixed length file that need to be sorted according to the following rule
IF B=1 ORDER by A,B
Else ORDER by A,C
Input file is
ABC
131
112
122
231
212
222
Output needed
ABC
112
131
122
212
231
222 (1 Reply)
Hi All,
So far, I've been extracting data from db2 tables and exporting the file as a tab delimited file into a UNIX server using the following command:
export to /.../.../.../.../.../SM_RAW_DATA.dat of del modified by coldel| nochardel
select a.accno,
a.CUR_BL_AM, ... (1 Reply)
Hi Gurus,
Thanks in advance...
I am new to writing shell scripting and help me out reading a flat file with fixed length.
I have a fixed length flat file with storename(lenth 6) , emailaddress(lenth 15), location(10). There is NO delimiters in that file.
Like the following str00001.txt... (2 Replies)
I am new to shell scripting and I have to to the following
I have a flat file with storename(lenth 20) , emailaddress(lenth 40), location(15). There is NO delimiters in that file.
Like the following str00001.txt
StoreName emailaddress location... (3 Replies)
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)
I have 150 files with 4 columns each but variable row lengths that I need to combine by column. I do not have any common column. I want to use "paste " command in unix to do it but before that I have to get all my files to be of equal length.
Is there a way using awk or sed to fill up n no. of... (7 Replies)
Hii ,I am new to Unix ,i have a flat file which is (fixed length) sitting in unix,Which is holding the data for a table.I want to extract one column(length7-10) on the basis of another column(length13-15) and want only one single row
Example:
Below is the sample of flat file.
1111 AAAA 100 ... (4 Replies)
Hi,
We receive flat files with fixed width data
Now our goal is append from right null or space to each record if the lenght of the record is less than for example 10.
for example
123 45 6 0
123 45
123 45 6
123
and output should be
123 45 6 0
123 45****
123 45 6**... (7 Replies)
Discussion started by: shharrath
7 Replies
LEARN ABOUT OPENSOLARIS
exacct::object::item
Exacct::Object::Item(3PERL) Perl Library Functions Exacct::Object::Item(3PERL)NAME
Exacct::Object::Item - exacct item manipulation
SYNOPSIS
use Sun::Solaris::Exacct::Object;
my $ea_item = Sun::Solaris::Exacct::Object::Item->new(
&EXT_UINT64 | &EXC_DEFAULT | &EXD_PROC_PID, $$);
DESCRIPTION
This module is used for manipulating libexacct(3LIB) data Items. A libexacct Item is represented as an opaque reference blessed into the
Sun::Solaris::Exacct::Object::Item class, which is a subclass of the Sun::Solaris::Exacct::Object class. The underlying libexacct data
types are mapped onto Perl types as follows:
libexacct type Perl internal type
EXT_UINT8 IV (integer)
EXT_UINT16 IV (integer)
EXT_UINT32 IV (integer)
EXT_UINT64 IV (integer)
EXT_DOUBLE NV (double)
EXT_STRING PV (string)
EXT_RAW PV (string)
EXT_EXACCT_OBJECT Sun::Solaris::Exacct::Object subclass
Constants
None.
Functions
None.
Class methods
Class methods include those inherited from the Sun::Solaris::Exacct::Object base class, plus the following:
new($catalog, $value) This method creates and returns a new Sun::Solaris::Exacct::Object::Item. The catalog tag can be either an integer
or a Sun::Solaris::Exacct::Catalog. This catalog tag controls the conversion of the Perl value to the correspond-
ing Perl exacct data type as described in the table above. If the catalog tag has a type field of
EXT_EXACCT_OBJECT, the value must be a reference to either an Item or a Group object and the passed object is
recursively copied and stored inside the new Item. Because the returned Item is constant, it is impossible, for
example, to create an Item representing CPU seconds and subsequently modify its value or change its catalog value.
This behavior is intended to prevent mismatches between the catalog tag and the data value.
Object methods
Object methods are those inherited from the Sun::Solaris::Exacct::Object.
Exports
None.
ATTRIBUTES
See attributes(5) for descriptions of the following attributes:
+-----------------------------+-----------------------------+
| ATTRIBUTE TYPE | ATTRIBUTE VALUE |
+-----------------------------+-----------------------------+
|Availability |SUNWpl5u |
+-----------------------------+-----------------------------+
|Interface Stability |Evolving |
+-----------------------------+-----------------------------+
SEE ALSO Exacct(3PERL), Exacct::Catalog(3PERL), Exacct::File(3PERL), Exacct::Object(3PERL), Exacct::Object::Group(3PERL), libexacct(3LIB),
attributes(5)SunOS 5.11 1 Dec 2002 Exacct::Object::Item(3PERL)