Login or Register to Ask a Question and Join Our Community


UNIX for Beginners Questions & Answers

Changing date format with script

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums UNIX for Beginners Questions & Answers Changing date format with script
# 1  
Old 07-24-2017
Apple Changing date format with script
I'm trying to change date format using this script from day/month/year to month/day/year

Code:
#!/bin/bash

while read line; do
echo "$line"
date=$(echo "$line" | cut -d/ -f1 )
month=$(echo "$line" | cut -d/ -f2 )
echo $month"/"$date"/2017"
done < ~/Downloads/Dates.csv

But I get output as //2017 instead of 03/02/2017(example) not sure why date and month field are not populated. Sample output.

Code:
/ / 2017  
/ / 2017
/ /2017
/ / 2017


Moderator's Comments:
Mod Comment Please use CODE tags as required by forum rules!
Last edited by sharat; 07-25-2017 at 04:47 PM.. Reason: Added CODE tags.
# 2  
Old 07-24-2017
Welcome to the forum.

Running your script on a file I get exactly what you want. So - is it possible the input file has invisible (control-) characters? Post the result of
Code:
od -tx1c file

.
# 3  
Old 07-24-2017
Thanks for reply.

Here is the screenshot of the output I get

Image

Quote:
Originally Posted by RudiC
Welcome to the forum.

Running your script on a file I get exactly what you want. So - is it possible the input file has invisible (control-) characters? Post the result of
Code:
od -tx1c file

.
# 4  
Old 07-25-2017
I didn't see your screenshot. Could you instead place your result between the code tags (the "CODE" button above the editing box), please?

Andrew
# 5  
Old 07-25-2017
Updated the output , can you please let me know
# 6  
Old 07-26-2017
As previously requested, please post the output (wrapped in CODE tags) from the command od -tx1c ~/Downloads/Dates.csv

Please add a new post to the thread rather than editing previous posts, because that can be very confusing when you try to read the conversation not knowing what has been changed.



Kind regards,
Robin
This User Gave Thanks to rbatte1 For This Post:
drl
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Changing date format

how do i change the following to show me what the date was 7 days ago? date +%Y-%m-%d (1 Reply)
Discussion started by: SkySmart
1 Replies

2. Shell Programming and Scripting

Changing the date format

Hi all, I have a file with below data af23b|11-FEB-12|acc7 ad23b|12-JAN-12|acc4 as23b|15-DEC-11|acc5 z123b|18-FEB-12|acc1 I need the output as below:-(date in yyyymmdd format) af23b|20120211|acc7 ad23b|20120112|acc4 as23b|20111215|acc5 z123b|20120218|acc1 Please help me on this.... (7 Replies)
Discussion started by: gani_85
7 Replies

3. Shell Programming and Scripting

Changing the date format in a script

Hi, I run a script which outputs various records, anyway one of the columns contains the date in the format DDMMYYYY, I would like to make this DDMMYY. Is there an easy way to do this, (11 Replies)
Discussion started by: mcclunyboy
11 Replies

4. UNIX for Dummies Questions & Answers

Changing from Excel date format to MySQL date format

I have a list of dates in the following format: mm/dd/yyyy and want to change these to the MySQL standard format: yyyy-mm-dd. The dates in the original file may or may not be zero padded, so April is sometimes "04" and other times simply "4". This is what I use to change the format: sed -i '' -e... (2 Replies)
Discussion started by: figaro
2 Replies

5. Shell Programming and Scripting

Changing Date format

How to change a date stored in a variable to YYYYMMDD. Variable output is in DD-MON-YY,required format is 'YYYYMMDD' Thanks, Sud (1 Reply)
Discussion started by: sud
1 Replies

6. Shell Programming and Scripting

Changing date format

Hi, I have a column in a table of Timestamp datatype. For Example : Var1 is the column 2008-06-26-10.10.30.2006. I have Given query as date(var1) and time (var1) I got the file as in the below format : File1: Col1 Col2 2008-06-02|12.36.06 2008-06-01|23.36.35 But the problem is... (7 Replies)
Discussion started by: manneni prakash
7 Replies

7. Post Here to Contact Site Administrators and Moderators

changing the format of date

In my shell script i have a variable which stores date in the format of YYYYMMDD. Is there any way to format this value to MM/DD/YYYY. Thanks. (1 Reply)
Discussion started by: nasirgondal
1 Replies

8. UNIX for Dummies Questions & Answers

Changing the format of date

Hi, There are lots of threads about how to manipulate the date using date +%m %....... But how can I change the default format of the commad date? $ date Mon Apr 10 10:57:15 BST 2006 This would be on fedora and SunOs. Cheers, Neil (4 Replies)
Discussion started by: nhatch
4 Replies

9. Shell Programming and Scripting

Changing date format

Hi, Is there any way to change one date format to another ?? I mean I have a file having dates in the format (Thu Sep 29 2005) ... and i wud like to change these to YYYYMMDD format .. is there any command which does so ?? Or anything like enum which we have in C ?? Thanks in advance, ... (5 Replies)
Discussion started by: Sabari Nath S
5 Replies

10. Shell Programming and Scripting

Changing the date format

Hi, I know there is a Q/A section and lots of posts regarding date command here. I am sorry to start a new thread. I am very new to shell scripting (actually i am working on my first program), so please forgive my ignorance. I could not find an answer to my problem else where so i posted it... (10 Replies)
Discussion started by: Dream86
10 Replies
Login or Register to Ask a Question