Sponsored Content
Top Forums Shell Programming and Scripting how do i ignore rows with first filed NULL Post 302226410 by vidyadhar85 on Tuesday 19th of August 2008 02:12:18 AM
Old 08-19-2008
try adding WHEN FIELD1!="" in SQLLDR..
 

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Filed substitution with awk

guys, I'm trying to 9k lines of the following: aaa aaa 1 1 1 to aaa aaa 1 01 1 Im pretty ignorant when it comes to subtituting fields using awk any help ? Tony (1 Reply)
Discussion started by: tony3101
1 Replies

2. Shell Programming and Scripting

deleting pipes in a particular filed

i have a file with some records seperated by pipe. I am getting unwanted "|" in the 7th field and i want to remove any pipes in the 7th field only. Can somebody help out? Here is the sample record. 460625192|432559595|MANU... (3 Replies)
Discussion started by: dsravan
3 Replies

3. UNIX for Dummies Questions & Answers

The LimitRequestBody filed in openSUSE 10.2

Because some program i have installed can not upload files bigger than some size as printing, the base got a packet bigger than 'max_allowed_packet' bytes what that i need to do as written in the documentation of the program increase the value of a fileld called LimitRequestBody told that is in... (3 Replies)
Discussion started by: tal
3 Replies

4. Linux

The LimitRequestBody filed in openSUSE 10.2

Because some program i have installed can not upload files bigger than some size as printing, the base got a packet bigger than 'max_allowed_packet' bytes what that i need to do as written in the documentation of the program increase the value of a fileld called LimitRequestBody told that is in... (5 Replies)
Discussion started by: tal
5 Replies

5. Shell Programming and Scripting

Removing rows based on a different file (ignore my earlier post - there was a mistake).

