Sponsored Content
Full Discussion: sed command playing with me!
Top Forums UNIX for Dummies Questions & Answers sed command playing with me! Post 302731029 by Error404 on Wednesday 14th of November 2012 05:37:15 AM
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
 

9 More Discussions You Might Find Interesting

1. 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

2. 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

3. 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

4. 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

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. 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

7. 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

8. 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

9. 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
CEXP(3) 						   BSD Library Functions Manual 						   CEXP(3)

NAME
cexp -- complex exponential function SYNOPSIS
#include <complex.h> double complex cexp(double complex z); long double complex cexpl(long double complex z); float complex cexpf(float complex z); DESCRIPTION
cexp(z) returns the complex exponential of z. cexp(conj(z)) = conj(cexp(z)), for all complex floating-point numbers z. SPECIAL VALUES
The conjugate symmetry of cexp() is used to abbreviate the specification of special values. cexp(+-0 + 0i) returns 1 + 0i. cexp(x + inf i) returns NaN + NaN i, and raises the invalid flag, for finite x. cexp(x + NaN i) returns NaN + NaN i, for finite x. cexp(inf + 0i) returns inf + 0i. For the following two cases, cis(y) denotes cos(y) + I*sin(y). cexp(-inf + yi) returns 0*cis(y), for finite y. cexp(inf + yi) returns inf*cis(y), for finite nonzero y. cexp(-inf + inf i) returns -0 + 0i. cexp(inf + inf i) returns -inf + NaN i, and raises the invalid flag. cexp(-inf + NaN i) returns -0 + 0i. cexp(inf + NaN i) returns -inf + NaN i. cexp(NaN + 0i) returns NaN + 0i. cexp(NaN + yi) returns NaN + NaN i for all nonzero numbers y. cexp(NaN + NaN i) returns NaN + NaN i. SEE ALSO
exp(3) clog(3) complex(3) STANDARDS
The cexp() function conforms to ISO/IEC 9899:2011. 4th Berkeley Distribution December 11, 2006 4th Berkeley Distribution
All times are GMT -4. The time now is 03:27 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy