02-12-2015
Thank you so much for the clue!!! I finally got it!!!
It has definitely got to do with text format that Excel uses. After I opened the file with "TextEdit" & changed the format and style, I could finally use
sed or
grep to it
I had to convert it into "Rich Text Format" then I could
sed it into output.txt format. It gave me lines with "\" at the end but that's ok I could use
perl, find and replace.
I was so lucky as the file is not more than 10mb though. If it's like 200gb like before, this project is simply dead.
I m not sure if there's a command to change the text format without using "TextEdit". If there is, it would be simply AWESOME
Anyways, thank you all for your help and sorry I caused too much trouble. :S
Moral of the Story : Don't play with Excel
I could use
perl on the txt that just come out of Excel though. If only there's a way to remove lines containing digits using
perl
Once again, thank you all
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Hi all
While trying to upon a new window it is saying UNABLE TO GET PTY..what does this means how to solve it
Thanks
Prafulla (4 Replies)
Discussion started by: Prafulla
4 Replies
2. UNIX for Advanced & Expert Users
hey,
I use cygwin to connect to AIX 5.2 but when I open vi I get an error saying:
ex: 0602-108 cygwin is not a recognized terminal type
how can I fix that? I thought cygwin was tty vt100? (1 Reply)
Discussion started by: rein
1 Replies
3. SCO
Hello All,
I am facing a problem on SCO Open Server V 5x, We are using serial communication on dumb terminals, right now i am facing a problem on some terminals, as they are not showing thier previous tty no, as tty13 or tty18, but they are showing ttya6 or ttya4, i also tried to move and link... (5 Replies)
Discussion started by: Awadhesh
5 Replies
4. Programming
i am executiing some commands using system an popen command in c.
while executing the code .
some data is shown on terimal without using any print statement.
how can i solve this problem
thank u
sree (1 Reply)
Discussion started by: phani_sree
1 Replies
5. Linux
I'm hoping someone can help me out here.
I'm having a problem on my Red Hat Enterprise 5 Server where my tty devices "tty" are being set to read only permissions.
I need them to be set to 777 in order to write to the serial printers through a custome application.
I have gone through many... (2 Replies)
Discussion started by: Netwrkengeer
2 Replies
6. Shell Programming and Scripting
Hello everyone. This is my first post.:o
Using Ubuntu 8.04 and bash 3.2.39 i'm trying to adapt my routine to this platform.
So, this means forget xterm and use gnome-terminal (as default ubuntu terminal). EveryDay i need to connect to several servers, and i've made a Tcl'script to make this... (1 Reply)
Discussion started by: trutoman
1 Replies
7. Shell Programming and Scripting
I've a python script named rwe.py. I'm running the program in three separate terminals. If one of the executing program stops . I want to leave the terminal as it is so that i can see the error. i wrote a the below script and used cron to run it every one hour to check if the three programs are... (0 Replies)
Discussion started by: msteve2002
0 Replies
8. Linux
Im a complete newbie tryin to work with linux centos;
in terminal wanted to log with script command;
but output file has some strange characters when I try to open with gedit or bluefish
terminal , gedit, bluefish encoding is utf-8 ;
Script started on Mon 08 Mar 2010 03:32:39 PM EET... (2 Replies)
Discussion started by: anacondauser
2 Replies
9. HP-UX
Hi Guys,
I'm using my putty to connect to the HP-UX test box. Once I get connected to server there seem to be something wrong with my putty that behaves very odd. for example it starts from the half of the screen. I really dont know how to explain this problem. or for instance when i run vi to... (2 Replies)
Discussion started by: messi777
2 Replies
10. UNIX for Dummies Questions & Answers
I am trying to delete all empty lines from a file using either
grep -v ^$ file
or
sed '/^$/d' file
But neither one is working.
I have uploaded the file I am trying to modify. Any help will be greatly apreciated. (3 Replies)
Discussion started by: Xterra
3 Replies
LEARN ABOUT DEBIAN
poe::filter::grep
POE::Filter::Grep(3pm) User Contributed Perl Documentation POE::Filter::Grep(3pm)
NAME
POE::Filter::Grep - select or remove items based on simple rules
SYNOPSIS
#!perl
use POE qw(
Wheel::FollowTail
Filter::Line Filter::Grep Filter::Stackable
);
POE::Session->create(
inline_states => {
_start => sub {
my $parse_input_as_lines = POE::Filter::Line->new();
my $select_sudo_log_lines = POE::Filter::Grep->new(
Put => sub { 1 },
Get => sub {
my $input = shift;
return $input =~ /sudo[d+]/i;
},
);
my $filter_stack = POE::Filter::Stackable->new(
Filters => [
$parse_input_as_lines, # first on get, last on put
$select_sudo_log_lines, # first on put, last on get
]
);
$_[HEAP]{tailor} = POE::Wheel::FollowTail->new(
Filename => "/var/log/system.log",
InputEvent => "got_log_line",
Filter => $filter_stack,
);
},
got_log_line => sub {
print "Log: $_[ARG0]
";
}
}
);
POE::Kernel->run();
exit;
DESCRIPTION
POE::Filter::Grep selects or removes items based on simple tests. It may be used to filter input, output, or both. This filter is named
and modeled after Perl's built-in grep() function.
POE::Filter::Grep is designed to be combined with other filters through POE::Filter::Stackable. In the "SYNOPSIS" example, a filter stack
is created to parse logs as lines and remove all entries that don't pertain to a sudo process. (Or if your glass is half full, the stack
only selects entries that DO mention sudo.)
PUBLIC FILTER METHODS
In addition to the usual POE::Filter methods, POE::Filter::Grep also supports the following.
new
new() constructs a new POE::Filter::Grep object. It must either be called with a single Code parameter, or both a Put and a Get parameter.
The values for Code, Put, and Get are code references that, when invoked, return true to select an item or false to reject it. A Code
function will be used for both input and output, while Get and Put functions allow input and output to be filtered in different ways. The
item in question will be passed as the function's sole parameter.
sub reject_bidoofs {
my $pokemon = shift;
return 1 if $pokemon ne "bidoof";
return;
}
my $gotta_catch_nearly_all = POE::Filter::Grep->new(
Code => &reject_bidoofs,
);
Enforce read-only behavior:
my $read_only = POE::Filter::Grep->new(
Get => sub { 1 },
Put => sub { 0 },
);
modify
modify() changes a POE::Filter::Grep object's behavior at run-time. It accepts the same parameters as new(), and it replaces the existing
tests with new ones.
# Don't give away our Dialgas.
$gotta_catch_nearly_all->modify(
Get => sub { 1 },
Put => sub { return shift() ne "dialga" },
);
SEE ALSO
POE::Filter for more information about filters in general.
POE::Filter::Stackable for more details on stacking filters.
BUGS
None known.
AUTHORS & COPYRIGHTS
The Grep filter was contributed by Dieter Pearcey. Documentation is provided by Rocco Caputo.
Please see the POE manpage for more information about authors and contributors.
perl v5.14.2 2012-05-15 POE::Filter::Grep(3pm)