07-21-2010
change field 2 date format
from this input
WEBELSOLAR,29122009,1:1
WIPRO,15062010,2:3
ZANDUREALT,18012007,1:3
i want output as
WEBELSOLAR,20091229,1:1
WIPRO,20100615,2:3
ZANDUREALT,20070118,1:3
basically input is in ddmmyyyy format and i was to convert it to yyyymmdd format
10 More Discussions You Might Find Interesting
1. Solaris
dear members,
ls -l
drwxr-xr-x 40 root sys 1024 Jul 11 22:19 usr
drwxr-xr-x 43 root sys 1024 Feb 1 2009 var
i am using solaris 10
is that possibe to do
drwxr-xr-x 40 root sys 1024 25-08-2009 22:19 usr
drwxr-xr-x 43 root sys ... (4 Replies)
Discussion started by: hosney00ux
4 Replies
2. Shell Programming and Scripting
Hi Everyone,
# cat 1.txt
1321631,77770132976455,19,20091001011859,20091001011907
1321631,77770132976455,19,20091001011859,20091001011907
1321631,77770132976455,19,20091001011859,20091001011907
# cat 1.txt | awk -F, '{OFS=",";print $1,$3,$4,$5}'
1321631,19,20091001011859,20091001011907... (7 Replies)
Discussion started by: jimmy_y
7 Replies
3. Shell Programming and Scripting
Hi I have a date format in a variable as Mon Jan 11 03:35:59 2010. how do i change it to YYYYMMDD format (3 Replies)
Discussion started by: keerthan
3 Replies
4. Shell Programming and Scripting
Hi guys,
I have a text file with lots of lines like this:
MCOGT23R27815 27/07/07 27/05/09
SO733AM0235 30/11/07 30/11/10
NL123403N 04/03/08 04/03/11
0747AM7474 04/04/08 04/04/11
I want to change each line so the date format looks like this:
MCOGT23R27815 07/07/27 09/05/27 ... (7 Replies)
Discussion started by: Tornado
7 Replies
5. Shell Programming and Scripting
Hi Guys,
I had a scenario like this..
It seems very silly...dont think it as a home work question.....:)
i tried it many ways but i didn't achieve this...
start_date=May122011
here i want to change the start_date in to 20110512
start_date=20110512
tell me how can we achive... (5 Replies)
Discussion started by: apple2685
5 Replies
6. Shell Programming and Scripting
Dear Friends,
Need your help once again,
I have a variable ( e.g. ${i}) whoch has date in MM/DD/YYYY (E.g. 12/31/2011) format.
I want to change it to DD/MM/YYYY (e.g. 31/12/2011) format.
Request you to guide me as we are unable to do the same.
Thanks in advance
Anu. (1 Reply)
Discussion started by: anushree.a
1 Replies
7. Shell Programming and Scripting
Hi,
I was looking for a script to change the date from one format to other. A search in the forum gave me the below script as a result.
#! /bin/ksh
format=YYYYMMDD
YEAR=${format%????}
DAY=${format#??????}
MON=${format#$YEAR}
MON=${MON%$DAY}
echo $MON/$DAY/$YEAR
I got it... (2 Replies)
Discussion started by: prithvirao17
2 Replies
8. Linux
I have a .CSV file (file.csv) whose data are all enclosed in double quotes. Sample format of the file is as below:
column1,column2,column3,column4,column5,column6, column7, Column8, Column9, Column10
"12","B000QRIGJ4","4432","string with quotes, and with a comma, and colon: in... (3 Replies)
Discussion started by: dhruuv369
3 Replies
9. Shell Programming and Scripting
need some more help please
i have a large file and
i want to change just the date format
with awk or sed
from this
yyyy-mm-dd
2016-04-15 8.30
2016-04-15 7.30
2016-04-13 7.30
2016-04-11 8.30
2016-04-11 7.30
2016-04-08 8.30
2016-04-08 7.30
2016-04-06... (5 Replies)
Discussion started by: bob123
5 Replies
10. UNIX for Advanced & Expert Users
Hi,
I have two (2) things that I want to do.
First is to change the date format that is in the nth field from MM/DD/YY to YY/MM/DD. Preferably, I wish I know how to make it a 4-digit year but I don't. Problem is I can only assume it is a 20 century
Second is somehow know how to figure out... (1 Reply)
Discussion started by: newbie_01
1 Replies
LEARN ABOUT OPENDARWIN
auconvert
AUCONVERT(1) General Commands Manual AUCONVERT(1)
NAME
auconvert - perform various conversion operations on sound files
SYNOPSIS
auconvert [-file <format>] [-data <format>] [-rate <sample rate>] [-comment <comment>] [-raw <data format> <num tracks>] [-volume <per-
cent>|`max'] [-?] [<input file>] [<output file>]
DESCRIPTION
The auconvert program can be used to convert from one sound file format, and/or data format to another. It can also change the comment,
sampling rate, and volume of a sound file. Finally, auconvert can be used to convert raw audio data into a sound file. If no input file
name is given, standard input will be used. If no output file name is given, the original file will be replaced by the converted file or
standard out will be used if the input is coming from standard input.
OPTIONS
The following options may be used with auconvert:
-file format
The output file format. The -? option will display a list of valid file formats.
-data format
The output data format. The -? option will display a list of valid data formats. Note that each file format may only support
selected data formats.
-rate sample rate
The output sampling rate (in hertz).
-comment comment
The comment to be stored in the output file.
-volume <percent>|`max'
The volume option can be used in two ways. If the argument is a percentage, the output file volume will be converted to the speci-
fied percentage of the input volume. If the argument is the string `max', the output file volume will be converted to its maximum
level.
-raw <data format> <num tracks>
This option is used to convert raw audio data into a sound file. <data format> is the data format of the raw data. <num tracks>
specifies the number of tracks in the raw data. You must also use the -file and -rate options when converting raw data.
-? Displays a usage message and a list of supported file and data formats.
SEE ALSO
nas(1), auedit(1)
COPYRIGHT
Copyright 1993, 1994 Network Computing Devices, Inc.
AUTHOR
Greg Renda, Network Computing Devices, Inc.
1.9.3 AUCONVERT(1)