Hi,
In ksh, I have a file with similar rows as follows:
Department = 1234 G/L Asset Acct No = 12.0000. 2/29/2008
Department = 1234 G/L Asset Acct No = 13.0000. 3/29/2008.
I want to create a new text file that contains only the numbers and date:
1234 12.0000. 2/29/2008
1234 13.0000. ... (16 Replies)
I have huge fixed width, text file in unix box and I need to extract columns found between the width 105 and 200 and output it to a new file.
Can anyone tell me how to extract it?
Thanks for your help. (1 Reply)
Hi All,
I have 2 issues while working with file.
1. I have 2 delimited(~) files. I want to extract column numbner 3 from file1 and column number 8 from file2 and paste it into file3. I have tried using cut, but not able to get answer.
2. i have 2 filxed-width file. I wanted to do same... (1 Reply)
I need to extract information (for example, file owner, directory path, etc). However, the code below does not work? What is wrong?
find /usr/local/www/apache22/data/dev/chown_test -ls
for i in *
do
cut -f 1,2 "$i" | echo
done (3 Replies)
Hi All,
Could you please help me with following:
I have to parse a .csv file.
For example: If the csv file contains 3 columns, then i have to print the column names. The field separator is (comma).
example.csv (contains 2 lines as follows)
This is,a test file, for validation... (2 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)
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)
Hello,
I want to concatenate 2-columns by 2-columns separated by colon. How can I do so? For example, I have a text file containing 6 columns separated by tab. I want to concatenate column 1 and 2; column 3 and 4; column 5 and 6, respectively, and put a colon in between.
input file:
1 0 0 1... (10 Replies)
I have a comma delimited file as per the one below and I am currently extracting the values in 2 columns (COL1 & COL6) to produce a smaller trimmed down version of the file which only contains the columns we need;
COL1,COL2,COL3,COL4,COL5,COL6,COL7,COL8,COL9... (1 Reply)
Kindly help merging information from two files with the following data structure.
I want to match for the CHR-SNP in Foo and get the columns that match from CHROM-rsID
Fields 1 & 2 of foo may have duplicates, however, a joint key of Fields $1$2$3$4 is unique.
Also would be helpful to clean up... (4 Replies)
Discussion started by: genehunter
4 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)