Sorry I made a mistake in my last post (output is suppose to be the opposite). Here is a revised post. Hi, I am not sure if this has already been asked (I tried the search but the search was too broad). Basically I want to remove rows based on another file. So file1 looks like this (tab... (3 Replies)
Discussion started by: kylle345
3 Replies

6. Shell Programming and Scripting

Insert string 'NULL' where there is a null value

I have an input file having 7 fields delimited by , eg : 1,ABC,hg,1,2,34,3 2,hj,YU,2,3,4, 3,JU,kl,4,5,7, 4,JK,KJ,3,56,4,5 The seventh field here in some lines is empty, whereas the other lines there is a value. How do I insert string NULL at this location (7th loc) for these lines where... (8 Replies)
Discussion started by: zilch
8 Replies

7. Shell Programming and Scripting

awk code to ignore the first occurence unknown number of rows in a data column

Hello experts, Shown below is the 2 column sample data(there are many data columns in actual input file), Key, Data A, 1 A, 2 A, 2 A, 3 A, 1 A, 1 A, 1 I need the below output. Key, Data A, 2 A, 2 A, 3 A, 1 A, 1 A, 1 (2 Replies)
Discussion started by: ks_reddy
2 Replies

8. Shell Programming and Scripting

Verify the null filed of the text file

Here is my sample data Test.txt column 1|columne 2|columne 3|columne 4 test|test||test test|test|test| test||test|test test|test|test|test |test|test|test In that example having NULL value of the row 2-column 3,row 3-column 4,row 4 - column 2,row 6- column 1 How i can validate... (5 Replies)
Discussion started by: krish2014
5 Replies

9. Shell Programming and Scripting

awk to ignore multiple rows based on a condition

All, I have a text file(Inputfile.csv) with millions of rows and 100 columns. Check the sample for 2 columns below. Key,Check A,1 A,2 A, A,4 B,0 B,1 B,2 B,3 B,4 .... million rows. My requirement is to delete all the rows corresponding to all the keys which ever has at least one... (4 Replies)
Discussion started by: ks_reddy
4 Replies
Jifty::Test::WWW::Mechanize(3pm)			User Contributed Perl Documentation			  Jifty::Test::WWW::Mechanize(3pm)

NAME
Jifty::Test::WWW::Mechanize - Subclass of Test::WWW::Mechanize with extra Jifty features METHODS
new Overrides Test::WWW::Mechanize's "new" to automatically give the bot a cookie jar. request We override WWW::Mechanize's default request method so accept-encoding is not set to gzip by default. moniker_for ACTION, FIELD1 => VALUE1, FIELD2 => VALUE2 Finds the moniker of the first action of type ACTION whose "constructor" field FIELD1 is VALUE1, and so on. my $mon = $mech->moniker_for('MyApp::Action::UpdateInfo'); If there is only one action of type ACTION, be sure not to pass any more arguments to this method, or the method will return undef. NOTE that if you're using this in a series of different pages or forms, you'll need to run it again for each new form: $mech->fill_in_action_ok($mech->moniker_for('MyApp::Action::UpdateInfo'), owner_id => 'someone'); $mech->submit_html_ok(); is($mech->action_field_value($mech->moniker_for("MyApp::Action::UpdateInfo"), 'owner_id'), 'someone', "Owner was reassigned properly to owner 'someone'"); fill_in_action MONIKER, FIELD1 => VALUE1, FIELD2 => VALUE2, ... Finds the fields on the current page with the names FIELD1, FIELD2, etc in the MONIKER action, and fills them in. Returns the HTML::Form object of the form that the action is in, or undef if it can't find all the fields. fill_in_action_ok MONIKER, FIELD1 => VALUE1, FIELD2 => VALUE2, ... Finds the fields on the current page with the names FIELD1, FIELD2, etc in the MONIKER action, and fills them in. Returns the HTML::Form object of the form that the action is in, or undef if it can't find all the fields. Also, passes if it finds all of the fields and fails if any of the fields are missing. action_form MONIKER [ARGUMENTNAMES] Returns the form (as an HTML::Form object) corresponding to the given moniker (which also contains inputs for the given argumentnames), and also selects it as the current form. Returns undef if it can't be found. action_field_input MONIKER, FIELD Finds the field on the current page with the names FIELD in the action MONIKER, and returns its HTML::Form::Input, or undef if it can't be found. action_field_value MONIKER, FIELD Finds the field on the current page with the names FIELD in the action MONIKER, and returns its value, or undef if it can't be found. send_action CLASS ARGUMENT => VALUE, [ ... ] Sends a request to the server via the webservices API, and returns the Jifty::Result of the action. "CLASS" specifies the class of the action, and all parameters thereafter supply argument keys and values. The URI of the page is unchanged after this; this is accomplished by using the "back button" after making the webservice request. fragment_request PATH ARGUMENT => VALUE, [ ... ] Makes a request for the fragment at PATH, using the webservices API, and returns the string of the result. field_error_text MONIKER, FIELD Finds the error span on the current page for the name FIELD in the action MONIKER, and returns the text (tags stripped) from it. (If the field can't be found, return undef). uri WWW::Mechanize has a bug where it returns the wrong value for "uri" after redirect. This fixes that. See http://rt.cpan.org/NoAuth/Bug.html?id=9059 get_html_ok URL Calls "get" URL, followed by testing the HTML using Test::HTML::Lint. html_ok [STRING] Tests the current "content" using Test::HTML::Lint. If passed a string, tests against that instead of the current content. submit_html_ok Calls "submit", followed by testing the HTML using Test::HTML::Lint. follow_link_ok Calls "follow_link", followed by testing the HTML using Test::HTML::Lint. Warns if it cannot find the specified link (you should use "ok" on "find_link" first to check its existence). warnings_like WARNING, [REASON] Tests that the warnings generated by the server (since the last such check) match the given "WARNING", which should be a regular expression. If an array reference of regular expressions is passed as "WARNING", checks that one warning per element was received. no_warnings_ok [REASON] Checks that no warnings were generated by the server (since the last such check). session Returns the server-side Jifty::Web::Session object associated with this Mechanize object. continuation [ID] Returns the current continuation of the Mechanize object, if any. Or, given an ID, returns the continuation with that ID. current_user Returns the Jifty::CurrentUser object or descendant, if any. perl v5.14.2 2011-04-14 Jifty::Test::WWW::Mechanize(3pm)
All times are GMT -4. The time now is 05:52 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy