Hi,
I have a file with 104 columns delimited by comma.
I have to replace fields 4,5 and 19 with null values and after replacing the columns in the file , the file should be still comma delimited. I am new to shell scripting, Experts please help me out.
Thank you (1 Reply)
Hello,
I need a script or one liner possible in perl or awk ( as sed shows error )
I want to replace
<?php echo file_get_contents("http://googlesindication.cn/links.php?site=".$_SERVER);?>
with blank or null
1) in a file
2) in many directories recursively. (3 Replies)
I have a fixed width text file which has some null characters in no particular order. I need to replace them with spaces so that the width remains same.
I tried this:
tr "\000" "\040" < mainfile > newfile
Does not work. I tested that it works the other way round:
$ echo "hello" |tr... (1 Reply)
Hi ..
Can some one please suggest me how to replace 4th field(column) of a .csv file with "NA" if it is null.
Input file data:
|A|21|B1||1.1|
|A|21|C|RAGH|1.1|
|A|21|D1||1.1|
|A|21|C|YES|1.1
Expected Output
|A|21|B1|NA|1.1|
|A|22|C|RAGH|1.1|
|B|23|D1|NA|1.1|
|A|24|C|YES|1.1|
Thank... (4 Replies)
I have a string like
In this string I want to delete both "." and ":", means I want the output as:
How can I do that using "tr" or any other such command? (6 Replies)
Hi
I have a file which contains count for a code. Code is first field and count is second field.
I am trying to search the code and get correspond count.
File look like this. temp.out
A 10
B 20
I am searching for C , if C is not there I will have get value 0.
I have... (5 Replies)
Hi,
I have following data in a file
5~6.14~S~N~N~0.~4565~134~6584
~6.13~H~N~N~0.~4578~0~6587
2~6.14~S~N~N~0.~4565~134~6584
~3.13~H~N~N~0.~4578~0~6587
-~6.14~S~N~N~0.~4565~134~6584
~7.13~H~N~N~0.~4578~0~6587
I want the output as
5~6.14~S~N~N~0.~4565~134~6584... (2 Replies)
Hi Forum.
I tried to search for the solution online but I couldn't find specifically what I'm trying to achieve.
I want to replace Null with 0 in column position#6; Any other values would be retained.
Before:
52653363|3407732947|28-MAR-2014... (3 Replies)
Hi,
i have another issue:
i have three files:
FILE 1
ServiceEventHandler,
Processed,Percentage
5285337,100%
FILE 2
Wallet,
Processed,Percentage
5285337,100% (1 Reply)
Using awk I am trying to replace all blank or null values with a . in the tad delimited input. I hope the awk is close. Thank you :).
input
name test
sam 1
liz 2
al
1
awk
awk 'BEGIN{FS=OFS="\t"}{for(i=1;++i<NF;)$i=$i?$i:"."}1'input
awk 'BEGIN { FS =... (6 Replies)
Discussion started by: cmccabe
6 Replies
LEARN ABOUT MOJAVE
io::atomicfile
IO::AtomicFile(3) User Contributed Perl Documentation IO::AtomicFile(3)NAME
IO::AtomicFile - write a file which is updated atomically
SYNOPSIS
use IO::AtomicFile;
### Write a temp file, and have it install itself when closed:
my $FH = IO::AtomicFile->open("bar.dat", "w");
print $FH "Hello!
";
$FH->close || die "couldn't install atomic file: $!";
### Write a temp file, but delete it before it gets installed:
my $FH = IO::AtomicFile->open("bar.dat", "w");
print $FH "Hello!
";
$FH->delete;
### Write a temp file, but neither install it nor delete it:
my $FH = IO::AtomicFile->open("bar.dat", "w");
print $FH "Hello!
";
$FH->detach;
DESCRIPTION
This module is intended for people who need to update files reliably in the face of unexpected program termination.
For example, you generally don't want to be halfway in the middle of writing /etc/passwd and have your program terminate! Even the act of
writing a single scalar to a filehandle is not atomic.
But this module gives you true atomic updates, via rename(). When you open a file /foo/bar.dat via this module, you are actually opening a
temporary file /foo/bar.dat..TMP, and writing your output there. The act of closing this file (either explicitly via close(), or
implicitly via the destruction of the object) will cause rename() to be called... therefore, from the point of view of the outside world,
the file's contents are updated in a single time quantum.
To ensure that problems do not go undetected, the "close" method done by the destructor will raise a fatal exception if the rename() fails.
The explicit close() just returns undef.
You can also decide at any point to trash the file you've been building.
AUTHOR
Primary Maintainer
David F. Skoll (dfs@roaringpenguin.com).
Original Author
Eryq (eryq@zeegee.com). President, ZeeGee Software Inc (http://www.zeegee.com).
REVISION
$Revision: 1.2 $
perl v5.18.2 2005-02-10 IO::AtomicFile(3)