Hi, I am trying to sort a file first by the string column, then by the number column.
file:
xyz1 2
xyzX 4
xyz2 1
xyz13 3
xyz11 5
xyz13 10
xyz1 1
xyz10 1
xyz4 2
result should be
xyz1 1
xyz1 2 ... (3 Replies)
Hi Everybody,
I am just new to UNIX as well as to this forum. I have a text file with 10,000 coloumns and each coloumn contains values separated by space. I want to separate them into new coloumns..the file is something like this
as ad af 1 A
as ad af 1 D
...
...
1 and A are in one... (7 Replies)
Hi,
I am very new to Unix script. Suppose i have a file with column header:
NAME1 NAME2 Address Tel
And I always need to make a file with column header:
ID NAME1 NAME2 EMail Address Tel
For the columns that do not exist in the file, I would still like to make a column with blank.
... (11 Replies)
I have a text file that has three columns. But at the end of the text file, there are trailing lines that have missing second and third columns:
4 0.04972604 KLHL28
4 0.0497332 CSTB
4 0.04979822 AIF1
4 0.04983331 DECR2
4 0.04990344 KATNB1
4
4
4
4
How can I remove the trailing... (3 Replies)
File will have two columns key column and second column which is pipe separated and that need to be sorted.
Below is input file.
1, D|B|A|C
2, C|A|B
3, E|A|F|G|H|D|B|C
4, A|B|D|C|F
Output should be
1, A|B|C|D
2, A|B|C
3, A|B|C|D|E|F|G|H
4, A|B|D|C|F (11 Replies)
Hi,
i have a csv file which have headers and values of it like below :
headers --> CI Ref SerialNumber LastScanDate
values --> VMware-42,VMware-42,Tue, 20 May 2014 11:03:44 +0000
i want to have a above csv in below format :
headers --> CI Name CI Description CI Ref... (6 Replies)
Hello,
I have some tab delimited files that may contain blank columns. I would like to delete the blank columns if they exist. There is no clear pattern for when a blank occurs.
I was thinking of using sed to replace instances of double tab with blank,
sed 's/\t\t//g'
All of the examples... (2 Replies)
I have a file with the following format:
X|High|2|GIC|DM||XHM|||6 Months
X|Moderate|2|GIC|DM||XHM|||6 Months
X|High|2|GCM|DM||XSF|||6 Months
X|Med|2|GCM|DM||XSF|||6
Here there are ten columns but I need to print rows having blank records in any of the rows (except for 6th,8th and 9th... (10 Replies)
I've spent the past hour trying different things and googling for this solution and cannot find the answer. Found variations of this, but not this exact thing.
I have the following text, which is the output from our mainframe. Each field is on a separate line, with a blank line between each... (7 Replies)
Discussion started by: lupin..the..3rd
7 Replies
LEARN ABOUT OSF1
ap
ap(8) System Manager's Manual ap(8)NAME
ap - Parses addresses RFC 822-style
SYNOPSIS
/usr/lib/mh/ap [-form file] [-format string] [-help] [-[no]normalize] [-width columns] addrs...
OPTIONS
Overrides the default output format of ap. The output is formatted according to the instructions in the specified file. This must be a
format file; see mh-format(4). Overrides the default output format of ap. The output is formatted according to the instructions in the
specified string. This must be a format string; see mh-format(4).
The argument to the -format option must be interpreted as a single token by the shell that invokes ap. Therefore, you should usually
place the argument to this option inside double quotes ("). Prints a list of the valid options to this command. The -normalize
option tells ap to try to find the official host name of the address. This is the default behavior, which can be suppressed using
the -nonormalize option. Specifies the width of the screen in columns.
DESCRIPTION
The ap program parses addresses according to the ARPA Internet standard. It also understands many nonstandard formats. It is useful for
seeing how MH will interpret an address.
The ap program treats each argument as one or more addresses, and prints those addresses in the official RFC 822 format. Hence, it is usu-
ally best to enclose each argument in double quotes (") for the shell.
In addition to the standard escapes, ap also recognizes the additional escape error, which is a diagnostic that is returned if the parsing
operation failed.
The default settings for the ap command are -normalize and -width columns, where columns is equal to the the width of the terminal.
RESTRICTIONS
On systems where MH is configured with the BERK option, address parsing is not enabled.
EXAMPLES
This is the default format string used by ap:
%<{error}%{error}: %{text}%|%(proper{text})%>
If an error was detected, the preceding string instructs ap to print the error, a colon (:), and the address that is in error. Otherwise,
the ap command output is the proper RFC 822 format of the address.
FILES
User profile. System customization file.
SEE ALSO
Commands: dp(8)
Files: mh-format(4)
Standard for the Format of ARPA Internet Text Messages (RFC 822)
ap(8)