06-23-2009
Quote:
Originally Posted by
dinesh1985
input file
First Name - position from 1-5
Last Name- position 6-10
Age-Position 11-12
Say above is the format of input file.
Example:
DINESKUMAR21
SACHISHAH 23
23
GURUNTARIM22
In the above example,in the 3 rd record Name is missing. Now while reading the file line by line,I want to delete the 3 rd line during validation.
---------- Post updated at 08:47 AM ---------- Previous update was at 08:46 AM ----------
for the third line blankspaces will be present before 23
Hi,
You can use the below command to delete the invalid line.
cat data | awk '{ if(substr($1,1,5)!="" && substr($1,6,10)!="" && substr($1,11,12)!="") print $1}' > new_filtered_file_name.
Where the data is the input file.
Thanks,
chidhu
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
i have the following problem:
use shell script:
Two directories have to be searched for files havin the same name.
then delete these files from one of these directories.
the directory names have to be accepted as command line arguments.
what i have done till now is:
1. run a loop... (1 Reply)
Discussion started by: onlyc
1 Replies
2. Shell Programming and Scripting
Hi,
I need a help in deleting a line matching a particular pattern in a file using shell script without opening the file. The file is a .c/.cpp file. Is it possible?
Thanks (6 Replies)
Discussion started by: naan
6 Replies
3. Shell Programming and Scripting
I have a set of flatfiles which have columns delimited by #. How can a particular column be deleted in all the flatfiles. All flatfiles have same number of columns. (5 Replies)
Discussion started by: rsprabha
5 Replies
4. Shell Programming and Scripting
I have written a script that deletes files:
Requirement: i need to delete the files and to know how many files are deleted i.e the count of files and even i need to display when the started time of deletion and the ending time of deletion. I need to display these two times.
script:
... (2 Replies)
Discussion started by: venkatesht
2 Replies
5. Shell Programming and Scripting
Hi,
Could any one please post the shell script for deleting the first line in a file? (3 Replies)
Discussion started by: badrimohanty
3 Replies
6. Shell Programming and Scripting
I have a small script where I want to see if a file exists & then delete the first line from it.
I have code to help me find if the file exists, but I am unsure as to how to then take in the answer and remove the first line from the flatfile:
This is what I have so far just to output if the... (3 Replies)
Discussion started by: fatalxkiss
3 Replies
7. Shell Programming and Scripting
hi, i was required to write a shell script to get yesterday's date flatfile. but i only know how to get today's date flatfile. Please observed my below scripting: Please help! Thanks
=================================================
#!/bin/sh
HOST='192.168.1.200'
USER='ftp1'... (19 Replies)
Discussion started by: lifeseries
19 Replies
8. Shell Programming and Scripting
I am compiling a synonym dictionary which has the following structure
Headword=Synonym1,Synonym2 and so on, with each synonym separated by a comma.
As is usual in such cases manual preparation of synonyms results in repeating the synonym which results in dupes as in the example below:... (3 Replies)
Discussion started by: gimley
3 Replies
9. UNIX for Dummies Questions & Answers
Hi
I have a file:
r58778.3|SOURCES={KEY=f665931a...,fw,221-705}|ERRORS={16_1:T,30_1:T,56_1:C,57_1:T,59_1:A,101_1:A,115:-,158_1:C,186_1:A,204:-,271_1:T,305:-,350_1:C,368_1:G,442_1:C,472_1:G,477_1:A}|SOURCE_1="Contig_1092402550638"(f665931a359e36cea0976db191ff60ff09cc816e)
I want to retain... (15 Replies)
Discussion started by: Alyaa
15 Replies
10. Shell Programming and Scripting
Hi,
I have a shell script which has a for loop that scans list of files and do find and replace few variables using sed command. While doing this, it deletes the last line of all input file which is something wrong. how to fix this. please suggest. When i add an empty line in all my input file,... (5 Replies)
Discussion started by: rbalaj16
5 Replies
line(1) General Commands Manual line(1)
NAME
line - read one line from user input
SYNOPSIS
timeout]
DESCRIPTION
copies one line (up to a new-line) from the standard input and writes it on the standard output. It returns an exit code of 1 on EOF and
always prints at least a new-line. It is often used within shell files to read from the user's terminal.
Options
recognizes the following command-line option:
Timeout after
timeout seconds where timeout is an integer value (if a non-integer value is specified, it is converted to an integer;
i.e., rounded down). A blank is required between and the timeout argument. This option is not documented in POSIX and
other industry standards, and should not be used in portable applications.
EXTERNAL INFLUENCES
International Code Set Support
Single- and multi-byte character code sets are supported.
EXAMPLES
The following lines in a shell script prompt for a file name and display information about the file:
To limit the response time to 10 seconds, use the form:
then test for no response. If no response occurs before timeout expires, a default behavior should be provided.
WARNINGS
This command is likely to be withdrawn from X/Open standards. Applications using this command might not be portable to other vendors' sys-
tems. As an alternative is recommended.
SEE ALSO
sh(1), read(2).
STANDARDS CONFORMANCE
line(1)