Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Convert variable length record to fixed length
Top Forums Shell Programming and Scripting Convert variable length record to fixed length Post 302996792 by rdrtx1 on Tuesday 2nd of May 2017 11:13:59 AM
Old 05-02-2017
Code:
 sed -n -r '/^.{67}$/p' infile

or something like:
Code:
perl -pe 'while(<>) {print $_ if $_ =~ /^.{67}$/};' < infile

Last edited by rdrtx1; 05-02-2017 at 05:08 PM..
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

creating a fixed length output from a variable length input

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

Convert delimited to fixed length

Hi, I have to change a tab delimited file to a fixed length file. For text fields I need to left justify and NULL fill to the right and for number fields I need to right justify and zero fill to the left. If there are spaces between words in a text field I need to keep them as spaces. I am using... (14 Replies)
Discussion started by: nelson553011
14 Replies

3. Shell Programming and Scripting

fixed record length

hello! I have a file with fixed record length... format: 123445asdfg 4343777 sfgg I wanna convert it to 123445,asdfg ,4343,777 ,sfgg is there any way to do it? sed/grep/awk?? at the moment I use sed -e 's_ \(\)_,\1_g' but it works only if there are spaces between... (16 Replies)
Discussion started by: george_
16 Replies

4. Shell Programming and Scripting

convert fixed length file to CSV

Newbie Looking for a script to convert my input file to delimited text file. Not familier with AWK or shell programing. Below is sample record in my input file and the expected output format. My OS is HPUX 11.23. Thanks in advance for your assistance. tbtbs input file:... (12 Replies)
Discussion started by: tbtbs
12 Replies

5. UNIX for Dummies Questions & Answers

What the command to find out the record length of a fixed length file?

I want to find out the record length of a fixed length file? I forgot the command. Any body know? (9 Replies)
Discussion started by: tranq01
9 Replies

6. UNIX for Dummies Questions & Answers

Convert a tab delimited/variable length file to fixed length file

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

7. Shell Programming and Scripting

search and replace fixed length record file

Hi I need to be search a file of fixed length records and when I hit a particular record that match a search string, substitute a known position field In the example file below FHEAD000000000120090806143011 THEAD0000000002Y0000000012 P00000000000000001234 TTAIL0000000003... (0 Replies)
Discussion started by: nedkelly007
0 Replies

8. Shell Programming and Scripting

Make variable length record a fixed length

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

9. Shell Programming and Scripting

changing a variable length text to a fixed length

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

10. Shell Programming and Scripting

Add substring in a file containing fixed length record.

I am new to awk and writing a script using awk. I have file containing fixed length records, I wish to extract 2 substring(each substring is padded with zeros on left e.g 000000003623) and add each substring respectively for every record in the file to get total sum of respective substring for all... (5 Replies)
Discussion started by: Devesh5683
5 Replies

LEARN ABOUT DEBIAN

castor_limits

LCG_LIMITS(4)							   File Formats 						     LCG_LIMITS(4)

NAME

       Castor_limits - LCG internal limits

SYNOPSIS

       #include <Castor_limits.h>

DESCRIPTION

       The Castor_limits.h header file contains all the common limits that all LCG subpackages have to respect.
       These are:

       CA_MAXACLENTRIES
	      maximum number of ACL entries for a file/dir
	      Default value: 300

       CA_MAXCLASNAMELEN
	      maximum length for a fileclass name
	      Default value: 15

       CA_MAXCOMMENTLEN
	      maximum length for user comments in metadata
	      Default value: 255

       CA_MAXDENFIELDS
	      maximum number of density values in devinfo
	      Default value: 8

       CA_MAXDENLEN
	      maximum length for a alphanumeric density
	      Default value: 8

       CA_MAXDGNLEN
	      maximum length for a device group name
	      Default value: 6

       CA_MAXDPMTOKENLEN
	      maximum length for a Disk Pool Manager token
	      Default value: 36

       CA_MAXDVNLEN
	      maximum length for a device name
	      Default value: 63

       CA_MAXDVTLEN
	      maximum length for a device type
	      Default value: 8

       CA_MAXFIDLEN
	      maximum length for a fid (DSN)
	      Default value: 17

       CA_MAXFSEQLEN
	      maximum length for a fseq string
	      Default value: 14

       CA_MAXGID
	      maximum value for gid
	      Default value: 0x7FFFFFFF

       CA_MAXGRPNAMELEN
	      maximum length for a group name
	      Default value: 2

       CA_MAXGUIDLEN
	      maximum length for a guid
	      Default value: 36

       CA_MAXHOSTNAMELEN
	      maximum length for a hostname
	      Default value: 63

       CA_MAXLBLTYPLEN
	      maximum length for a label type
	      Default value: 3

       CA_MAXLINELEN
	      maximum length for a line in a log
	      Default value: 1023

       CA_MAXMANUFLEN
	      maximum length for a cartridge manufacturer
	      Default value: 12

       CA_MAXMLLEN
	      maximum length for a cartridge media_letter
	      Default value: 1

       CA_MAXMODELLEN
	      maximum length for a cartridge model
	      Default value: 6

       CA_MAXNAMELEN
	      maximum length for a pathname component
	      Default value: 255

       CA_MAXNBDRIVES
	      maximum number of tape drives per server
	      Default value: 32

       CA_MAXPATHLEN
	      maximum length for a pathname
	      Default value: 1023

       CA_MAXPOLICYLEN
	      maximum length for a policy name
	      Default value: 15

       CA_MAXPOOLNAMELEN
	      maximum length for a pool name
	      Default value: 15

       CA_MAXPROTOLEN
	      maximum length for a protocol name
	      Default value: 7

       CA_MAXRBTNAMELEN
	      maximum length for a robot name
	      Default value: 17

       CA_MAXRECFMLEN
	      maximum length for a record format
	      Default value: 3

       CA_MAXREGEXPLEN
	      maximum length for a regular expression
	      Default value: 63

       CA_MAXSFNLEN
	      maximum length for a replica
	      Default value: 1103

       CA_MAXSHORTHOSTLEN
	      maximum length for a hostname without domain
	      Default value: 10

       CA_MAXSNLEN
	      maximum length for a cartridge serial nb
	      Default value: 24

       CA_MAXSTGRIDLEN
	      maximum length for a stager full request id
	      (must be >= nb digits in
	      CA_MAXSTGREQID + CA_MAXHOSTNAMELEN + 8)
	      Default value: 77

       CA_MAXSTGREQID
	      maximum value for a stager request id
	      Default value: 999999

       CA_MAXUID
	      maximum value for uid
	      Default value: 0x7FFFFFFF

       CA_MAXSYMLINKS
	      maximum number of symbolic links
	      Default value: 5

       CA_MAXTAGLEN
	      maximum length for a volume tag
	      Default value: 255

       CA_MAXTAPELIBLEN
	      maximum length for a tape library name
	      Default value: 8

       CA_MAXUNMLEN
	      maximum length for a drive name
	      Default value: 8

       CA_MAXUSRNAMELEN
	      maximum length for a login name
	      Default value: 14

       CA_MAXVIDLEN
	      maximum length for a VID
	      Default value: 6

       CA_MAXVSNLEN
	      maximum length for a VSN
	      Default value: 6

AUTHOR

       LCG Grid Deployment Team

LCG
							   $Date: 2007/02/03 11:16:45 $ 					     LCG_LIMITS(4)
All times are GMT -4. The time now is 03:28 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy