06-09-2015
File splitting according to the length of the fields
Hi All,
I have two files:
1> Data file
2> info file which has field lengths and start position.
Is there a way to create a comma delimited file according to the fields length and start position.
Data file :
HTML Code:
R-0000017611N-00000350001095ANZU01
A00000017611N000000350001095ANZU02
R-0000019427N-00000265001202BGYI03
R-0000005977N-00000092001202BGYI03
R-0000017195N-00000995001353B1IZ03
A00000099500N000000995001353B1IZ04
R-0000258547N-00002266002019AXAJ01
A00000258547N000002266002019AXAJ02
R-0000012277N-00000216002026BLCF03
A00000012277N000000216002026BLCF04
HTML Code:
Field Name Length Start Position
ADJ-TYPE-CODE 1 1
ALLOW-AMT 11 2
CAP-SRVC-NO 1 13
BILL-AMT 11 14
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I have a line of more than 3000 bytes which will contain & as fields separator..I am using following awk command ..Its working but its not accepting the line more than 3000 bytes...Anyother alternate solution even in othe shell command also fine...
awk -F '&' '{for( i=1; i<=NF; i++ ) print $i}'... (2 Replies)
Discussion started by: punithavel
2 Replies
2. Shell Programming and Scripting
Need a script that manipulates a fixed length file that will compare 2 fields in that file and if they are equal write that line to a new file.
i.e. If fields 87-93 = fields 119-125, then write the entire line to a new file. Do this for every line in the file. After we get only the fields... (1 Reply)
Discussion started by: Muga801
1 Replies
3. Shell Programming and Scripting
HPUX and posix shell
Hi all.
I have a record with fixed length fields....I would like to reorder the fields and preserver the fixed lengths....
cat test
4 960025460 Dept of Music
8 960025248 Dept of Music 12-08
cat... (3 Replies)
Discussion started by: lyoncc
3 Replies
4. Shell Programming and Scripting
Hi. I want to put the first field to the end and the lines are of different number of fields. How should I do this with awk? Thanks. (3 Replies)
Discussion started by: dustinwang2003
3 Replies
5. Shell Programming and Scripting
Hi,
I need to split a fixed length file of 160 characters based on value of a column. Example:
ABC 456780001 DGDG SDFSF
BCD 444440002 SSSS TTTTT
ABC 777750003 HHHH UUUUU
THH 888880001 FFFF LLLLLL
HHH 999990002 GGGG OOOOO
I need to split this file on basis of column from... (7 Replies)
Discussion started by: Neelkanth
7 Replies
6. Shell Programming and Scripting
for making a summary
I have a CSV file which is transformed to .DAT. I have an AWK file which is supposing to do the mapping of the DAT file. The code from the AWK file is the one below.
The content of the DAT file looks like this (tab separated):
ODT AGE CDT CO SEX TIME VALUE COMMENT
... (1 Reply)
Discussion started by: grikoss
1 Replies
7. Shell Programming and Scripting
Hi All,
We are trying to pull out data from below table, the table contains four fields and out of which last two fields are having sub-fields with delimiter $, we want to identify number "1" position in the 3rd field and from 4th field need to extract the information from the same position.
... (4 Replies)
Discussion started by: rramkrishnas
4 Replies
8. Shell Programming and Scripting
Hi,
I have a tab delimited file as below:
AWA Divi DD01 None 1 2 Room AC 01-MAY-15 31-OCT-15 OT 01-MAY-15 31-OCT-15 CF 01-MAY-15 31-OCT-15
AW0 Beach DD02 None 1 2 Double AC 01-MAY-15 31-OCT-15 AD 01-MAY-15 31-OCT-15
The number of columns(fields) after 7th field is not fixed and... (3 Replies)
Discussion started by: Bobby_2000
3 Replies
9. Shell Programming and Scripting
Hi,
Iv got the following input
$id |grep uid
uid=6090(dsiddiq) gid=1(staff) groups=4001(cdgrp)
and Im using the below command to split the field to grab the numberical userid as well the alphabetical userid
$id|awk -F'=' '{print $2}'|awk -F')' '{print $1}'|awk -F'(' '{print $1" "$2}'... (4 Replies)
Discussion started by: dsid
4 Replies
10. UNIX for Beginners Questions & Answers
Hi ,
I am having a scenario where I need to split the file based on two field values. The file is a fixed length file.
ex:
AA0998703000000000000190510095350019500010005101980301
K 0998703000000000000190510095351019500020005101480 ... (4 Replies)
Discussion started by: saj
4 Replies
LEARN ABOUT DEBIAN
html::formhandler::field::checkbox
HTML::FormHandler::Field::Checkbox(3pm) User Contributed Perl Documentation HTML::FormHandler::Field::Checkbox(3pm)
NAME
HTML::FormHandler::Field::Checkbox - a checkbox field type
VERSION
version 0.40013
DESCRIPTION
This field is very similar to the Boolean Widget except that this field allows other positive values besides 1. Since unselected checkboxes
do not return a parameter, fields with Checkbox type will always be set to the 'input_without_param' default if they do not appear in the
form.
widget
checkbox
checkbox_value
In order to create the HTML for a checkbox, there must be a 'value="xx"'. This value is specified with the 'checkbox_value' attribute,
which defaults to 1.
input_without_param
If the checkbox is not checked, it will be set to the value of this attribute (the unchecked value). Default = 0. Because unchecked
checkboxes do not return anything in the HTTP parameters, the absence of a checkbox key in the parameters hash forces this field to this
value. This means that Checkbox fields, unlike other fields, will not be ignored if there is no input. If a particular checkbox should not
be processed for a particular form, you must set 'inactive' to 1 instead.
AUTHOR
FormHandler Contributors - see HTML::FormHandler
COPYRIGHT AND LICENSE
This software is copyright (c) 2012 by Gerda Shank.
This is free software; you can redistribute it and/or modify it under the same terms as the Perl 5 programming language system itself.
perl v5.14.2 2012-06-25 HTML::FormHandler::Field::Checkbox(3pm)