Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: csv file to array, match field1, replace in flat file field1 to field2
Top Forums Shell Programming and Scripting csv file to array, match field1, replace in flat file field1 to field2 Post 302283391 by vgersh99 on Tuesday 3rd of February 2009 08:50:46 AM
Old 02-03-2009
given fran.csv:
Code:
"hello","byebye"
"other","data"
"hello2","byebye2"
"hello3","byebye3"
"other","data"

and services.txt:
Code:
define service{
use generic-service
service_description TCP_80
host_name hello,hello2,hello3,nochangematch
        contact_groups
        check_command
}

nawk -v sep=',' -f fran.awk fran.csv services.txt
produces:
Code:
define service{
use generic-service
service_description TCP_80
host_name byebye,byebye2,byebye3,nochangematch
        contact_groups
        check_command
}

given nagios.cfg
Code:
define host{
use generic-host
host_name hello
alias hello.hello
address 127.0.0.1
contact_groups mymail
parents hello3
}

running:
nawk -v sep='.' -f fran.awk fran.csv nagios.cfg
produces:
Code:
define host{
use generic-host
host_name byebye
alias byebye.byebye
address 127.0.0.1
contact_groups mymail
parents byebye3
}

Check all your files against my samples - it all works for me.
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Remove 5th character from Field1 & Print

Hi , I need to remove the 5th character of column1 and print the rest. Can anybody give some advice? Input: 0001c xx 0001r gg jj 0002y vv 0002p kk 0003q gg ll 0003v tt 0003t gg pp kk Output: 0001 xx 0001 gg jj (9 Replies)
Discussion started by: Raynon
9 Replies

2. Shell Programming and Scripting

Awk to convert a flat file to CSV file

Hi , I have a file with contents as below: Contract Cancellation Report UARCNCL LOS CODE DATE REAS TYPE AMOUNT AMOUNT LETTER BY ========= ======= ==== ==== ==== ========= ==== ==== 8174739 7641509 1S NONE CRCD 30-JUN-2008 NPAR N .00 .00 CCAN 8678696 8091709 1S NONE DDEB 30-JUN-2008... (14 Replies)
Discussion started by: rkumudha
14 Replies

3. Shell Programming and Scripting

Flat file to csv conversion

Hi Guy's can someone help me in converting the following I have a flat text file which has several thousand lines which I need to convert to a csv it's got a consistent format but basically want every time it hit's txt to create a new line with the subsequent lines comma delimited for example ... (6 Replies)
Discussion started by: p1_ben
6 Replies

4. Programming

Insert value from field1 to field2 with additional info

Need help - hopefully I explain it correctly I have a table in mysql database with multiple fields. 2 of the fields are called id and id_link id id_link 93 http://test_server/testpage.cgi?93 95 96 97 98 I need to find the correct sql to update all of the id_link... (2 Replies)
Discussion started by: frustrated1
2 Replies

5. Shell Programming and Scripting

reading a csv file and creating a flat file

hi i have written a script for reading a csv file and creating a flat file, suggest if this script can be optimized #---------------- FILENAME="$1" SCRIPT=$(basename $0) #-----------------------------------------// function usage { echo "\nUSAGE: $THIS_SCRIPT file_to_process\n"... (3 Replies)
Discussion started by: mprakasheee
3 Replies

6. Shell Programming and Scripting

Match list of strings in File A and compare with File B, C and write to a output file in CSV format

Hi Friends, I'm a great fan of this forum... it has helped me tone my skills in shell scripting. I have a challenge here, which I'm sure you guys would help me in achieving... File A has a list of job ids and I need to compare this with the File B (*.log) and File C (extend *.log) and copy... (6 Replies)
Discussion started by: asnandhakumar
6 Replies

7. Shell Programming and Scripting

Replace value in csv file with match from another file

Good morning everyone and hello unix.com! I'm trying to solve a problem and was unable to find a solution after a forum research. So hopefully you can help me get this solved. I have these two csv files: file1.csv ID,REFERENCE,STATUS 1,2,0 2,4,1 3,1,0 file2.csv... (2 Replies)
Discussion started by: RKos
2 Replies

8. Shell Programming and Scripting

Compare 2 files of csv file and match column data and create a new csv file of them

Hi, I am newbie in shell script. I need your help to solve my problem. Firstly, I have 2 files of csv and i want to compare of the contents then the output will be written in a new csv file. File1: SourceFile,DateTimeOriginal /home/intannf/foto/IMG_0713.JPG,2015:02:17 11:14:07... (8 Replies)
Discussion started by: refrain
8 Replies

9. Shell Programming and Scripting

awk to update file based on partial match in field1 and exact match in field2

I am trying to create a cronjob that will run on startup that will look at a list.txt file to see if there is a later version of a database using database.txt as the source. The matching lines are written to output. $1 in database.txt will be in list.txt as a partial match. $2 of database.txt... (2 Replies)
Discussion started by: cmccabe
2 Replies

10. Shell Programming and Scripting

Converting csv file to flat file

Hi All, I have a csv file which is comma seperated. I need to convert to flat file with preferred column length country,id Australia,1234 Africa,12399999 Expected output country id Australia 1234 Africa 12399999 the flat file should predefined length on respective... (8 Replies)
Discussion started by: rohit_shinez
8 Replies

LEARN ABOUT DEBIAN

avahi.service

avahi.service(5)						File Formats Manual						  avahi.service(5)

NAME

       avahi.service - avahi-daemon static service file

SYNOPSIS

       /etc/avahi/services/*.service

DESCRIPTION

       /etc/avahi/services/*.service are XML fragments containing static DNS-SD service data. Every service file can contain multiple service def-
       initions which share the same name. This is useful for publishing service data for services which implement  multiple  protocols.  (i.e.  a
       printer implementing _ipp._tcp and _printer._tcp)

XML TAGS

       <service-group> The document tag of avahi service files. Should contain one <name> and one or more <service> elements.

       <name replace-wildcards="yes|no"> The service name. If replace-wildcards is "yes", any occurence of the string "%h" will be replaced by the
       local host name. This can be used for service names like "Remote Terminal on %h". If replace-wildcards is not specified, defaults to "no".

       <service protocol="ipv4|ipv6|any"> Contains the service information for exactly one service type. Should contain one <type> and one  <port>
       element. Optionally it may contain one <domain-name>, one <host-name>, any number of <subtype> and any number of <txt-record> elements. The
       attribute protocol specifies the protocol to advertise the service on. If any is used (which is the default), the service  will	be  adver-
       tised on both IPv4 and IPv6.

       <type> Contains the DNS-SD service type for this service. e.g. "_http._tcp".

       <subtype> Contains an additional DNS-SD service subtype for this service. e.g. "_anon._sub._ftp._tcp".

       <domain-name>  The  domain  name this service should be registered. If omited defaults to the default domain of the avahi daemon. (probably
       .local)

       <host-name> The host name of the host that provides this service. This should be a host that is resolvable by  multicast  or  unicast  DNS.
       Please  note  that  you	need  to  specify a fully-qualified domain name (FQDN) here, i.e. .local is not appended implicitly! The host name
       doesn't need to be part of the domain specified in <domain-name>. See avahi.hosts(5) for more information how to  publish  additional  host
       name mappings.

       <port> The IP port number the service listens on.

       <txt-record> DNS-SD TXT record data.

AUTHORS

       The Avahi Developers <avahi (at) lists (dot) freedesktop (dot) org>; Avahi is available from http://avahi.org/

SEE ALSO

       avahi-daemon(8), avahi.hosts(5)

COMMENTS

       This man page was written using xml2man(1) by Oliver Kurth.

Manuals 							       User							  avahi.service(5)
All times are GMT -4. The time now is 01:46 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy