10 More Discussions You Might Find Interesting
I wanted to sort the below data on 4th field(comma seperator) based on month and date and time on AIX OS.
3,AJ,30 Jul 06:30,30 Jul 06:30
5,AJ,30 Jul 06:30,30 Jul 06:49
10,AJ,30 Jul 06:30,02 Jan 05:41
4,AJ,30 Jul 06:30,30 Jul 06:36
2,AJ,30 Jul 06:30,28 Jul 06:45
9,AJ,30 Jul... (2 Replies)
Discussion started by: Amit Joshi
2. Shell Programming and Scripting
I am trying to remove the date field from the following string. ODS_EPP_COVRG_STN_DETL_FILE_10032014.TXT. My output should be ODS_EPP_COVRG_STN_DETL_FILE.TXT
I tried couple of things:
echo ODS_EPP_COVRG_STN_DETL_FILE_10032014.TXT|sed 's/_*\.*//g'
I am getting:... (9 Replies)
Discussion started by: skatpally
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
4. Shell Programming and Scripting
In a field, I should receive the date with time stamp in a particular field. But sometimes the vendor sends just the date or the timestamp or correctl the date×tamp. I have to figure out the the data is a date or time stamp or date×tamp.
If it is date then append "<space>00:00:00"... (1 Reply)
Discussion started by: machomaddy
5. UNIX for Advanced & Expert Users
from this input
i want output as
basically input is in ddmmyyyy format and i was to convert it to yyyymmdd format (1 Reply)
Discussion started by: manishma71
6. Shell Programming and Scripting
I have a data file. Seperated by "|". The 19 th filed is a date field that occurs like this
i need to convert into the below format
o/p should be
can somebody throw some light (5 Replies)
Discussion started by: dsravan
7. Shell Programming and Scripting
I have a set of columns in a csv file, my first row being an integer and 2nd being a date. I want to first sort it using the first column and then by the second.
for e.g. i have ,
i tried this... (5 Replies)
Discussion started by: sweta_doshi
8. Shell Programming and Scripting
I have a pecular issue in sorting these files in Solaris environment.
All the below files are modified on November 4th, but I want to sort these files as per date column (eg: 01May07_1623 = ddmmmyy_hhmm)
Nov 4 18:27 SONYELEC00.GI22973.01May07_1623.gpg
Nov 4 18:27... (4 Replies)
Discussion started by: shivaastrogun
9. Shell Programming and Scripting
If I have a flat file
How can I create an output
1|SFO|02/24/2006 12:12:34|hawkeye|35|M... (6 Replies)
Discussion started by: sabercats
10. UNIX for Dummies Questions & Answers
In the shell which have the command prompt '$' ( Sorry i dunno wat shell is this), is there anyway to handle date input?
Coz i need to accept a date from the user and wat i use is:
read day;read month; read year;
In this case user need to enter 3 time, is it any better way?
Summore, is... (1 Reply)
Discussion started by: AkumaTay