How can I change is output format by awk ?


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting How can I change is output format by awk ?
# 1  
Old 05-08-2010
How can I change is output format by awk ?

Hello,
Can you tell me how can I change this format by awk

Input
Code:
0.2057422D-01  
0.2463722D-01
-0.1068047D-02

Output
Code:
0.02057422
0.02463722
-0.001068047

Thanks
wan

Last edited by Scott; 05-08-2010 at 05:02 AM.. Reason: Code tags
# 2  
Old 05-08-2010
Code:
 awk -FD '{print $1}' file_name

# 3  
Old 05-08-2010
Code:
sed 's/D-.*//' Input

Maybe it makes it easier for someone to "translate" it in awk...
Edit: sorry, I did not see that extra zeros Smilie

Last edited by pseudocoder; 05-08-2010 at 04:31 AM..
# 4  
Old 05-08-2010
thank you
i try to use this command

Code:
awk -FD '{print $1}' file_name

and my output is
Code:
0.2057422
0.2463722
-0.1068047

But i want this form
Code:
0.02057422
0.02463722
-0.001068047

How can i change is form by using awk
thank you very much
wan

Last edited by Scott; 05-08-2010 at 05:03 AM.. Reason: Code tags
# 5  
Old 05-08-2010
what is the logic in your output ?
# 6  
Old 05-08-2010
I'm out... Smilie

Last edited by pseudocoder; 05-08-2010 at 04:54 AM..
# 7  
Old 05-08-2010
thanks for the reply
I just want to change
From
Code:
0.2057422D-01

To
Code:
0.022057422

by using awk
Any other idea?

Thanks for this

Last edited by Scott; 05-08-2010 at 05:03 AM.. Reason: Code tags
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

Date format conversion how to change this from using nawk to awk

Hi, I have a file where I need to change the date format on the nth field from DD-MM-YYYY to YYYY-MM-DD so I can accurately sort the record by dates From regex - Use sed or awk to fix date format - Stack Overflow, I found an example using nawk. Test run as below: $: cat xyz.txt A ... (2 Replies)
Discussion started by: newbie_01
2 Replies

2. Shell Programming and Scripting

Need to change date format in a csv file using awk

Example: Input csv file 00245DLS,Sitel Ocala,12/31/2014,18:45,1.00,7.00,0.00,0.00 00245DLS,Sitel Ocala,12/31/2014,19:00,-1.00,-1.00,-1.00,-1.00 00245HB,Charlotte,01/01/2015,00:00,-1.00,-1.00,-1.00,0.00 Output csv file 00245DLS,Sitel Ocala,2014/12/31,18:45,1.00,7.00,0.00,0.00 00245DLS,Sitel... (8 Replies)
Discussion started by: adit
8 Replies

3. UNIX for Dummies Questions & Answers

Use awk to change an IP format

Basically I am trying to run a standard output of IP address with a port number into another command but I need to change it from. 74.125.224.194.80 into 74.125.224.194:80 One command wants a period before the port the subsequent one wants a colon. So is there anyway I can feed... (3 Replies)
Discussion started by: MrEddy
3 Replies

4. Shell Programming and Scripting

awk - change date format

I have below date format in a CSV file. (dd/mm/yyyy) Ex Input: 9/8/2013 Need to convert it into below format (yyyymmdd ) and redirect to new file. Ex Output: 20130809 How do I use awk here to change the format and if leading 0 (zero) is not then add it. Please help. Thanks. (8 Replies)
Discussion started by: vegasluxor
8 Replies

5. Shell Programming and Scripting

Change a file content format using awk

Hi, i have a file input.txt Continent North America Country USA Capital Washington D.C. Country Canada Capital Ottawa Continent South America Country Argentina Capital Buenos Aires Country Brazil Capital Brasília Coutry Colombia Capital Bogotá and i want to get an output.txt ... (3 Replies)
Discussion started by: fastlane3000
3 Replies

6. Shell Programming and Scripting

using awk or bash to change the format

tenxun-glibc_code-x86-64-linux-20120713190049.root.tar.bz2 To tenxun-glibc_code-x86-64-linux.root.tar.bz2 (3 Replies)
Discussion started by: yanglei_fage
3 Replies

7. Shell Programming and Scripting

change output format using ksh

I have a script that reaches out to several systems and pulls back infomation in serveral files. I would like to take the infomation returned and reformat it so I can export it to excel. Below is current output: File1:item1:abc=1 File1:item2:efg File2:item1:ab=1 File2:item2:efg... (3 Replies)
Discussion started by: oldman2
3 Replies

8. Shell Programming and Scripting

change the output format

when i run the following command db2 list tablespaces Tablespaces for Current Database Tablespace ID = 0 Name = SYSCATSPACE State = 0x0000 Tablespace ID ... (3 Replies)
Discussion started by: lazydev
3 Replies

9. Shell Programming and Scripting

Change file output format

I have a file which has following contents usmtnz-dinfsi19 62 61 18400 18800 99.7 usmtnz-dinfsi19 62 61 18400 18800 99.7 i want the o/p to be like date (7 Replies)
Discussion started by: fugitive
7 Replies

10. Shell Programming and Scripting

scripting/awk help : awk sum output is not comming in regular format. Pls advise.

Hi Experts, I am adding a column of numbers with awk , however not getting correct output: # awk '{sum+=$1} END {print sum}' datafile 2.15291e+06 How can I getthe output like : 2152910 Thank you.. # awk '{sum+=$1} END {print sum}' datafile 2.15079e+06 (3 Replies)
Discussion started by: rveri
3 Replies
Login or Register to Ask a Question