Formatting a string


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Formatting a string
# 1  
Old 11-17-2010
Formatting a string

hi,
i am relatively new to unix. i have a doubt

i have a string in the format "2010-10-27 15:03:56"
i need to format that to "10/27/2010 15:03:56" this format
how to do that in unix script ?



any help is appreciated..
# 2  
Old 11-17-2010
Code:
SRC="2010-10-27 15:03:56"
DEST=`echo $SRC | ( IFS="- " read Y M D rest; echo "$D/$M/$Y $rest" )`

# 3  
Old 11-17-2010
also try:
Code:
var="2010-10-27 15:03:56"
newvar=$(echo "$var"  | tr -s  '-'   '/'  )

UNIX usually has several ways to do one thing - pick the one you like.
# 4  
Old 11-17-2010
OP also wanted to translate from YMD to DMY format
# 5  
Old 11-17-2010
Good point my example is wrong in that case.
# 6  
Old 11-17-2010
with GNU date

Code:
date -d "2010-10-27 15:03:56" "+%m/%d/%Y %H:%M:%S"

# 7  
Old 11-18-2010
just one more

Code:
S="2010-10-27 15:03:56"
DEST="${S:8:2}/${S:5:2}/${S::4} ${S#* }"

Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

sed or awk command to replace a string pattern with another string based on position of this string

here is what i want to achieve... consider a file contains below contents. the file size is large about 60mb cat dump.sql INSERT INTO `table1` (`id`, `action`, `date`, `descrip`, `lastModified`) VALUES (1,'Change','2011-05-05 00:00:00','Account Updated','2012-02-10... (10 Replies)
Discussion started by: vivek d r
10 Replies

2. Shell Programming and Scripting

to extract string from main string and string comparison

continuing from my previous post, whose link is given below as a reference https://www.unix.com/shell-programming-scripting/171076-shell-scripting.html#post302573569 consider there is create table commands in a file for eg: CREATE TABLE `Blahblahblah` ( `id` int(11) NOT NULL... (2 Replies)
Discussion started by: vivek d r
2 Replies

3. Shell Programming and Scripting

help formatting

I need to format a txt file and convert it in CSV. Any "future" column is separated by a newline. FROM: XS1 1.43294 0.0 XS2 1.21824 0.0 TO: XS1,XS2 (2 Replies)
Discussion started by: alfreale
2 Replies

4. UNIX for Dummies Questions & Answers

string formatting

how can I format this so the output looks like so: 811420 -rwx------ 1 cw33221 student 8952 Jan 26 2011 a.out I keep getting this 811420 -rwx------ 1 cw33221 student 8952 Jan 26 17:31 a.out Here's the code I want to minuplate: printf( "%d\t" , info_p->st_ino); (4 Replies)
Discussion started by: l flipboi l
4 Replies

5. Shell Programming and Scripting

String formatting using awk printf

Hi Friends, I am trying to insert lines of the below format in a file: # x3a4914 Joe 2010/04/07 # seh Lane 2010/04/07 # IN01379 Larry 2010/04/07 I am formatting the strings as follows using awk printf: awk 'printf "# %s %9s %18s\n", $2,$3,$4}' ... (2 Replies)
Discussion started by: sugan
2 Replies

6. Shell Programming and Scripting

String formatting using AWK

Hi, I need to insert a line at a particular line number. I am using the below code: sed $REV_LINO_NO" i\\ # $CURRENT_DATE $NAME Changed pwd for cindy\'s id" file > file1 This code works, but the formatting is not as I expected. For example, I get lines as shown below... (2 Replies)
Discussion started by: sugan
2 Replies

7. Shell Programming and Scripting

Help formatting a string. Something like printf?

Hi I'm having a problem with converting a file: ID X 1 7 1 8 1 3 2 5 2 7 2 2 To something like this: ID X1 X2 X3 1 7 8 3 2 5 7 2 I've tried the following loop: for i in `cat tst.csv| awk -F "," '{print $1}'| uniq`;do grep -h $i... (4 Replies)
Discussion started by: flotsam
4 Replies

8. Shell Programming and Scripting

SH string formatting

Hi all, my syslog.txt is a file like this: Jan 20 10:55:19 cerbero | process1: process1.--: |Info |xyxyxyxyxyxyxx | Jan 20 10:59:45 cerbero | processlong2 : threadlong1.0 : |Info |ughxueeughxueeuxexuexueuxexuexue | I need a .sh script to print to screen something like this. Jan... (3 Replies)
Discussion started by: ric79
3 Replies

9. Shell Programming and Scripting

awk printf formatting using string format specifier.

Hi all, My simple AWK code does C = A - B If C can be a negative number, how awk printf formating handles it using string format specifier. Thanks in advance Kanu :confused: (9 Replies)
Discussion started by: kanu_pathak
9 Replies

10. UNIX for Dummies Questions & Answers

formatting

Hi Again Guys , Please i installed linux RH 6.1 on Toshiba , 10G , RAM=128 , 600 MHZ . After i installed linux i got many error messages , seems it was not installed correctly , also when i finished installation it did not ask me for the 2nd installation CD , and when i logged as root , i... (5 Replies)
Discussion started by: tamemi
5 Replies
Login or Register to Ask a Question