Divide data with specific column values into separate files
hello!
i need a little help from you ... i need to split a file into separate files depending on two conditions using scripting. The file has no delimiters. The conditions are col 17 = "P" and col 81 = "*", this will go to one output file; col 17 = "R" and col 81 = " ". Here is an example.
Thanks in advance for your help,
Moderator's Comments:
Please use next time code tags for your code and data
Hi,
I have a data file xyz.dat similar to the one given below,
2345|98|809||x|969|0
2345|98|809||y|0|537
2345|97|809||x|544|0
2345|97|809||y|0|651
9685|98|809||x|321|0
9685|98|809||y|0|357
9685|98|709||x|687|0
9685|98|709||y|0|234
2315|98|809||x|564|0
2315|98|809||y|0|537... (2 Replies)
frnds:
i want to divide data on the behalf of dotted line and redirectd into new files
)
-------------------------
M-GET CONFIRMATION (
-------------------------
M-GET CONFIRMATION (
INVOKE IDENTIFIER
final data shuld be into 3 files ...... (6 Replies)
Can anyone please help with this? I have 2 files as given below.
If 2nd column of file1 has pattern foo1@a, find the matching 1st column in file2 & replace 2nd column of file1 with file2's value.
file1
abc_1 foo1@a ....
abc_1 soo2@a ...
def_2 soo2@a ....
def_2 foo1@a ........ (7 Replies)
Hello,
:wall:
I have a 12 column csv file. I wish to delete the entire line if column 7 = hello and column 12 = goodbye. I have tried everything that I can find in all of my ref books.
I know this does not work
/^*,*,*,*,*,*,"hello",*,*,*,*,"goodbye"/d
Any ideas?
Thanks
Please... (2 Replies)
Hello,
I have two files, f1 and f2. f1 has 5 columns like so:
a b c d 154
e f g h 365
.....
f2 has two columns, the first column contains the name of the above file and second column contains a constant which is to be used for division.
e.g.
file1 56
I want to divide the 5th... (2 Replies)
I have a file (let say file B) like this:
File B:
A1 3 5
A1 7 9
A2 2 5
A3 1 3
The first column defines a filename and the other two define a range in that specific file. In the same directory, I have also three more files (File A1, A2 and A3). Here is 10 sample lines... (3 Replies)
I have data such as below where the value in second field is the same as that in the row after.
123456,22222,John,0,xyz
234567,22222,John1,1,cde
43212,3333,Jean,3,pip
84324,3333,Abel,2,cat
I'd like to rearrange the output like below to put such records beside each other and separated with... (5 Replies)
I am running an ISQL command on Sybase DB and getting output of a query in an CSV file.
The issue is that all the data comes in to the same column, i want them to be separated in different columns.
SQL_COMMAND=command.sql
file=file.txt
formatFile=formatFile.txt
report=report.csv
echo... (1 Reply)
Discussion started by: Sharma331
1 Replies
LEARN ABOUT DEBIAN
gnome2::scores
Gnome2::Scores(3pm) User Contributed Perl Documentation Gnome2::Scores(3pm)NAME
Gnome2::Scores - wrapper for GnomeScores
HIERARCHY
Glib::Object
+----Glib::InitiallyUnowned
+----Gtk2::Object
+----Gtk2::Widget
+----Gtk2::Container
+----Gtk2::Bin
+----Gtk2::Window
+----Gtk2::Dialog
+----Gnome2::Scores
INTERFACES
Glib::Object::_Unregistered::AtkImplementorIface
Gtk2::Buildable
METHODS
widget = Gnome2::Scores->new ($names, $scores, $times, $clear)
o $names (scalar) - reference to an array
o $scores (scalar) - reference to an array
o $times (scalar) - reference to an array
o $clear (boolean)
$gs->set_color ($n, $col)
o $n (integer)
o $col (Gtk2::Gdk::Color)
$gs->set_colors ($col)
o $col (Gtk2::Gdk::Color)
$gs->set_current_player ($i)
o $i (integer)
$gs->set_def_color ($col)
o $col (Gtk2::Gdk::Color)
widget = Gnome2::Scores->display ($title, $app_name, $level, $pos)
o $title (string)
o $app_name (string)
o $level (string)
o $pos (integer)
widget = Gnome2::Scores->display_with_pixmap ($pixmap_logo, $app_name, $level, $pos)
o $pixmap_logo (string)
o $app_name (string)
o $level (string)
o $pos (integer)
$gs->set_logo_label ($txt, $font, $col)
o $txt (string)
o $font (string)
o $col (Gtk2::Gdk::Color)
$gs->set_logo_label_title ($txt)
o $txt (string)
$gs->set_logo_pixmap ($pix_name)
o $pix_name (string)
$gs->set_logo_widget ($w)
o $w (Gtk2::Widget)
SEE ALSO
Gnome2, Glib::Object, Glib::InitiallyUnowned, Gtk2::Object, Gtk2::Widget, Gtk2::Container, Gtk2::Bin, Gtk2::Window, Gtk2::Dialog
COPYRIGHT
Copyright (C) 2003-2004 by the gtk2-perl team.
This software is licensed under the LGPL. See Gnome2 for a full notice.
perl v5.14.2 2011-11-16 Gnome2::Scores(3pm)