04-06-2009
Merge lines in Flat file based on first 5 characters
Hi
I have the fixed width flat file having the following data
12345aaaaaaaaaabbbbbbbbbb
12365sssssssssscccccccccc
12365sssss
12367ddddddddddvvvvvvvvvv
12367 vvvvv
Here the first column is length 5 second is length 10 third is length 10
if the second or third column exceeds length it is repeated in next line with the first column repeated
Now I need the file to be modified in such a way that there is only one row for the data like
12345aaaaaaaaaa bbbbbbbbbb
12365sssssssssssssss cccccccccc
12367dddddddddd vvvvvvvvvvvvvvv
changing the lenght of the second and third column to 20 instead of 10.
I am trying to write this in perl or shell.
Kindly help me..
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
I have a tab delimited flat file like this: 189 Guide de lutilisateur sur lappel conférence à trois au moyen d'adaptateurs téléphoniques <TABLE><TBODY><TR><TD><DIV class=subheader>La fonction Appel conférence à trois </DIV></TD>
\
<TD><?php print $navTree;?> vous permet de tenir un appel... (4 Replies)
Discussion started by: hnhegde
4 Replies
2. Shell Programming and Scripting
The symbols are \t and \t\t (note: not tab)
If the line starts with \t merge them into a single line upto symbol \t\t
\t\t to end and start new line
I able to join in a single line but not ending at \t\t and I completely confused
help would be appreciated:b::D
Input
\ta tab XXXXXXXXXX
\te... (5 Replies)
Discussion started by: repinementer
5 Replies
3. Shell Programming and Scripting
Hello,
I have searched forum trying to find a solution to my problem, but could not find anything or I did not understand the examples....
I should say, I am very inexperienced with text processing.
I have a text file with approx 60k lines in it.
I need to merge lines based on the number... (8 Replies)
Discussion started by: Bertik
8 Replies
4. Shell Programming and Scripting
Hi, I have a bash script and I am looking for a command that will merge specific lines together.
Sample Data:
registration time = 1300890272
Id = 1
setd = 0
tagunt = 26
tagId=6, length=8, value=
tagId=9, length=5, value=
tagId=7, length=2, value=
tagId=16, length=2, value=
tagId=32,... (8 Replies)
Discussion started by: Winsarc
8 Replies
5. Shell Programming and Scripting
Hello Everyone,
I have two files I created in a format similar to the ones found below (character position is important):
File 1:
21 Cat Y N S Y Y N N
FOUR LEGS
TAIL
WHISKERS
30 Dog N N 1 Y Y N N
FOUR LEGS
TAIL
33 Fish Y N 1 Y Y N N
FINS
43 CAR Y N S Y Y N N
WHEELS
DOORS... (7 Replies)
Discussion started by: jl487
7 Replies
6. Shell Programming and Scripting
Hello Everyone,
I have two files, similar to the following:
File 1:
8010 ITEM01 CODE1 FLAG1
filler
filler
7020 OBJECT CODE2 FLAG2
filler
6010 THING1 CODE4 FLAG4
6011 ITEM20 CODE7 FLAG7
File 2 contains:
6020 ITEM01 CODEA FLAGA
filler
filler
filler
7000 OBJECT CODEB... (2 Replies)
Discussion started by: jl487
2 Replies
7. Shell Programming and Scripting
Hi,
I have a requirement to merge multiple lines based on search pattern. The search criteria is : it will search for CONSTRAINT and when it found CONSTRAINT, it will merge all lines to 1 line till it founds blank line.
For Example:
CREATE TABLE "AMS_DISTRIBUTOR_XREF"
(
"SOURCE"... (5 Replies)
Discussion started by: satyaatcgi
5 Replies
8. Shell Programming and Scripting
Hi,
trying to knock something together to create one line entries based on whether the first word on each line matches a particular value.
eg.
Link,"Name=""Something\something"","Timeout=""1800""",
"Target=""\\thing\thing\thing""","State=""ONLINE""",something,... (0 Replies)
Discussion started by: adamdb
0 Replies
9. Shell Programming and Scripting
I am trying to merge two lines to one based on some matching condition.
The file is as follows:
Matches filter:
'request ', timestamp, <HTTPFlow
request=<GET:
Matches filter:
'request ', timestamp, <HTTPFlow
request=<GET:
Matches filter:
'request ', timestamp, <HTTPFlow
... (8 Replies)
Discussion started by: jamie_123
8 Replies
10. Shell Programming and Scripting
Hi, I have a large set of data (firewall logs) that I'm trying to summarize. I've been able to write a script to consolidate the ports, now am looking to conslidate even further, based on IP.
Source Destination Type Port
192.168.5.108 192.168.11.12 TCP 1, 2, 3, 4, 5, 15
192.168.5.109... (6 Replies)
Discussion started by: umang2382
6 Replies
LEARN ABOUT DEBIAN
alzabo::create::columndefinition
Alzabo::Create::ColumnDefinition(3pm) User Contributed Perl Documentation Alzabo::Create::ColumnDefinition(3pm)
NAME
Alzabo::Create::ColumnDefinition - Column definition object for schema creation
SYNOPSIS
use Alzabo::Create::ColumnDefinition;
DESCRIPTION
This object holds information on a column that might need to be shared with another column. The reason this class exists is that if a col-
umn is a key in two or more tables, then some of the information related to that column should change automatically in multiple places
whenever it changes at all. Right now this is only type ('VARCHAR', 'NUMBER', etc) and length/precision information. This object also has
an 'owner', which is the column which created it.
INHERITS FROM
"Alzabo::ColumnDefinition"
Note: all relevant documentation from the superclass has been merged into this document.
METHODS
new
This method takes the following parameters:
* owner => "Alzabo::Create::ColumnDefinition" object
* type => $type
It returns a new "Alzabo::Create::ColumnDefinition" object.
alter
See the "Alzabo::Column->alter()" method for details.
type
Returns the object's type as a string.
set_type ($string)
Sets the object's type.
Throws: "Alzabo::Exception::Params", "Alzabo::Exception::RDBMSRules"
length
Returns the length attribute of the column, or undef if there is none.
precision
Returns the precision attribute of the column, or undef if there is none.
set_length
This method takes the following parameters:
* length => $length
* precision => $precision (optional)
Sets the column's length and precision. The precision parameter is optional (though some column types may require it if the length is
set).
Throws: "Alzabo::Exception::Params", "Alzabo::Exception::RDBMSRules"
owner
Returns the "Alzabo::Create::Column" object that owns this definitions (the column that created it).
perl v5.8.8 2007-12-23 Alzabo::Create::ColumnDefinition(3pm)