Sponsored Content
Top Forums Shell Programming and Scripting CSV File with Multiple Search Parameter Post 302993326 by chetanojha on Wednesday 8th of March 2017 05:19:54 PM
Old 03-08-2017
I have now corrected the calling of script.

Code:
./findInvoice.sh MICHELIN
or
./findInvoice.sh PIRELLI

Above is the correct one
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Handle Configuration File with same name of Parameter in multiple Sections

Hi I have a config file with multiple section and a parameter with the same name in each section. I need to read each parameter for distinct section. Parameter = 1 .... Parameter = 2 .... Parameter = 4 .... Tried this: grep -m1 '^*ProcessorsNumber' ServiceBrokerFramework.cfg |... (7 Replies)
Discussion started by: potro
7 Replies

2. Shell Programming and Scripting

Appending a parameter value to a .csv file???

Hi I have a date which I get as parameter. I want it to be added as first column in all the rows in a csv file. I have tried the below code but no success. date=$1 awk -F"," '{print $date","$0}' z3.csv > z4.csv Could you tell the correct code for the above req.? How to use code... (1 Reply)
Discussion started by: msp2244
1 Replies

3. Shell Programming and Scripting

search and replace in csv file

I have csv file where I want the second column has to be replaced with value 1. Source file 919568760477,1,2011-07-11T22:34:27.000+05:30, 919557735692,2,2011-07-11T22:36:16.000+05:30, 917417384969,2,2011-07-11T22:33:26.000+05:30, Final file ... (30 Replies)
Discussion started by: dondilip
30 Replies

4. Shell Programming and Scripting

Perl search csv fileA where two strings exist on another csv fileB

Hi I have two csv files, with the following formats: FileA.log: Application, This occured blah Application, That occured blah Application, Also this AnotherLog, Bob did this AnotherLog, Dave did that FileB.log: Uk, London, Application, datetime, LaterDateTime, Today it had'nt... (8 Replies)
Discussion started by: PerlNewbRP
8 Replies

5. UNIX for Dummies Questions & Answers

Search file and print everything except multiple search terms

I'm trying to find a way to search a range of similar words in a file. I tried using sed but can't get it right:sed 's/\(ca01\)*//'It only removes "ca01" but leaves the rest of the word. I still want the rest of the information on the lines just not these specific words listed below. Any... (3 Replies)
Discussion started by: seekryts15
3 Replies

6. Shell Programming and Scripting

Read in search strings from text file, search for string in second text file and output to CSV

Hi guys, I have a text file named file1.txt that is formatted like this: 001 , ID , 20000 002 , Name , Brandon 003 , Phone_Number , 616-234-1999 004 , SSNumber , 234-23-234 005 , Model , Toyota 007 , Engine ,V8 008 , GPS , OFF and I have file2.txt formatted like this: ... (2 Replies)
Discussion started by: An0mander
2 Replies

7. Shell Programming and Scripting

Multiple file and single parameter file

Hi Team, In our project we have written below 2 scripts like Script1: Shell script start & END Begin Audit process - uses teradata bteq END Audit Process Script 2: Environemtal variable file different Now Client ask to change this requirement and need below files: Script1:... (1 Reply)
Discussion started by: tusharzaware1
1 Replies

8. Shell Programming and Scripting

Multiple Parameter search script - OLD Post

Dear Forum Member, Hope you are well. I am sending this email to your reply to one of my post in the forum. I raised an help request from all of you regarding an issue I was facing. The original thread is here ... (3 Replies)
Discussion started by: chetanojha
3 Replies

9. Shell Programming and Scripting

Replace multiple file by passing parameter value

Hello All, I want to change date part in file name to yesterday date in the file name. example file name file-12122017-06-30-41.dat want file-12112017-06-30-41.dat I am doing like below. Below it is not changing the filename. Actually it is not parsing the $today and $yesterday value in... (1 Reply)
Discussion started by: looney
1 Replies

10. Shell Programming and Scripting

Combine and complete multiple CSV files based on 1 parameter

I have to create a new CSV file based on the value listed on the 3rd column from different CSV files. This is what I need: 1. I should substitute the first column from each file, excluding the headers, with the file name InputXX. 2. Then, I need to look for rows with 0 on the third column in... (7 Replies)
Discussion started by: Xterra
7 Replies
LedgerSMB::ScriptLib::Company(3pm)			User Contributed Perl Documentation			LedgerSMB::ScriptLib::Company(3pm)

NAME
LedgerSMB::ScriptLib::Company - LedgerSMB class defining the Controller functions, template instantiation and rendering for vendor and customer editing and display. This would also form the basis for other forms of company contacts. SYOPSIS
This module is the UI controller for the vendor DB access; it provides the View interface, as well as defines the Save vendor. Save vendor/customer will update or create as needed. METHODS
set_entity_class($request) returns int entity class Errors if not inherited. Inheriting classes MUST define this to set $entity_class appropriately. get_by_cc Populates the company area with info on the company, pulled up through the control code dispatch_legacy This is a semi-private method which interfaces with the old code. Note that as long as any other functions use this, the contact interface cannot be said to be safe for code caching. Not fully documented because this will go away as soon as possible. add_transaction Dispatches to the Add (AR or AP as appropriate) transaction screen. add_invoice Dispatches to the (sales or vendor, as appropriate) invoice screen. add_order Dispatches to the sales/purchase order screen. rfq Dispatches to the quotation/rfq screen new_company($request) returns object inheriting LedgerSMB::DBObject::Company This too must be defined in classes that inherit this class. get($self, $request, $user) Requires form var: id Extracts a single company from the database, using its company ID as the primary point of uniqueness. Shows (appropriate to user privileges) and allows editing of the company information. add_location Adds a location to the company as defined in the inherited object save_new_location Adds a location to the company as defined in the inherited object, not overwriting existing locations. generate_control_code Sets $company->{control_code} equal to the next in the series of entity_control values add This method creates a blank screen for entering a company's information. get_results($self, $request, $user) Requires form var: search_pattern Directly calls the database function search, and returns a set of all vendors found that match the search parameters. Search parameters search over address as well as vendor/Company name. history($request) Generates the filter screen for the customer/vendor history report. display_history($request) Displays the customer/vendor history based on criteria from the history filter screen. The following request variables are optionally set in the HTTP query string or request object. Search Criteria name: search string for company name contact_info: Search string for contact info, can match phone, fax, or email. salesperson: Search string for employee name in the salesperson field notes: Notes search. Not currently implemented meta_number: Exact match for customer/vendor number address_line: Search string for first or second line of address. city: Search string for city name state: Case insensitive, otherwise exact match for state or province zip: leading match for zip/mail code country_id: integer for country id. Exact match tartdate_from: Earliest date for startdate of entity credit account startdate_to: Lates date for entity credit accounts' start date type: either 'i' for invoice, 'o' for orders, 'q' for quotations from_date: Earliest date for the invoice/order to_date: Latest date for the invoice/order Unless otherwise noted, partial matches are sufficient. Control variables: inc_open: Include open invoices/orders. If not true, no open invoices are displayed inc_closed: Include closed invoices/orders. If not true, no closed invoices are displayed report_type: Either summary or detail Columns to display: l_partnumber: parts.partnumber l_sellprice: invoice/orderitems.sellprice l_curr: ar/ap/oe.curr l_unit: invoice/orderitems.unit l_deliverydate: invoice.deliverydate or orderitems.reqdate l_projectnumber: project.projectnumber l_serialnumber: invoice/orderitems.serialnumber csv_company_list($request) Generates CSV report (not working at present) save($self, $request, $user) Saves a company to the database. The function will update or insert a new company as needed, and will generate a new Company ID for the company if needed. save_credit($request) This inserts or updates a credit account of the sort listed here. save_credit_new($request) This inserts a new credit account. edit($request) Displays a company for editing. Needs the following to be set: entity_id, account_class, and meta_number. The account_class requireent is typically set during the construction of scripts which inherit this library. PRIVATE _render_main_screen($company) Pulls relevant data from db and renders the data entry screen for it. search($request) Renders the search criteria screen. save_contact($request) Saves contact info as per LedgerSMB::DBObject::Company::save_contact. delete_contact Deletes the selected contact info record Must include company_id or credit_id (credit_id used if both are provided) plus: * contact_class_id * contact * form_id delete_bank_acct Deletes the selected bank account record Required request variables: * bank_account_id * entity_id * form_id delete_location Deletes the selected contact info record Must include company_id or credit_id (credit_id used if both are provided) plus: * location_class_id * location_id * form_id edit_bank_acct($request) displays screen to a bank account Required data: bank_account_id bic iban save_contact_new($request) Saves contact info as a new line as per save_contact above. save_bank_account($request) Adds a bank account to a company and, if defined, an entity credit account. save_notes($request) Saves notes. entity_id or credit_id must be set, as must note_class, note, and subject. pricelist This returns and displays the pricelist. The id field is required. delete_price save_pricelist This routine saves the price matrix. For existing rows, valid_to, valid_from, price fields are saved. For the new row, the partnumber field matches the beginning of the part number, and the description is a full text search. pricelist_search_handle Handles the return from the parts search from the pricelist screen. COPYRIGHT
Copyright (c) 2009, the LedgerSMB Core Team. This is licensed under the GNU General Public License, version 2, or at your option any later version. Please see the accompanying License.txt for more information. perl v5.14.2 2012-03-28 LedgerSMB::ScriptLib::Company(3pm)
All times are GMT -4. The time now is 04:06 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy