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 BSD
learn
LEARN(1) General Commands Manual LEARN(1)NAME
learn - computer aided instruction about UNIX
SYNOPSIS
learn [ -directory ] [ subject [ lesson ] ]
DESCRIPTION
Learn gives Computer Aided Instruction courses and practice in the use of UNIX, the C Shell, and the Berkeley text editors. To get started
simply type learn. If you had used learn before and left your last session without completing a subject, the program will use information
in $HOME/.learnrc to start you up in the same place you left off. Your first time through, learn will ask questions to find out what you
want to do. Some questions may be bypassed by naming a subject, and more yet by naming a lesson. You may enter the lesson as a number
that learn gave you in a previous session. If you do not know the lesson number, you may enter the lesson as a word, and learn will look
for the first lesson containing it. If the lesson is `-', learn prompts for each lesson; this is useful for debugging.
The subject's presently handled are
files
editor
vi
morefiles
macros
eqn
C
There are a few special commands. The command `bye' terminates a learn session and `where' tells you of your progress, with `where m'
telling you more. The command `again' re-displays the text of the lesson and `again lesson' lets you review lesson. There is no way for
learn to tell you the answers it expects in English, however, the command `hint' prints the last part of the lesson script used to evaluate
a response, while `hint m' prints the whole lesson script. This is useful for debugging lessons and might possibly give you an idea about
what it expects.
The -directory option allows one to exercise a script in a nonstandard place.
FILES
/usr/share/learn subtree for all dependent directories and files
/usr/tmp/pl* playpen directories
$HOME/.learnrc startup information
SEE ALSO csh(1), ex(1)
B. W. Kernighan and M. E. Lesk, LEARN - Computer-Aided Instruction on UNIX
BUGS
The main strength of learn, that it asks the student to use the real UNIX, also makes possible baffling mistakes. It is helpful, espe-
cially for nonprogrammers, to have a UNIX initiate near at hand during the first sessions.
Occasionally lessons are incorrect, sometimes because the local version of a command operates in a non-standard way. Occasionally a lesson
script does not recognize all the different correct responses, in which case the `hint' command may be useful. Such lessons may be skipped
with the `skip' command, but it takes some sophistication to recognize the situation.
To find a lesson given as a word, learn does a simple fgrep(1) through the lessons. It is unclear whether this sort of subject indexing is
better than none.
Spawning a new shell is required for each of many user and internal functions.
The `vi' lessons are provided separately from the others. To use them see your system administrator.
7th Edition October 22, 1996 LEARN(1)