Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Find and replace variables using a csv table
Top Forums Shell Programming and Scripting Find and replace variables using a csv table Post 302740551 by biscayne on Thursday 6th of December 2012 10:46:50 AM
Old 12-06-2012
Find and replace variables using a csv table
I have a flat file (template) where I want to replace variables based upon a value in another file (csv).
The variables in the template are named %VAR_X_z%
The values are in the csv file and X is field 0 of each line and y field 1 and up.

Example of the csv:
Code:
Badidas, 13.00, 12.00, 11.00, 10.00
Cuma, 12.00, 11.00, 10.00, 9.00
Dswiss, 23.00, 22.00, 18.00, 16.00

Now I want to replace each variable field in the template with the values of the csv file.
%VAR_Cuma_1 becomes 12.00
%VAR_Cuma_2 becomes 11.00
etcetera
What would be the best way to do this ? Awk, sed or maybe a combo of both ?
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

HTML table to CSV

Hi !! I have HTML Tables through which i want to generate graphs, but for creating graphs i need the file in CSV format so can anyone can please help me in how can i convert my HTML table file to CSV format. Thanks in Advance (2 Replies)
Discussion started by: i_priyank
2 Replies

2. UNIX for Dummies Questions & Answers

How do I read/find/replace fields in a csv datafile?

hello. I'm somewhat a novice here so please be patient. My stumbling block when loading csvs into ORACLE tables is this: I need to read a csv datafile, check several fields in each line, and if any of stated fields contain A ZERO only then replace it with a null/blank character. I had a... (9 Replies)
Discussion started by: MrCarter
9 Replies

3. Shell Programming and Scripting

csv to table one-liner

I've googled a lot on this, but could not fine a simple one-liner to do this. I have a .csv file that looks like this: Header one Header two Header three col1,col2,col3 short data, very long data, dataIf I use sed and change the comma to tab, being the colums of variable length I don't get a... (6 Replies)
Discussion started by: ahsog
6 Replies

4. Shell Programming and Scripting

find & replace comma in a .csv file.

HI, Please find the text below. I receive a .csv file on server. I need the comma(,) in the second column to be replaced by a semi-colon( ; ). How to do it. Please help. Sample text: "1","lastname1,firstname1","xxxxxx","19/10/2009","23/10/2009","0","N","Leave"... (2 Replies)
Discussion started by: libin4u2000
2 Replies

5. Shell Programming and Scripting

Converting .xls into .csv and find & Replace

Hi All, Please give me the solution to the following ASAP. 1) Converting the .xls into .csv Script i tried, mv hello.xls hello.csv The above given script converting the .xls file into .csv successfully. But after i run the below unix command I am no able to open the .csv file, its giving... (4 Replies)
Discussion started by: velava
4 Replies

6. UNIX for Dummies Questions & Answers

Storing data from a table into a csv file

Hi I need to write a bash script to take the data stored in 3 oracle tables .. and filter them and store the results in a csv file. It is an Oracle database Thank you (1 Reply)
Discussion started by: ladyAnne
1 Replies

7. Shell Programming and Scripting

Convert file in csv or table

Hi there, i have a file like that in attachment (PLEVA3_280711_SAP.txt), i would extract some basic information from it and report in a new file or table like this: i try to use bash and i extract the single object in this way (see attach scriptino.sh), but i receive a strange... (5 Replies)
Discussion started by: alen192
5 Replies

8. UNIX for Dummies Questions & Answers

Find & Replace identifiers using a conversion table

Hi ! I have input.tab with one column containing Item IDs under a number format (the second column is the Location of this item): Location Item ID rack1 12; 35; 43 rack35 23; 894; 5478; 98 etc... (The number of Items per row is variable. Item IDs in a same field are... (17 Replies)
Discussion started by: lucasvs
17 Replies

9. Shell Programming and Scripting

Update the table using values from a csv file

i want to run update query for oracle which is in up.sql taking values from a.csv. I have implemented shell script to do it. extn="perl" ls -1 | while read file do echo "$file,$extn" > a.csv done up.sql contains update file_list set filename=$1 where extn=$2; The code to update is... (2 Replies)
Discussion started by: millan
2 Replies

10. UNIX for Beginners Questions & Answers

Generate files and use csv data to replace multiple variables in a template

I have a source csv file consists of first field as variable name, and the rest are site-specific information (converted from excel file, where site -specific values in columns). I am trying to create a file for every site using a template and replace the multiple variables with values from the... (3 Replies)
Discussion started by: apalex
3 Replies

LEARN ABOUT DEBIAN

dbatbl

DBATBL(1)						      General Commands Manual							 DBATBL(1)

NAME

       dbatbl - Manage on-disk reference tables for DB-ALLe

SYNOPSIS

       dbatbl [command] [options] [args...]

DESCRIPTION

       This tool allows to index and query the tables that are needed for normal functioning of DB-ALLe.

       dbatbl always requires a non-switch argument, that indicates what is the operation that should be performed:

       help
	      Print a help summary.

       help manpage
	      Print this manpage.

       cat tableid [tableid [...]]
	      Output all the contents of a WMO B table..

       grep string
	      Output all the contents of the local B table whose description contains the given string..

       expand table-entry [table-entry [...]]
	      Describe a WMO B table entry or expand a WMO D table entry in its components..

       expandcode varcode [varcode [...]]
	      Expand the value of a packed variable code.

       index [options] filename index-id
	      Index the contents of a table file.

       describe [options] what [values]
	      Invoke the formatter to describe the given values.  Supported so far are: "level ltype l1 l2", "trange pind p1 p2".

OPTIONS

       dbatbl follows the usual GNU command line syntax, with long options starting with two dashes (`-').

   Option for command cat
       -?, --help
	      print an help message

       -c, --csv
	      output variables in CSV format

   Option for command grep
       -?, --help
	      print an help message

       -c, --csv
	      output variables in CSV format

   Option for command expand
       -?, --help
	      print an help message

   Option for command expandcode
       -?, --help
	      print an help message

   Option for command index
       -?, --help
	      print an help message

       -t type, --type=type
	      format of the table to index ('b', 'd', 'conv')

   Option for command describe
       -?, --help
	      print an help message

AUTHOR

       dbatbl has been written by Enrico Zini <enrico@enricozini.com> for ARPA Emilia Romagna, Servizio Idrometeorologico.

								   may 16, 2012 							 DBATBL(1)
All times are GMT -4. The time now is 04:25 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy