Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Remove new line character and add space to convert into fixed width file
Top Forums Shell Programming and Scripting Remove new line character and add space to convert into fixed width file Post 302753125 by Amrutha24 on Tuesday 8th of January 2013 06:13:51 AM
Old 01-08-2013
Remove new line character and add space to convert into fixed width file
I have a file with different record length. The file as to be converted into fixed length by appending spaces at the end of record. The length should be calculated based on the record with maximum length in the file.

If the length is less than the max length, the spaces should be appended before the new line character of that record.

Code:
 
Input File:
123
12345
1234
 
Output file:
123  
12345
1234 
 
Here the max record length is 5

 

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Appending string (charachters inside the line) to a fixed width file using awk or sed

Source File: abcdefghijklmnop01qrstuvwxyz abcdefghijklmnop02qrstuvwxyz abcdefghijklmnop03qrstuvwxyz abcdefghijklmnop04qrstuvwxyz abcdefghijklmnop05qrstuvwxyz Whatever characters are in 17-18 on each line of the file, it should be concatenated to the same line at the character number... (6 Replies)
Discussion started by: tamahomekarasu
6 Replies

2. UNIX for Dummies Questions & Answers

Remove duplicates based on a column in fixed width file

Hi, How to output the duplicate record to another file. We say the record is duplicate based on a column whose position is from 2 and its length is 11 characters. The file is a fixed width file. ex of Record: DTYU12333567opert tjhi kkklTRG9012 The data in bold is the key on which... (1 Reply)
Discussion started by: Qwerty123
1 Replies

3. HP-UX

How to remove new line character and append new line character in a file?

Hi Experts, I have data coming in 4 columns and there are new line characters \n in between the data. I need to remove the new line characters in the middle of the row and keep the \n character at the end of the line. File is comma (,) seperated. Eg: ID,Client ,SNo,Rank 37,Airtel \n... (8 Replies)
Discussion started by: sasikari
8 Replies

4. UNIX for Dummies Questions & Answers

convert # delimited text file to fixed width

Hello gurus, I have a file containing 5 columns delimited by '#' as shown in the example below: HRP1000-PLVAR#HRP1000-OTYPE#HRP1000-OBJID#HRP1000-BEGDA#HRP1000-ENDDA# 99991231#AU7129#000000000#1 PROCTER & GAMBLE# 99991231#TT4283#1000013883#21111 LAUNDRY# 99991231#TT4283#1000013884#21121 DISH... (3 Replies)
Discussion started by: chumsky
3 Replies

5. UNIX for Dummies Questions & Answers

Replace the unexpected newline char with space in a Fixed width file

Input eg: Ouput Expected. The #rd line had the unexpted new line, which need to be replaced with space. I was planing to go with checking the length of each line using awk and if the length is less than the defeined limit, (12 in above case) will replace the newline with space. ... (5 Replies)
Discussion started by: deepakwins
5 Replies

6. Shell Programming and Scripting

How to add a character after the first word/space on each line?

Hi:) I have a large file ( couple thousand lines ) and I'm trying to add a character after the first word/space on each line. eg: First line of text Second line of text Third line of text Fourth line of text Fifth line of text I'd like to accomplish: First - line of text Second... (8 Replies)
Discussion started by: martinsmith
8 Replies

7. UNIX for Beginners Questions & Answers

How do I remove leading spaces in UNIX when count of space character is not fixed? Example below-

Script showStreamsGLIS$reg.$env.ksh gives me output as below- Job Stime Etime Status ExitCode GLIS-AS-S-EFL-LOCK-B ----- ----- OI 103313880/0 GLIS-ALL-Q-EOD-FX-UPDT-1730-B ----- ----- TE 0/0 GLIS-TK-S-BWSOD-B ... (8 Replies)
Discussion started by: Tanu
8 Replies

8. Shell Programming and Scripting

awk issue splitting a fixed-width file containing line feed in data

Hi Forum. I have the following script that splits a large fixed-width file into smaller multiple fixed-width files based on input segment type. The main command in the script is: awk -v search_col_pos=$search_col_pos -v search_str_len=$search_str_len -v segment_type="$segment_type"... (8 Replies)
Discussion started by: pchang
8 Replies

9. UNIX for Beginners Questions & Answers

Convert a fixed width file to a delimited file

Hi - this is a generic question .... is there any utility which can convert a fixed width file format to a delimited file (any given character delimited) ? (5 Replies)
Discussion started by: i4ismail
5 Replies

LEARN ABOUT DEBIAN

srec_brecord

srec_brecord(5) 						File Formats Manual						   srec_brecord(5)

NAME

       srec_brecord - Freescale MC68EZ328 Dragonball bootstrap record format

DESCRIPTION

       This data format is understood by Freescale MC68EZ328 Dragonball series processors on their internal UART.

   Lines
       Each  line  contains  hexadecimal  data,  each  byte represented by two hexadecimal nybbles in upper case.  Characters not in this set, but
       larger than 0x30 (e.g. lower case) will be ignored, less than 0x30 (e.g. CR or LF) are considered record terminators.  Comments	are  prob-
       lematic; don't try this at home.

   Fields
       Each  line  contains  a	4-byte address (big endian), a 1-byte length-and-mode, and then data bytes as dictated by the length.  There is no
       checksum.  A zero length record is an execution start address record, non-zero length records are data.

						   +--+---+---+---+---+---+---+---+---+----+-----+---+
						   |1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | ... | n |
						   +--+---+---+---+---+---+---+---+---+----+-----+---+
						   |	       Address		  | Length |  Data   |
						   +------------------------------+--------+---------+
       The length-and-mode byte is formatted as follows:

							     +--+---+---+---+---+---+---+---+
							     |7 | 6 | 5 | 4 | 3 | 2 | 1 | 0 |
							     +--+---+---+---+---+---+---+---+
							     |Mode  | R |      Length	    |
							     +------+---+-------------------+
       Mode    These bits are ignored by SRecord in input (00 = bytes, 01 = half words, 10 is reserved, 11 = long words).  These bits  are  always
	       zero on output by SRecord.

       R       This bit indicates a data read rather than a data write; SRecord does not accept input files with this bit set, and will not set it
	       on output.

       Length  The length of the records data bytes.  It does not include the address or length bytes.	The maximum payload  of  a  record  is	31
	       bytes of data.

   Size Multiplier
       In general, binary data will expand in sized by at least 2.35 times when represented with this format.

EXAMPLE

       Here is an example b-record format file.  It contains the data "Hello, World" to be loaded at address 0.
	      000000000D48656C6C6F2C20576F726C640A

SEE ALSO

       http://www.freescale.com/files/32bit/doc/ref_manual/MC68VZ328UM.pdf

COPYRIGHT

       srec_cat version 1.58
       Copyright (C) 1998, 1999, 2000, 2001, 2002, 2003, 2004, 2005, 2006, 2007, 2008, 2009, 2010, 2011 Peter Miller

       The srec_cat program comes with ABSOLUTELY NO WARRANTY; for details use the 'srec_cat -VERSion License' command.  This is free software and
       you are welcome to redistribute it under certain conditions; for details use the 'srec_cat -VERSion License' command.

AUTHOR

       Peter Miller   E-Mail:	pmiller@opensource.org.au
       //*		 WWW:	http://miller.emu.id.au/pmiller/

Reference Manual						      SRecord							   srec_brecord(5)
All times are GMT -4. The time now is 09:45 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy