I have a input file that has some common values in 1st,2nd and 3rd columns. 4th and 5th are different. Now I would like to print the mean of the fourth column of similar values in 1st.2nd and 3rd columns along with all the values in 5th column.
hi All,
Thi sis very urgent.
I have large files with pipe delimited.
For example:
1.txt
1001024|120|9|-0.0|#|
1001025|120|9|#|
1001026|120|9|#|
1001032|120|2|-0.0|#|
1002026|110|9|#|
1002027|110|9|-0.0|#|
1002028|120|1|1.0|#|
I need to replace the 4th filed if it is # by |-|
my... (2 Replies)
HELLO! This is my first post here! By the way, I think it is great that people do this.
My question:
I have two files, one is a .dilm and one is a .txt. It is my understanding that the .dilm file can be treated as a .txt file. I wrote another program where I was able to manipulate it as if it... (3 Replies)
I have this space delimited large text file with more than 1,000,000+ columns and about 100 rows. I want to delete all the columns that start with NA such that:
File before modification
aa bb cc NA100 dd
aa b1 c2 NA101 de
File after modification
aa bb cc dd
aa b1 c2 de
How would I... (3 Replies)
Hello,
i need to get the ls output in 2 columns.1st column the directories and 2nd the files...
Also each column must be sorted by time...
For example if the >>ls command gives me this :
/dir2 /dir /dir1
/dir3 file1 file2
I need to take this :
/dir file1
/dir1 ... (15 Replies)
Hi group,
Can you please tell how to delete specific columns from a file.
I know something like
awk -F, '{ print $1" "$2" "15 }' input.txt > output.txt will delete all other columns. But this is in a way to copy some particular columns.
But is there any other way to select just some... (11 Replies)
I am trying to find a specific set of characters in a long file. I only want to find the characters in column 265 for 4 bytes.
Is there a search for that? I tried cut but couldn't get it to work.
Ex. I want to find '9999' in column 265 for 4 bytes. If it is in there, I want it to print... (12 Replies)
Hi
I have a file which is tab-delimited. Now, I'd like to print the lines which have "chr6" string in both first and second columns. Could anybody help? (3 Replies)
Hi,
I'd like to intersect two files by the 4th col of the first file and 6th col of the second file. This is the code I use:
awk 'NR==FNR{A;next}$6 File1 File2
However, this is only outputting the second file lines. I'd like to have both lines in a single line separated by a tab.
Thanks in... (25 Replies)
I am trying to search a list of strings from a file and display the string as well as the column in the search file it was found. I dont care about the row. what is wrong with my script?
while read line; do awk -v var="$line" '{for(i=1;i<NF;i++) if ($NF==$var) break; print $var FS $NF' }'... (3 Replies)
i have a file (csv or txt or anything which has 4 columns (id,name,number,location) and it contains data. i want to convert the data of specific columns like name to ooooo and number to 88888 matching the field length of that columns.
for example
if name column has
anthony which is 7, it should... (2 Replies)
Discussion started by: prajaktaraut
2 Replies
LEARN ABOUT DEBIAN
mhc
mhc(5) File Formats Manual mhc(5)NAME
mhc - Message Harmonized Calendaring system
DESCRIPTION
This manual page documents briefly the mhc file format. This manual page was written for the Debian GNU/Linux distribution because the
original program does not have a manual page.
FIELDS
Mhc file format is based on STD11/RFC822: Standard for the format of ARPA Internet text messages. In mhc file, the following extra header
fields are used.
X-SC-Day:
Date of event in format yyyymmdd. You can specify multiple date with space separated like:
X-SC-Day: 19990409 19990413
which means April 9th 1999 and April 13th 1999.
X-SC-Time:
Time of event in format hh:mm-hh:mm or hh:mm. For event which has no meanings about time, you can leave it empty in this field.
X-SC-Duration:
Period of event in yyyymmdd-yyyymmdd. You can omit start date or end date, like "19991121-". X-SC-Duration: is used only to limit
date specified by X-SC-Day: or X-SC-Cond, so you can't describe event date only by X-SC-Duration:. If X-SC-Duration: is empty, it
means no limit.
X-SC-Cond:
Condition of event date by using following keyword.
00-31 Day of month.
1st 2nd 3rd 4th 5th Last Week in month.
Sun Mon ... Sat Day of week.
Jan Feb ... Dec Month
Examples,
X-SC-Cond: Tue Fri
Every Tuesday and Friday.
X-SC-Cond: 31 Aug
Every August 31th.
X-SC-Cond: 1st 3rd Fri
Every 1st and 3rd Friday.
X-SC-Cond: Fri
X-SC-Day: !19990409
Every Friday, but except April 9th 1999.
X-SC-Cond: Fri 13
Every 13th and Every Friday, not 13th Friday.
X-SC-Alarm:
Hint for alarm of event. Currently, mhc.el doesn't alaram, but gemcal will pop-up alarm window. It will be useful if you transfer
this event to PalmOS. In X-SC-Alarm:, you can specify the number (1 to 99) with suffix such as minute, hour or day. For example,
X-SC-Alarm: 10 minutes
Alarm 10 minutes before event.
X-SC-Alarm: 3 hour
Alarm 3 hours before event.
X-SC-Alarm: 3 day
Alarm 3 day before event.
X-SC-Subject:
Subject of event. unstructured?
X-SC-Location:
Location of event. unstructured?
X-SC-Category
Category of event. Any keyword, space separeated. Case ignored.
X-SC-Recoard-Id:
Internal use only.
SEE ALSO adb2mhc(1)gemcal(1), mhc-sync(1), mhc2palm(1), palm2mhc(1), today(1).
AUTHOR
This program was written by Yoshinari Nomura <nom@quickhack.net> and this manual page was written by Fumitoshi UKAI <ukai@debian.or.jp>,
for the Debian GNU/Linux system (but may be used by others).
23 Jun 2000 mhc(5)