03-12-2007
HI,
Try this now...For me the spaces gets removed properly...
cat Input.txt | awk -F, '{
for(i=1;i<=NF;i++)
{
if(i<=3)
{
sub(/[ ]*$/,"",$i);
printf("%s,",$i);
}
else if(i==5)
{
split($i,temp,".");
printf("%02d:%02d,",temp[1],temp[2]);
}
else
{
printf("%s,",$i);
}
}
printf("\n");
}' > err
Thanks
Raghuram
10 More Discussions You Might Find Interesting
1. UNIX for Advanced & Expert Users
:) Hi
i am trying to convert a file which is in UTF8 format to ANSI format i tried to use the function ICONV but it is throwing error
Function i used it as
$ iconv -f UTF8 -t ANSI filename
Error iam getting is NOT Supported UTF8 to ANSI
please some help me out on this.........Let me... (1 Reply)
Discussion started by: rajreddy
1 Replies
2. UNIX for Dummies Questions & Answers
:confused: Hi
i am trying to convert a file which is in UTF8 format to ANSI format i tried to use the function ICONV but it is throwing error
Function i used it as
$ iconv -f UTF8 -t ANSI filename
Error iam getting is NOT Supported UTF8 to ANSI
please some help me out on... (9 Replies)
Discussion started by: rajreddy
9 Replies
3. UNIX for Dummies Questions & Answers
Hi
I have a file which has ascii , binary, binary decimal coded,decimal & hexadecimal data with lot of special characters (like öƒ.ƒ.„İİ¡Š·œƒ.„İİ¡Š· ) in it. I want to standardize the file into ASCII format & later use that as source .
Can any one suggest a way a logic to convert such... (5 Replies)
Discussion started by: gaur.deepti
5 Replies
4. Shell Programming and Scripting
HI guys,
I have created a script to read 1 column in a csv file and then place it in text file.
However, when i checked out the text file, it is not in a column format...
Example:
CSV file contains
name,age
aa,11
bb,22
cc,33
After using awk to get first column
TXT file... (1 Reply)
Discussion started by: mdap
1 Replies
5. Shell Programming and Scripting
I have a file named "suspected" with series of line like these :
{'protocol': 17, 'service': 'BitTorrent KRPC', 'server': '219.78.120.166', 'client_port': 52044, 'client': '10.64.68.44', 'server_port': 8291, 'time': 1226506312L, 'serverhostname': ''}
{'protocol': 17, 'service': 'BitTorrent... (3 Replies)
Discussion started by: rk4k
3 Replies
6. UNIX for Dummies Questions & Answers
Hi All,
Is there any way to convert a file which is in UNIX format to a PC format....
Flip command can be used , apart form this command can we have any other way.... like usinf "awk" etc ..... main purpose of not using flip is that my Kshell doesnot support this comamnd.... (1 Reply)
Discussion started by: Samtel
1 Replies
7. Shell Programming and Scripting
Hi All,
Is there any way to convert a file which is in UNIX format to a PC format....
Flip command can be used , apart form this command can we have any other way.... like usinf "awk" etc ..... main purpose of not using flip is that my Kshell doesnot support this comamnd.... (2 Replies)
Discussion started by: Samtel
2 Replies
8. Shell Programming and Scripting
Hi,
I am having couple of files which i used to copy from windows to Linux, so now in case of text files (CTRL^M) appears at end of line. I know i can convert this windows format file to unix format file by running dos2unix.
My requirement here is that i want to do it automatically using a... (5 Replies)
Discussion started by: sarbjit
5 Replies
9. Shell Programming and Scripting
Hello Everyone,
I have one source file which is genarated by SAP in different format(Which I've never seen). I need to convert that file to required format and I need to read this target file from Datastage to use this in my Jobs. So I do not have any other options except to use Unix script to... (4 Replies)
Discussion started by: Prathyu
4 Replies
10. Shell Programming and Scripting
Hi ,
i am generating some data by firing sql query with connecting to the database by my solaris box.
The below one should be the header line of my excel ,here its coming in separate row.
TO_CHAR(C. CURR_EMP_NO
---------- ---------------
LST_NM... (6 Replies)
Discussion started by: dani1234
6 Replies
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)