02-02-2012
Thanks both the code works fine
. But out of curiosity, how to handle if the first column is made of alphabets rather than numerics? In that case all records will become as a single record, correct? Sorry, if I am wrong.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi All,
I have named a file with current date,time and year as follows:
month=`date | awk '{print $2}'`
date=`date | awk '{print $3}'`
year=`date | awk '{print $6}'`
time=`date +%Hh_%Mm_%Ss'`
filename="test_"$month"_"$date"_"$year"_"$time".txt"
> $filename
The file is created with a... (2 Replies)
Discussion started by: amio
2 Replies
2. Shell Programming and Scripting
Hi All,
We append the output of a file's size in a file. But a newline character is appended after the variable.
Pls help how to clear this.
filesize=`ls -l test.txt | awk `{print $5}'`
echo File size of test.txt is $filesize bytes >> logfile.txt
The output we got is,
File size of... (4 Replies)
Discussion started by: amio
4 Replies
3. Shell Programming and Scripting
Hi All,
I have 5000 records like this
Request_id|Type|Status|Priority|Ticket Submitted Date and Time|Actual Resolved Date and Time|Current Ticket Owner Group|Case final Ticket Owner Group|Customer Severity|Reported Symptom/Request|Component|Hot Topic|Reason for Missed SLA|Current Ticket... (2 Replies)
Discussion started by: j_53933
2 Replies
4. Shell Programming and Scripting
I'd like to remove (do a pattern or precise replacement - this I can handle in SED using Regex )
---AFTER THE 1ST Occurrence ( i.e. on the 2nd occurrence - from the 2nd to fourth occurance ) of a specific string : type 1
-- After the 1st occurrence of 1 string1 till the 1st occurrence of... (4 Replies)
Discussion started by: sieger007
4 Replies
5. Shell Programming and Scripting
Hi,
I have a very huge file, around 1GB of data.
I want to remove the newline characters in the file but not preceded by the original end delimiter {}
sample data will look like this
1234567
abcd{}
1234sssss
as67
abcd{}
12dsad3dad
4sdad567
abcdsadd{}
this should look like this... (6 Replies)
Discussion started by: ratheeshjulk
6 Replies
6. Shell Programming and Scripting
hi i am having delimited .dat file having content like below.
test.dat(5 line of records)
======
PT2~Stag~Pt2 Stag Test.
Updated~PT2 S T~Area~~UNCEF R20~~2012-05-24 ~2014-05-24~~
PT2~Stag y~Pt2 Stag Test.
Updated~PT2 S T~Area~METR~~~2012-05-24~2014-05-24~~test
PT2~Pt2 Stag Test~~PT2 S... (4 Replies)
Discussion started by: sushine11
4 Replies
7. UNIX for Dummies Questions & Answers
Hi friends,
I am trying to add a newline char ('\n') between the query and the commit statement in the following shell script.
#! /bin/sh
echo "select * from tab; commit;" > data.sql
I have tried typing in "Ctrl-V + Ctrl-J" combination which has inserted ^@ (NUL) character but the commit... (1 Reply)
Discussion started by: royalibrahim
1 Replies
8. Shell Programming and Scripting
Hi all..
I have a text file which looks like below:
abcd
efgh
ijkl
(blank space)
I need to remove only the last (blank space) from the file. When I try wc -l the file name,the number of lines coming is 3 only, however blank space is there in the file.
I have tried options like... (14 Replies)
Discussion started by: Sathya83aa
14 Replies
9. Shell Programming and Scripting
I have a file which comes every day and the file data look's as below.
Vi abc.txt
a|b|c|d\n
a|g|h|j\n
Some times we receive the file with only a new line character in the file like
vi abc.txt
\n (8 Replies)
Discussion started by: rak Kundra
8 Replies
10. UNIX for Beginners Questions & Answers
Hi,
I came across one issue recently where output from one of the columns of the table from where i am creating input file has newline characters hence, record in the file is spread over multiple lines. Fields in the file are separated by pipe (|) delimiter. As header will never have newline... (4 Replies)
Discussion started by: Prathmesh
4 Replies
LEARN ABOUT ULTRIX
invcutter
invcutter(1) General Commands Manual invcutter(1)
Name
invcutter - generate subset inventory files
Syntax
/usr/sys/dist/invcutter [ -d ] [ -f root-path ] [ -f version-code ]
Description
The command reads master inventory records from standard input. A subset inventory record is written to standard output for every record
read from the input. The information contained in the output record is derived from the input record and the file attribute information in
the file hierarchy rooted in the current directory.
Options
-d Enable debugging. No useful diagnostics are printed.
-f root-path Specify an alternate root path for finding file attribute information.
-v version-code Specify a 3-digit version code for use in the version field of the output records. The default version code is 010.
Restrictions
All input records must be sorted in ascending order on the pathname field.
Files described in an input record which exist as sockets in the file hierarchy are not processable.
If a file is described in an input record has a link count greater than 1, all other links to the file must be represented in the input.
Examples
The following command will generate inventory records for the master inventory entries in PDS020.mi containing version fields set to 020:
invcutter -v 020 < PDS020.mi
Return Values
An exit status of 0 is returned if all goes well. An exit status of 1 is returned if an error occurs. See Diagnostics.
Diagnostics
"cannot chdir to pathname (error-message)"
The program cannot change directories to the pathname directory specified with the -f option. The error-message will provide additional
information.
"sort error, record #n"
The nth input record is not in the correct sort order. All input records must be in ascending ASCII colating sequence on the pathname
field.
"cannot stat filename (error-message)"
An error has occurred attempting to read the attributes of filename. The error-message explains exactly what happened.
"pathname: illegal file type code 0140000"
The file pathname is a socket. Sockets are not supported as valid file types for distribution.
"unresolved nlink n: pathname"
This indicates that file pathname in the master inventory is linked to n files which do not appear in the master inventory. Check inventory
for validity with the program.
"n unresolved hard links"
This is an informational message stating how many files were detected in the input inventory which had unresolved links.
See Also
newinv(1), stl_inv(5), stl_mi(5)
Guide to Preparing Software for Distribution on ULTRIX Systems
invcutter(1)