Reformatting single column text file starting new line when finding particular string
Hi, I have a single colum file and I need to reformat the file so that it creates a new line every time it come to an IP address and the following lines are corresponding rows until it comes to the next IP address.
What would be the most succinct way of doing this (preferably in 1 line, maybe 2):
searching the first 10 characters of every line in a text file for a specific string, and if it was found, print out characters 11-20 of the line on which the string was found.
In this case, it's known that there... (13 Replies)
Hi,
I need to find out the last column value from a text file which is delimited by a tab.
The issue here is the last column# for each record can be different i.,e, 1st record can have the last column as 15 and the second record can have the last column as "17".
I have to search a string... (3 Replies)
Can any one tell me how to get the second last column value from the text file, which has different record size for each record.
I know how to get the last column using awk and print statements, but I am unable to get the second last column value from the file. (4 Replies)
Can someone tell me how I can do this?
e.g:
Say file1.txt contains:
today is monday
the 22 of
NOVEMBER
2010
and file2.txt contains:
the
11th
month
of
How do i replace the word NOVEMBER with (5 Replies)
Hi all,
I have an input file like
1,date,company,,
1,date,comapny,,
2,000,,,567,ACT,00,,,,KKG,M1,D45,,67J,+4500000000
2,000,,,567,ACT,00,,,,KKG,M6,D49,,56J,+6000
2,000,,,567,ACT,00,,7,,KKG,M3,D58,,68h,-70000
2,000,,,567,ACT,00,,,,KKG,M9,D95,,34m,0.00
3,total
what i require is
1.I... (2 Replies)
Hello everyone!
As the heading reads, I would like to sort the lines of a text file, starting at a specific column (i.e. skip the first X characters of each line).
What I’m actually trying to sort is the md5 sums file of a directory. Every time I copy a new file to that directory, I perform... (3 Replies)
Hi,
I have a requirement with,
No~Dt~Notes
1~2011/08/1~"aaa
bbb
ccc
ddd
eee
fff
ggg
hhh"
Single column alone got splitted into multiple lines.
I require the output as
No~Dt~Notes
1~2011/08/1~"aaa<>bbb<>ccc<>ddd<>eee<>fff<>ggg<>hhh"
mean to say those new lines to be... (1 Reply)
Hi All,
Can you please guide me to search a string in a particular column of file and return the line number of the line where it was found using awk. As an example :
abc.txt
7000,john,2,1,0,1,6
7001,elen,2,2,0,1,7
7002,sami,2,3,0,1,6
7003,mike,1,4,0,2,1
8001,nike,1,5,0,1,8... (3 Replies)
I would like to add a line to the end of a single column text file. How do I go about doing that?
Input:
BEGIN
1
2
3
Output:
BEGIN
1
2
3
END
Thanks! (1 Reply)
Discussion started by: evelibertine
1 Replies
LEARN ABOUT HPUX
newform
newform(1) General Commands Manual newform(1)NAME
newform - change or reformat a text file
SYNOPSIS
[file]...
DESCRIPTION
reads lines from the named files, or standard input if no input file is named, and reproduces the lines on standard output. Lines are
reformatted in accordance with command line options in effect.
Command line options can appear in any order, can be repeated, and can be intermingled with the optional files. Command line options are
processed in the order specified. This means that option sequences such as yield results different from Options are applied to all files
on the command line.
Options
recognizes the following options:
Same as except characters are appended to the end of a line.
Truncate n characters from the beginning of the line when the line length is greater than the effective line length (see The
default is to truncate the number of characters necessary to obtain the effective line length. The default value is
used when with no n is used. This option can be used to delete the sequence numbers from a COBOL program as follows:
The must be used to set the effective line length shorter than any existing line in the file so that the option is
activated.
Change the prefix/append character to
k. The default character for k is a space.
Same as except that characters are truncated from the end of the line.
Write the tab specification format line on the standard output
before any other lines are output. The tab specification format line which is printed will correspond to the format
specified in the option. If no option is specified, the line which is printed contains the default specification of
Input tab specification:
expands tabs to spaces, according to the tab specifications given. The tabspec recognizes all tab specification
forms described in tabs(1). In addition, tabspec can be in which assumes that the tab specification is to be found
in the first line read from the standard input (see fspec(4)). If no tabspec is given, tabspec defaults to A tabspec
of expects no tabs; if any are found, they are treated as
Set the effective line length to
n characters. If n is not entered, defaults to 72. The default line length without the option is 80 characters.
Note that tabs and backspaces are treated as single characters (use to expand tabs to spaces).
Output tab specification:
replaces spaces with tabs, according to the tab specifications given. The tab specifications are the same as for If
no tabspec is given, tabspec defaults to A tabspec of means that no spaces will be converted to tabs on output.
Prefix n characters (see to the beginning of a line when the line length is less than the effective line length. The
default is to prefix the number of characters necessary to obtain the effective line length.
Shear off leading characters on each line up to the first tab and
place up to 8 of the sheared characters at the end of the line. If more than 8 characters (not counting the first
tab) are sheared, the eighth character is replaced by a and any characters to the right of it are discarded. The
first tab is always discarded.
An error message and program exit occur if this option is used on a file without a tab on each line. The characters
sheared off are saved internally until all other options specified are applied to that line. The characters are then
added at the end of the processed line.
For example, to convert a file with leading digits, one or more tabs, and text on each line, to a file beginning with
the text, all tabs after the first expanded to spaces, padded with spaces out to column 72 (or truncated to column
72), and the leading digits placed starting at column 73, the command would be:
RETURN VALUE
returns one of the following values:
No errors encountered.
An error occurred.
DIAGNOSTICS
All diagnostics are fatal.
was called with a bad option.
There was no tab on one line.
Self-explanatory.
A line exceeds 512 characters
after being expanded in the internal work buffer.
A tab specification is incorrectly formatted,
or specified tab stops are not ascending.
A tabspec read from a file (or standard input) must not contain a tabspec referencing another file (or standard input).
WARNINGS
normally only keeps track of physical characters; however, for the and options, keeps track of backspaces in order to line up tabs in the
appropriate logical columns.
does not prompt the user if a tabspec is to be read from the standard input (by use of or
If the option is used, and the last option specified was and was preceded by either a or a the tab specification format line will be incor-
rect.
SEE ALSO csplit(1), tabs(1), fspec(4).
newform(1)
10-21-2011
