Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: fixed length text file padding issues in AIX
Top Forums Shell Programming and Scripting fixed length text file padding issues in AIX Post 302395039 by techmoris on Sunday 14th of February 2010 12:12:16 PM
Old 02-14-2010
fixed length text file padding issues in AIX
Hi,

I have a fixed length text file that needs to be cut into individual files in aix and facing padding issues. If I have multiple blank spaces in the file it is just making it one while cutting the files..

Eg:-

$ - blank space

filename:file.txt
Code:
1234_A001Chris$$$$Professor$$CompuerScience
1234_A002Jhon$$$$Professor$$BilogicalSciences

Desired Output

filename:- 1234_A.txt
Code:
001Chris$$$$Professor$$CompuerScience
002Jhon$$$$Professor$$BilogicalSciences

As per the below code, I am getting the output with just 1 blank space no matter I have any number of blank spaces in the actual file.
Code:
while read LINE; do
  echo $LINE | cut -c7- >> $(echo $LINE | cut -c1-6).txt
done < file.txt

current output:-

Code:
001Chris$Professor$CompuerScience
002Jhon$Professor$BilogicalSciences


Desired Output

filename:- 1234_A.txt

Code:
001Chris$$$$Professor$$CompuerScience
002Jhon$$$$Professor$$BilogicalSciences

Please give your ideas..

Thx
Last edited by Scott; 02-14-2010 at 01:27 PM.. Reason: Good idea: Code tags, PLEASE!
 

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 XML file into Text file(fixed length)

If someone out there could help me out with this problem. I would really appreciate it. I am trying to convert xml into text file(fixed length) using Unix Borne shell scripts. My xml file: <root> <header_rec recordtype="00"> <record_id>00</record_id> ... (0 Replies)
Discussion started by: ram2s2001
0 Replies

3. 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

4. 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

5. Shell Programming and Scripting

Need a sort solution for fixed length file

I have a 1250 byte record that I need to sort in column 10-19 and in column 301. I have tried the sort command, but it looks like it needs delimiters to work. The record can have spaces in a lot of its 1250 columns, but 10-19, and 301 are guaranteed. These columns are numeric too. A sample... (1 Reply)
Discussion started by: mb1201
1 Replies

6. 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

7. Shell Programming and Scripting

Replace Date in a fixed length file

Hello All, I working on ksh. I am using fixed length file. My file is like: ======== IXTTIV110827 NANTH AM IKSHIT ABCDEF 0617 IJAY NAND EENIG ZXYWVU 0912 AP OOK OONG PQRSTU100923 NASA DISH TTY ASDFG 0223 GHU UMA LAM QWERT 0111 ATHE SH THEW ======= From 7th to 12 is a date... (4 Replies)
Discussion started by: AnanthaDikshit
4 Replies

8. UNIX for Dummies Questions & Answers

Length of a fixed width file

I have a fixed width file of length 53. when is try to get the lengh of the record of that file i get 2 different answers. awk '{print length;exit}' <File_name> The above code gives me length 50. wc -L <File_name> The above code gives me length 53. Please clarify on... (2 Replies)
Discussion started by: Amrutha24
2 Replies

9. Shell Programming and Scripting

Extracting fixed length number from a text file

Hi, I have a text file with sample records as CASE ID: 20170218881083 Original presentment record for ARN not found for Re-presentment I want to extract the 23 digit number from this file. I thought of using grep but initially couldn't extract the required number. However, after... (16 Replies)
Discussion started by: dsid
16 Replies

10. Shell Programming and Scripting

Generate fixed length txt file

hi, i am using below query to generate the fixed length txt file. this sql is being called from shell script. This is supposed to be a fixed record file with the below definitions. There must be 2 byte filler after the CAT_ID AND each line should have total of 270 bytes. field ... (1 Reply)
Discussion started by: itzkashi
1 Replies

LEARN ABOUT DEBIAN

gedit

GEDIT(1)						      General Commands Manual							  GEDIT(1)

NAME

       gedit - text editor for the GNOME Desktop

SYNOPSIS

       gedit [OPTION...] [FILE...] [+LINE[:COLUMN]]

DESCRIPTION

       gedit is the official text editor of the GNOME desktop environment.

       While  aiming  at simplicity and ease of use, gedit is a powerful general purpose text editor.  It can be used to create and edit all kinds
       of text files.

       gedit features a flexible plugin system which can be used to dynamically add new advanced features to gedit itself.

OPTIONS

       -b, --background
	      Run gedit in the background.

       --encoding
	      Set the character encoding to be used for opening the files listed on the command line.

       -g, --geometry=GEOMETRY
	      Set the X geometry window size (WIDTHxHEIGHT+X+Y).

       --list-encodings
	      Display list of possible values for the encoding option and exit.

       --new-window
	      Create a new toplevel window in an existing instance of gedit.

       --new-document
	      Create a new document in an existing instance of gedit.

       -s, --standalone
	      Run gedit in standalone mode.

       -w, --wait
	      Open files and block the gedit process.

       --help Prints the command line options.

       --version
	      Output version information and exit.

       FILE   Specifies the file to open when gedit starts. If this is not specified, gedit will load a blank  file  with  an  "Unsaved  Document"
	      label. Multiple files can be loaded if they are separated by spaces.  gedit also supports handling of remote files. For example, you
	      can pass	the  location  of  a  webpage  to  gedit  ,  like  "http://www.gnome.org",  or	load  a  file  from  a	FTP  server,  like
	      "ftp://ftp.gnome.org/robots.txt".

       +LINE  For  the first file, go to the line specified by LINE (do not insert a space between the "+" sign and the number).  If LINE is miss-
	      ing, go to the last line.

       COLUMN For the first file, go to the column specified by COLUMN.  If COLUMN is missing, go to the first column.

BUGS

       If you find a bug, please report it at http://bugzilla.gnome.org/enter_bug.cgi?product=gedit.

AUTHORS

       Paolo Maggi (paolo@gnome.org)

       Paolo Borelli (pborelli@katamail.com)

       Steve Frecinaux (code@istique.net)

       Jesse van den Kieboom (jessevdk@gnome.org)

       Ignacio Casal Quinteiro <icq@gnome.org>

       James Willcox (jwillcox@gnome.org)

       Federico Mena Quintero (federico@novell.com)

       Chema Celorio

								    17 May 2010 							  GEDIT(1)
All times are GMT -4. The time now is 06:54 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy