I have a sample comma separated file as having date data in field # 5 and field #8. Field # 4 and 7 (fields before the date field) are indicators:
This is just a sample data, the actual file may have n number of date fields.
I need to update field #5 (depending on the value in field # 4 (indicator field)) and field #8 (depending on the value in field#7) and so on as :
1. If field # 4 = 0 and field # 5 <> 0 (say data is : 991213), then append '19' to the string in field # 5 and make the final value
as : 1999-12-13. This is for years before 2000
2. If field # 4 = 0 and field # 5 = 0 (say data is : 0), then the final value as : 0001-01-01
3. If field # 4 = 1, then
a. check if field # 5 has length = 5, then (for data say: 51213), append '200' so that the final value should be 2011-12-13
b. Else, (for data say : 111213), append '20' so that the final value appears as : 2011-12-13.
Input parameters to the script :
$1 : file name
$2 , $3, ........ this depends on the number of date fields which need to be transformed.
I have written the following code:
I am able to transform the data for Field # 5 only.
Could you please suggest a better approach for this requirement such that I am able to transform the data for field # 8 as well.
Hi Friends,
I'm working on a perl script, which seems to be simpler. But I'm very new to PERL scripting.
I have a comma separated data file, from which I need to extract only the seventh field data out of available twenty fields to an array using perl.
Any help would be much appreciated.
... (17 Replies)
Hi,
i want to replace comma by space for specified field in record, i mean i want to replace the commas in the 4th field by space. and rest all is same throught the record.
the record is
16458,99,001,"RIMOUSKI, QC",418,"N",7,EST,EDT,902
16458,99,002,"CHANDLER,... (5 Replies)
Guys,
Need you help, i have a a file content that look like this.
Nokia 3330 <spaces><spaces><more spaces>+76451883874
Nokia 3610 +87467361615
so on and so forth,
- there are so many spaces in between.
- e.g.... (5 Replies)
Hello Mates,
I have one txt file having commo seperated values. I have to insert string "FALSE" in 2nd field from the end. E.G
SE18 6RN,,,,5439070,1786840,,1000002148671600,123434
Out put should be:
SE18 6RN,,,,5439070,1786840,FALSE,1000002148671600,123434
Can some one help me to... (8 Replies)
Hi all,
I have the following files types:
FileA:
100,
23,
33,
FileB:
22,
45,
78,
and i want to make
File C:
100,22
23,45
33,78
any nice suggestions for making it easy. (3 Replies)
Hello there,
I have a comma separated csv , and all the text field is wrapped by double quote. Issue is some text field contain comma as well inside double quote. so it is difficult to process.
Input in the csv file is ,
1,234,"abc,12,gh","GH234TY",34
I need output like below,... (8 Replies)
Hi,
I have a filein unix like
ABC,CDE
BCD,KHL
and the output i need is like
column1 column2
ABC,CDE ABC
ABC,CDE CDE
BCD,KHL BCD
BCD,KHL KHL. Can some body help me out?
Hi,
The code is working fine. But in my file each row does not have always 1 comma. It may... (6 Replies)
Hi,
I have a large number of files which are written as csv (comma-separated values).
Does anyone know of simple sed/awk command do achieve this?
Thanks!
---------- Post updated at 10:59 AM ---------- Previous update was at 10:54 AM ----------
Guess I asked this too soon. Found the... (0 Replies)
Hi Experts,
Please support
I have below data in file in comma seperated, but 4th column is containing comma in between numbers, bcz of which when i tried to parse the file the column 6th value(5049641141) is being removed from the file and value(222.82) in column 5 becoming value of column6.
... (3 Replies)
Discussion started by: as7951
3 Replies
LEARN ABOUT HPUX
anno
ANNO(1) [nmh-1.5] ANNO(1)NAME
anno - annotate messages
SYNOPSIS
anno [+folder] [msgs] [-component field] [-inplace | -noinplace] [-date | -nodate] [-draft] [-append] [-list] [-delete] [-number [num|all]]
[-preserve | -nopreserve] [-version] [-help] [-text body]
DESCRIPTION
Anno manipulates header fields or annotations in messages. Header fields consist of a field name and an optional field body as defined by
RFC-2822. The -component option specifies the field name, and the -text option specifies the field body.
The messages are either the msgs in the named folder, or the draft if invoked with the -draft option.
Usually, annotation is performed by the commands dist, forw, and repl, if they are given the -anno switch. This allows you to keep track
of your distribution of, forwarding of, and replies to a message.
By using anno, you can perform arbitrary annotations of your own. Each message selected will be annotated with the lines
field: date
field: body
The -nodate switch inhibits the date annotation, leaving only the body annotation.
By default, anno prepends the annotations to the message. Annotations are instead appended if the -append option is specified.
If a -component field is not specified when anno is invoked, anno will prompt the user for the name of field for the annotation.
The field specified must be a valid 2822-style message field name, which means that it may only consist of alphanumerics and dashes, The
body specified is arbitrary text.
Normally anno does the annotation inplace in order to preserve any links to the message. You may change this by using the -noinplace
switch.
The -list option produces a listing of the field bodies for header fields with names matching the specified component, one per line. The
listing is numbered, starting at 1, if the -number option is also used. A tab character separates the number and the field body. The
field body is treated as if it is a file name, and only the final path name component is listed. The complete field body is listed if the
-text option is used, the contents of the text are ignored.
The -delete option removes header fields from messages. The first header field whose name matches the component is deleted if no other
options are specified. If the -text option is used in conjunction with the -delete option, the first header field whose name matches the
component and whose body matches the text is deleted. The text is treated as if it was a file name; if it begins with a slash, the entire
field body must match the text, otherwise just the last path name component of the field body must match. If the -number option is used in
conjuction with the -delete option, header field num whose name matches the component is deleted. The number matches that which is pro-
duced by the -list option. The special value all can be used for the number, and causes all components that match the name to be deleted.
By default, anno changes the last-accessed and last-modified times on annotate messages to the time at which the annotation occurs. Anno
preserves the original times if the -preserve option is used. A matching -nopreserve option exists that allows time preservation to be
turned off if enabled in the profile.
FILES
$HOME/.mh_profile The user profile
PROFILE COMPONENTS
Path: To determine the user's nmh directory
Current-Folder: To find the default current folder
SEE ALSO dist(1), forw(1), repl(1)DEFAULTS
`+folder' defaults to the current folder
`msgs' defaults to cur
`-inplace'
`-date'
CONTEXT
If a folder is given, it will become the current folder. The first message annotated will become the current message.
MH.6.8 11 June 2012 ANNO(1)