08-02-2010
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 out the field if it makes it easier.
Thanks
Dave
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
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. Shell Programming and Scripting
Hi, I have two files.
File1:
File1 contains two fixed width columns ID of 15 characters length and Name is of 100 characters length.
ID Name
1-43<<11 spaces>>Swapna<<94 spaces>>
1-234<<10 spaces>>Mani<<96 spaces>>
1-3456<<9 spaces>>Kapil<<95 spaces>>
File2:
... (4 Replies)
Discussion started by: manneni prakash
4 Replies
4. Shell Programming and Scripting
Hi, I have two input files.
File1:
ID Name Place
1-234~name1~Newyork
1-34~name2~Boston
1-2345~name3~Hungary
File1 is a variable length file where each column is seperated by delimitter "~".
File2:
ID Country
1-34<<11 SPACES>>USA<<7 spaces>>
1-234<<10 SPACES>>UK<<8... (5 Replies)
Discussion started by: manneni prakash
5 Replies
5. 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
6. UNIX for Dummies Questions & Answers
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
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
8. Shell Programming and Scripting
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
... (2 Replies)
Discussion started by: techmoris
2 Replies
9. Shell Programming and Scripting
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
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
anno(1) General Commands Manual anno(1)
NAME
anno - annotate messages (only available within the message handling system, mh)
SYNOPSIS
anno [+folder] [msgs] [-component field] [-help] [-[no]inplace] [-text body]
OPTIONS
Specifies the name of the header field which anno adds. It should be a valid RFC 822-style message field name, which means that it should
consist of alphanumeric characters or dashes only. If you do not supply this option, anno will prompt you for the field name. Prints a
list of the valid options to this command. The -inplace switch causes annotation to be done in place in order to preserve links to the
annotated message. Allows you to add a header field containing text to the message. The anno command will create a second header field on
the message, containing the text that you specify. If the text contains a space, you must enclose the text in double quotes ("). If you do
not supply this option, anno adds only one field, which contains the date of the annotation.
The default settings for this command are:
+folder defaults to the current folder msgs defaults to the current message -noinplace
DESCRIPTION
The anno command annotates a message by adding one or more header fields to the message.
The anno command allows you to choose the name of the header field which you add. It records the date at which the message is annotated,
and allows you to add an additional field containing text, if you wish.
You can use anno with dist, forw, and repl, to keep track of how you have distributed, forwarded, or replied to messages.
By default, anno annotates the current message in the current folder. You can select another message by using the msg and +folder argu-
ments. You can also annotate more than one message, or a range of messages.
PROFILE COMPONENTS
Path: To determine your Mail directory
EXAMPLES
This example annotates message number 1 in the folder +test. The -component option specifies the name of the header field: % anno 1 +test
-component Forwarded
The following field is added to the message header: Forwarded: Tue, 08 Jan 1991 16:10:06 +0000 The next example shows how to use the
-text option to add an additional field: % anno -component Forwarded -text "to David - as requested"
The following lines are added to the message header: Forwarded: Tue, 08 Jan 1991 16:13:27 +0000 Forwarded: to David - as requested
The final example shows how anno prompts for the name of the header field, if the -component option is not supplied: % annoEnter
component name: forwarded
The following line is added to the message: forwarded: Tue, 08 Jan 1991 16:21:58 +0000
FILES
The user profile.
SEE ALSO
dist(1), forw(1), repl(1)
anno(1)