Sponsored Content
Top Forums Shell Programming and Scripting Find and replace variables using a csv table Post 302740673 by biscayne on Thursday 6th of December 2012 02:41:23 PM
Old 12-06-2012
Wow, that's cool
I guess I can pipe to sed and do the magic now Smilie
Many thanks for your help !
 

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
TXT2REGEX(1)						      General Commands Manual						      TXT2REGEX(1)

NAME
txt2regex - a Regular Expression Wizard, written with bash2 builtins SYNOPSIS
txt2regex txt2regex --nocolor|--whitebg txt2regex --all|--prog <p1,p2,...,pN> txt2regex --showmeta|--showinfo <program> txt2regex --make <target> txt2regex --history <value> DESCRIPTION
txt2regex is a Regular Expression "wizard", all written with bash2 builtins, that converts human sentences to regexes. With a simple interactive interface, you just answer to questions and build your own regex for a large variety of programs, like awk, emacs, grep, perl, php, procmail, python, sed and vim. There are more than 20 supported programs. It's bash so download and run, no compilation needed. Please visit the program homepage at http://txt2regex.sf.net. OPTIONS
--all works with all registered programs --help prints the help message and quit --history <value> prints to STDOUT a regex from a history data --make <target> prints a ready regex for a common pattern --nocolor self-explanatory --prog <p1,p2,...> choose which programs to use (separated by commas) --showinfo <program> prints regex info about the program --showmeta prints a complete metachar table for all programs --version prints the program version and quit --whitebg colors adjusted to white background terminals By default, all options are turned OFF. Just call it with no options to launch the default interactive interface. DETAILS
--all is cool but requires lots of lines (~35) --nocolor is strong, so it kills --whitebg --showmeta rules, try it --showinfo uses reverse video output, --nocolor turns it off --history is getting useful, stay tunned --make is a remedy for headaches --prog is nice to use your favorite programs, mix it with --make and --history EXAMPLES
Calling the program on the default interactive interface $ txt2regex Calling the program on a white terminal $ xterm -fg black -bg white ; txt2regex --whitebg Getting information $ txt2regex --showmeta Getting specific information $ txt2regex --showinfo sed Calling it for specific programs $ txt2regex --prog vim,sed,grep,python Applying a history data $ txt2regex --history '16421x:01x:' Getting ready regexes! $ txt2regex --make hour $ txt2regex --make number3 --prog perl $ txt2regex --make date2 --all INTERFACE
The program interface is simple and easy to use. This is its contents: +---------------------------------------+ | -> Top menu | | -> Group menu | | | | -> Regexes of the programs selected | | ... | | ... | | | | -> History | | -> Your prompt | | | | -> The question | | -> The answers | | ... | | ... | +---------------------------------------+ All the basic commands can be used on the numeric pad on the keyboard, but remember to turn ON the NumLock key. Command Description . Quit the program (with confirmation) 0 Reset the Regular Expression 1-9 Answers the questions * Toggles color ON/OFF / Add/remove programs on/from the list | Insert an alternation (where allowed) ( Open a new group (where allowed) ) Close the opened group (if any) BUGS
Bug reports and contributions are VERY welcome! Please send them to the author. AUTHOR
Written and maintained by Aurelio Marinho Jargas <verde@aurelio.net> COPYRIGHT
Copyright (C) 2000, 2001, 2002, 2003, 2004 Aurelio Marinho Jargas This is free software; see the source for copying conditions. There is NO warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICU- LAR PURPOSE. September, 28th - 2004 TXT2REGEX(1)
All times are GMT -4. The time now is 04:47 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy