Append data by looking up 2 tables for multiple files Post: 302938221

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Converting tables of row data into columns of tables

I am trying to transpose tables listed in the format into format. Any help would be greatly appreciated. Input: test_data_1 1 2 90% 4 3 91% 5 4 90% 6 5 90% 9 6 90% test_data_2 3 5 92% 5 4 92% 7 3 93% 9 2 92% 1 1 92% ... Output:...

2. Shell Programming and Scripting

Reading data from multiple tables from Oracle DB

Hi , I want to read the data from 9 tables in oracle DB into 9 different files in the same connection instance (session). I am able to get data from one table to one file with below code : X=`sqlplus -s user/pwd@DB <<eof select col1 from table1; EXIT; eof` echo $X>myfile Can anyone...

3. Shell Programming and Scripting

Shell script to identify the number of files and to append data

Hi I am having a question where I have to 1) Identify the number of files in a directory with a specific format and if the count is >1 we need to concatenate those two files into one file and remember that in the second file the header should not be copied. it should be form first file....

4. UNIX for Dummies Questions & Answers

Using AWK: Extract data from multiple files and output to multiple new files

Hi, I'd like to process multiple files. For example: file1.txt file2.txt file3.txt Each file contains several lines of data. I want to extract a piece of data and output it to a new file. file1.txt ----> newfile1.txt file2.txt ----> newfile2.txt file3.txt ----> newfile3.txt Here is...

5. Shell Programming and Scripting

Read multiple files, parse data and append to a file

Hi..Can anyone suggest a simple way of achieving this. I have several files which ends with extension .vcf . I will give example with two files In the below files, we are interested in File 1: 38 107 C 3 T 6 C/T 38 241 C 4 T 5 C/T 38 247 T 4 C 5 T/C 38 259 T 3 C 6 T/C...

6. Shell Programming and Scripting

Multiple files to load into different tables,

multiple files to load into different tables, I have a script show below, but this script loads data from txt file into a table, but i have multiple input files(xyzload.txt,xyz1load.txt,xyz2load.txt......) in the unix folder , can we load these files in diff tables (table 1, table2...

7. Shell Programming and Scripting

Multiple files to load into different tables

8. UNIX for Beginners Questions & Answers

Using bash script : How to Import data from a dsv file into multiple tables in mysql

HI I have a dsv file that looks like: <<BOF>> record_number|id_number|first name|last name|msisdn|network|points|card number|gender 312|9101011234011|Test Junior|Smith|071 123 4321|MTN|73|1241551413214444|M 313|9012023213011|Bob|Smith|27743334321|Vodacom|3|1231233232323244|M...

9. Programming

Python script to run multiple command and append data in output csv file

Experts, I am writing a script and able to write only small piece of code and not able to collect logic to complete this task. In input file have to look for name like like this (BGL_HSR_901_1AG_A_CR9KTR10) before sh iss neors. Record this (BGL_HSR_901_1AG_A_CR9KTR10) in csv file Now have to...

10. UNIX for Beginners Questions & Answers

Export Oracle multiple tables to multiple csv files using UNIX shell scripting

Hello All, just wanted to export multiple tables from oracle sql using unix shell script to csv file and the below code is exporting only the first table. Can you please suggest why? or any better idea? export FILE="/abc/autom/file/geo_JOB.csv" Export= `sqlplus -s dev01/password@dEV3...

LEARN ABOUT LINUX

nisplus_table

NISPLUS_TABLE(5)						File Formats Manual						  NISPLUS_TABLE(5)

NAME

       nisplus_table - Postfix NIS+ client

SYNOPSIS

       postmap -q "string" "nisplus:[name=%s];name.name."

       postmap -q - "nisplus:[name=%s];name.name." <inputfile

DESCRIPTION

       The  Postfix  mail  system uses optional lookup tables.	These tables are usually in dbm or db format.  Alternatively, lookup tables can be
       specified as NIS+ databases.

       To find out what types of lookup tables your Postfix system supports use the "postconf -m" command.

       To test Postfix NIS+ lookup tables, use the "postmap -q" command as described in the SYNOPSIS above.

QUERY SYNTAX

       Most of the NIS+ query is specified via the NIS+ map name. The general format of a Postfix NIS+ map name is as follows:

	   nisplus:[name=%s];name.name.name.:column

       Postfix NIS+ map names differ from what one normally would use with commands such as niscat:

       o      With each NIS+ table lookup, "%s" is replaced by a version of the lookup string.	There can be only one "%s" instance in	a  Postfix
	      NIS+ map name.

       o      Postfix  NIS+  map  names  use  ";"  instead  of	",", because the latter character is special in the Postfix main.cf file.  Postfix
	      replaces ";" characters in the map name by "," before making NIS+ queries.

       o      The ":column" part in the NIS+ map name is not part of the actual NIS+ query. Instead, it specifies the number of the  table  column
	      that provides the lookup result. When no ":column" is specified the first column (1) is used.

EXAMPLE

       A NIS+ aliases map might be queried as follows:

	   alias_maps = dbm:/etc/mail/aliases,
	       nisplus:[alias=%s];mail_aliases.org_dir.$mydomain.:1

       This queries the local aliases file before the NIS+ file.

SEE ALSO

       postmap(1), Postfix lookup table manager

README FILES

       Use "postconf readme_directory" or "postconf html_directory" to locate this information.
       DATABASE_README, Postfix lookup table overview

LICENSE

       The Secure Mailer license must be distributed with this software.

AUTHOR(S)
       Geoff Gibbs
       UK-HGMP-RC
       Hinxton
       Cambridge
       CB10 1SB, UK

       Adopted and adapted by:
       Wietse Venema
       IBM T.J. Watson Research
       P.O. Box 704
       Yorktown Heights, NY 10598, USA

																  NISPLUS_TABLE(5)