Hello gurus,
I have a file containing 5 columns delimited by '#' as shown in the example below:
The first row contains the the header, which I would like to remove in the final output, which should look like below:
Field lengths should be as follows:
Column 1 = 8 (1-8)
Column 2 = 6 (10-15)
Column 3 = 10 (17-26)
Column 4 = 5 (28-32)
Column 5 = 30 (34-63)
Any help on a code to perform this conversion will be greatly appreciated.
Thanks!
Last edited by Franklin52; 07-07-2011 at 03:15 AM..
Reason: Please use code tags for code and data samples, thank you
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)
Hi,
I have a delimited file generated by a database and i need to convert it to fixed width file using the field length of the database. Can any body suggest me how can i proceed with it?
:confused:
Thanks
Raghavan (2 Replies)
I have below fixed lenth file . I have to convert this to delimitted file.
File1.txtE116005/29/19930E001E000
E12201/23/19940E001E003
E10406/4/19940E001E003
I want to convert this to :
E116,0,05/29/1993,0,E001,E000
E122,0,1/23/1994,0,E001,E003
E104,0,6/4/1994,0,E001,E003
I have a... (7 Replies)
Hi, Iam new to unix. I have one input file .
Input file :
ID1~Name1~Place1
ID2~Name2~Place2
ID3~Name3~Place3
I need output such that only first column should change to fixed width column of 15 characters of length.
Output File:
ID1<<12 spaces>>Name1~Place1
ID2<<12... (5 Replies)
Hello Gurus,
I have a text file containing nearly 12,000 tab delimited characters with 4000 rows. If the file size is small, excel can convert the text into coloumns. However, the file that I have is very big. Can some body help me in solving this problem?
The input file example,
... (6 Replies)
Hi,
I have a fixed width text file without any header row. One of the columns contains a date in YYYYMMDD format.
If the original file contains 3 dates, I want my shell script to split the file into 3 small files with data for each date.
I am a newbie and need help doing this. (14 Replies)
Hello gurus,
I have a file in a tab delimited format and a header row. I need a code to delete the header in the file, and convert the file to a fixed width format, with all the columns aligned. Below is a sample of the file:... (4 Replies)
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... (4 Replies)
Hi, I have a rquirement in unix as below .
I have a text file with me seperated by | symbol and i need to generate a excel file through unix commands/script so that each value will go to each column.
ex:
Input Text file:
1|A|apple
2|B|bottle
excel file to be generated as output as... (9 Replies)
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 CENTOS
gslp
GSLP(1) Ghostscript GSLP(1)NAME
gslp - Format and print text using ghostscript
gsbj - Format and print text for BubbleJet printer using ghostscript
gsdj - Format and print text for DeskJet printer using ghostscript
gsdj500 - Format and print text for DeskJet 500 BubbleJet using ghostscript
gslj - Format and print text for LaserJet printer using ghostscript
SYNOPSIS
gslp -12BclqRr -b<header> -f<font> -F<hfont> -L<lines> -p<outfile> -T<n> --add-to-space <units> --add-to-width <units> --columns <n>
--detect --first-page <n> --kern <file.afm> --last-page <n> --(heading|footing)-(left|center|right) <string> --margin-(top|bot-
tom|left|right) <inches> --no-eject-(file|formfeed) --spacing <n> [gs options] [files]
gsbj [options] [files]
gsdj [options] [files]
gsdj500 [options] [files]
gslj [options] [files]
DESCRIPTION
This utility provides functionality approximately equivalent to the Unix enscript(1) program. It prints plain text files using a single
font. It currently handles tabs and formfeeds, but not backspaces. It will line-wrap when using fixed-pitch fonts. It will also do kern-
ing and width adjustment.
The default device (-sDEVICE=) and resolution (-r) are as follows:
gslp epson 180
gsbj bj10e 180
gsdj deskjet 300
gsdj500 djet500 300
gslj laserjet 300
By default the current date is formatted as the center header.
OPTIONS
Standard switches implemented:
-12BclqRr -b<header> -f<font> -F<hfont> -L<lines> -p<outfile>
Sun switches implemented:
-T<n> set tab width
Switches ignored:
-GghKkmow -# -C -d -J -n -P -S -s -t -v
Switches added:
--add-to-space <units>
add the given number of 1/72" units to the width of each space (may be negative)
--add-to-width <units>
add the given number of 1/72" units to the width of each character (may be negative)
--columns <n>
print in <n> columns
--detect
treat the file as PostScript if it starts with %!
--first-page <n>
start printing at page <n>
--kern <file.afm>
kern using information from the given .AFM file
--last-page <n>
stop printing after page <n>
--(heading|footing)-(left|center|right) <string>
set the heading/footing fields; use -B first to clear
--margin-(top|bottom|left|right) <inches>
set a margin
--no-eject-(file|formfeed)
end-of-file/FF only starts a new column, not a new sheet
--spacing <n>
use double (n=2), triple (n=3), etc. spacing
Also, the string %# in a heading or footing is replaced with the page #.
SEE ALSO gs(1)VERSION
This document was last revised for Ghostscript version 9.07.
AUTHOR
Artifex Software, Inc. are the primary maintainers of Ghostscript. This manpage by George Ferguson.
9.07 12 February 2013 GSLP(1)