sed command playing with me!


 
Thread Tools Search this Thread
Top Forums UNIX for Dummies Questions & Answers sed command playing with me!
# 1  
Old 11-14-2012
Display sed command playing with me!

Hello guys,

I was working with my data (a tab delimted text file) in Linux and wanted to replace all "NaN" values in my huge table with "NA", so i used the following sed command:

Code:
sed 's/NaN/NA/g' /filepath -> outputfile.txt

The results were good, all "NaN" were replaced with "NA", but the new output file had no headers no column names anymore!

Example:
Before:
Code:
V12 V13 V14 V15 V16
100 200 300 NaN 500
220 NaN 100 500 600
700 NaN 900 100 200

After:
Code:
100 200 300 NA 500
220 NA 100 500 600
700 NA 900 100 200

Any idea what happened? what is the right command to use here?

Many thanks,
Error404


Moderator's Comments:
Mod Comment Video tutorial on how to use code tags in The UNIX and Linux Forums.

Last edited by zaxxon; 11-14-2012 at 06:43 AM.. Reason: code tags
# 2  
Old 11-14-2012
it's valid sed command..i tried it's working fine..
# 3  
Old 11-14-2012
Quote:
Originally Posted by bmk
it's valid sed command..i tried it's working fine..
bmk,
Yes it is working. as you can see, it converts all "NaN" to "NA".
but the problem i am having now that it is omitting the headers, didn't that happen with you too?

-Error404
# 4  
Old 11-14-2012
See my output...
Code:
V12 V13 V14 V15 V16
100 200 300 NA 500
220 NA 100 500 600
700 NA 900 100 200

This User Gave Thanks to bmk For This Post:
# 5  
Old 11-14-2012
Check your input file for non printable characters, especially at the beginning around the header line. You can use

Code:
od -c inputfile | head

for this.
This User Gave Thanks to hergp For This Post:
# 6  
Old 11-14-2012
Hey guys,
This data is spooky! :|
I tried to do the same sed command to another file and it worked properly. Then tried to do THE EXACT COMMAND to this file again, and it still omitted the columns names!!! :S
I guess I will have to try to export another huge set of data to see whats wrong!
I'll let you know if the set of data i am going to export will do this problem again Smilie

Thanks guys, your help is appreciated
-Error404
# 7  
Old 11-14-2012
or else simply take the first column append to output file.
 
Login or Register to Ask a Question

Previous Thread | Next Thread

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

sed and awk giving error ./sample.sh: line 13: sed: command not found

Hi, I am running a script sample.sh in bash environment .In the script i am using sed and awk commands which when executed individually from terminal they are getting executed normally but when i give these sed and awk commands in the script it is giving the below errors :- ./sample.sh: line... (12 Replies)
Discussion started by: satishmallidi
12 Replies

2. Shell Programming and Scripting

Playing with parameters

Can someone help me of doing something like this send.sh #!/bin/bash for last; do true; done echo $* | gammu sendsms TEXT $last every thing is good except that when i launch the script like this ./send.sh This is the message i want to send +63922XXXXXXX it turned out the message of... (2 Replies)
Discussion started by: arturo322
2 Replies

3. UNIX for Dummies Questions & Answers

Crontab not playing

This is my crontab: MAILTO="" # m h dom mon dow command # Check to see if the fridge door has been left open * * * * * fridgedoor #Get temperature readings from fridge and save to monthly file in Downloads 30 0,4,8,12,16,20 * * * fridge 40 0 * * * sendfridge * * * * *... (2 Replies)
Discussion started by: Fitch
2 Replies

4. Shell Programming and Scripting

sed scripts are not playing nicely!

I am having a lot of trouble, wasting a lot of time trying to get sed script files to run without problem. I have a list of scripts I want to run on a text file to turn it into a viewable html file for my mobile phone. Each of the single scripts when run in order/sequence one after another on the... (4 Replies)
Discussion started by: naphelge
4 Replies

5. UNIX for Dummies Questions & Answers

ffmpeg: capture audio that's playing (command line)

I'd like to capture the audio playing in itunes (OSX) to a file (from the command line). I currently use Wiretap Pro, but i'd like a non-gui. I tried installing sox, but after installing about 40-50 dependencies it crashed out. I do have ffmpeg working and I am pretty sure it can capture what's... (0 Replies)
Discussion started by: sentinel
0 Replies

6. UNIX for Dummies Questions & Answers

playing games from another directory?

If "photopia.dat" is a game. To play it, you would normally type "frotz photopia.dat" (assuming you are in the directory where photopia.dat resides). But what if I'm in my home directory, photopia.dat is in the "games" directory, and I want to play it without switching directories? What command... (2 Replies)
Discussion started by: greeky
2 Replies

7. Shell Programming and Scripting

Loop with sed command to replace line with sed command in it

Okay, title is kind of confusion, but basically, I have a lot of scripts on a server that I need to replace a ps command, however, the new ps command I'm trying to replace the current one with pipes to sed at one point. So now I am attempting to create another script that replaces that line. ... (1 Reply)
Discussion started by: cbo0485
1 Replies

8. SCO

Help! Playing with Xenix!

Hey everyone! I'm trying to retrieve old files from my Xenix computers. So the option I've now come down to is to load up a second harddrive and do a doscp of my tar'd backup file. Now, How do I go about this? I am not a unix user myself so I'm not quite sure. I need help! I have a VERY short... (1 Reply)
Discussion started by: Slaughter
1 Replies

9. UNIX for Dummies Questions & Answers

playing audio

Hi all, I play audio through the web browser and it plays ok on windows. When i try the same thing on unix i get the error message "sh: /usr/local/bin/sox: not found. I've tried 'locate sox' and can't seem to find it. Is there some way I can change the browser settings so they play the audio... (3 Replies)
Discussion started by: molli_81
3 Replies
Login or Register to Ask a Question