12-18-2008
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 output:
10200002 US$ COM 16/12/2008 2,3775 2,3783 <<17 SPACES>>
19300978 EURO 16/12/2008 3,28523 3,28657<<17 SPACES>>
Thanks,
Everton Silveira
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
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
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
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
4. Shell Programming and Scripting
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)
Discussion started by: satyam_sat
7 Replies
5. Shell Programming and Scripting
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
6. UNIX for Dummies Questions & Answers
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
7. Shell Programming and Scripting
hi ,
i need to convert fixed length file to delimited file using unix where length of each column is variable (2 Replies)
Discussion started by: Nishithinfy
2 Replies
8. Shell Programming and Scripting
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
Hi All,
I need to convert a fixed length file to a delimited file with , (comma). But not all columns, some of the columns in the fixed files are used as fillers and I do not need that in the output file.
test_fixed_len.txt
I 0515 MR 394
I 0618 MR & MRS 942
I 0618 MR & MRS... (7 Replies)
Discussion started by: member2014
7 Replies
10. Shell Programming and Scripting
Hi Team,
I have an issue to split the file which is having special chracter(German Char) using awk command.
I have a different length records in a file. I am separating the files based on the length using awk command.
The command is working fine if the record is not having any... (7 Replies)
Discussion started by: Anthuvan
7 Replies
LEARN ABOUT DEBIAN
fntsample
fntsample(1) General Commands Manual fntsample(1)
NAME
fntsample - PDF and PostScript font samples generator
SYNOPSIS
fntsample [ OPTIONS ] -f FONT-FILE -o OUTPUT-FILE
fntsample -h
DESCRIPTION
fntsample program can be used to generate font samples that show Unicode coverage of the font and are similar in appearance to Unicode
charts. Samples can be saved into PDF (default) or PostScript file.
OPTIONS
fntsample supports the following options.
--font-file, -f FONT-FILE
Make samples of FONT-FILE.
--font-index, -n IDX
Font index for FONT-FILE specified using --font-file option. Useful for files that contain multiple fonts, like TrueType Collec-
tions (.ttc). By default font with index 0 is used.
--output-file, -o OUTPUT-FILE
Write output to OUTPUT-FILE.
--other-font-file, -d OTHER-FONT
Compare FONT-FILE with OTHER-FONT. Glyphs added to FONT-FILE will be highlighted.
--other-index, -m IDX
Font index for OTHER-FONT specified using --other-font-file option.
--postscript-output, -s
Use PostScript format for output instead of PDF.
--svg, -g
Use SVG format for output. The generated document contains one page. Use range selection options to specify which.
--print-outline, -l
Print document outlines data to standard output. This data can be used to add outlines (aka bookmarks) to resulting PDF file with
pdfoutline program.
--include-range, -i RANGE
Show characters in RANGE.
--exclude-range, -x RANGE
Do not show characters in RANGE.
--style, -t "STYLE: VAL"
Set STYLE to value VAL. Run fntsample with option --help to see list of styles and default values.
--help, -h
Display help text and exit.
Parameter RANGE for -i and -x can be given as one integer or a pair of integers delimited by minus sign (-). Integers can be specified in
decimal, hexadecimal (0x...) or octal (0...) format. One integer of a pair can be missing (-N can be used to specify all characters with
codes less or equal to N, and N- for all characters with codes greather or equal to N). Multiple -i and -x options can be used.
EXAMPLES
Make PDF samples for font.ttf and write them to file samples.pdf:
fntsample -f font.ttf -o samples.pdf
Make PDF samples for font.ttf, compare it with oldfont.ttf and highlight new glyphs. Write output to file samples.pdf:
fntsample -f font.ttf -d oldfont.ttf -o samples.pdf
Make PostScript samples for font.ttf and write output to file samples.ps. Show only glyphs for characters with codes less or equal to
U+04FF but exclude U+0370-U+03FF:
fntsample -f font.ttf -s -o samples.ps -i -0x04FF -x 0x0370-0x03FF
Make PDF samples for font.ttf and save output to file samples.pdf adding outlines to it:
fntsample -f font.ttf -o temp.pdf -l > outlines.txt
pdfoutline temp.pdf outlines.txt samples.pdf
AUTHOR
Copyright (C) 2007 Eugeniy Meshcheryakov <eugen@debian.org>
Homepage: <http://fntsample.sourceforge.net/>
SEE ALSO
pdfoutline(1)
2010-10-14 fntsample(1)