parse apl-numeric codes from filenames, and match them to entries in database Post: 302405982

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Script to parse filenames in a directory and do some actions

Hi All, I don't have much experience in scripting, and couldn't find anything that will help me to write a script I need, hopefully you can help me with it. I have lots of files in one directory with the following file name pattern: 100001-something.ext1 100101-something2.ext2...

2. Shell Programming and Scripting

perl, testing a database for a match

hi there. in perl, I am struggling to find a simple method of connecting to a database, determining if the result of my query is "true" and then testing against the result. I dont even really want the data that i am 'SELECT'�ng. i effectively just want to check that a record exists with a UID...

3. Shell Programming and Scripting

awk to match a numeric range specified by two columns

Hi Everyone, Here's a snippet of my data: File 1 = testRef2: A1BG - 13208 13284 AAA1 - 34758475 34873943 AAAS - 53701240 53715412File 2 = 42MLN.3.bedS2: 13208 13208 13360 13363 13484 13518 13518My awk script: awk 'NR == FNR{a=$1;next} {$1>=a}{$1<=a}{print...

4. Shell Programming and Scripting

Korn shell program to parse CSV text file and insert values into Oracle database

Enclosed is comma separated text file. I need to write a korn shell program that will parse the text file and insert the values into Oracle database. I need to write the korn shell program on Red Hat Enterprise Linux server. Oracle database is 10g.

5. Shell Programming and Scripting

Awk numeric range match only one digit?

Hello, I have a text file with lines that look like this: 1974 12 27 -0.72743 -1.0169 2 1.25029 1974 12 28 -0.4958 -0.72926 2 0.881839 1974 12 29 -0.26331 -0.53426 2 0.595623 1974 12 30 7.71432E-02 -0.71887 3 0.723001 1974 12 31 0.187789 -1.07114 3 1.08748 1975 1 1 0.349933 -1.02217...

6. Shell Programming and Scripting

How to parse a numeric string without any delimiters?

Hi , I have a number say 12345001 which needs to be parsed. Its a number that has no delimiters.I have to read the last three digits and then the rest of digits irrespective of the total length of the number. The digits then have to be swapped and changed to a fixed length. The fillers to be...

7. Shell Programming and Scripting

Parse through ~21,000 Database DDL statements -- Fastest way to perform search, replace and insert

Hello All: We are looking to search through 2000 files with around 21,000 statements where we have to search, replace and insert a pattern based on the following: 1) Parse through the file and check for CREATE MULTISET TABLE or CREATE SET TABLE statements.....and they always end with ON...

8. Shell Programming and Scripting

Parse log file to insert into database

I have a log file that's created daily by this command: sar -u 300 288 >> /var/log/usage/$(date "+%Y-%m-%d")_$(hostname)_cpu.log It that contains data like this: Linux 3.16.0-4-amd64 (myhostname) 08/15/2015 _x86_64_ (1 CPU) 11:34:17 PM CPU %user %nice ...

9. Shell Programming and Scripting

awk parse result that match data from file

i run command that return this result,example : gigabitethernet2/2/4:NotPresent, gigabitethernet2/1/17:UP, gigabitethernet2/1/10:UP, gigabitethernet2/1/5:UP, gigabitethernet2/1/9:UP, gigabitethernet2/1/36:DOWN, gigabitethernet2/1/33:DOWN, gigabitethernet2/1/8:UP,...

10. UNIX for Beginners Questions & Answers

Pattern Match FileNames

I am on AIX. I need to list the contents of the directory based on a pattern and write an XML output file with file names. If a filename does NOT match the below pattern then write an OUTPUT xml file in the below xml format Pattern Starts with (.abc) and contains (def) Starts with...

LEARN ABOUT DEBIAN

erubis

ERUBIS(1)							   User Commands							 ERUBIS(1)

NAME

       erubis - eRuby style template engine for multiple languages

SYNOPSIS

       erubis [..options..] [file ...]

DESCRIPTION

       Embedded  templating  engine  for multiple languages.  Erubis will take a template file as input and output code to convey that data in the
       language specified.  The following output languages are supported:

	       * Ruby
	       * PHP
	       * C
	       * Java
	       * Scheme
	       * Perl
	       * JavaScript

OPTIONS

       -h, --help
	      help

       -v     version

       -x     show converted code

       -X     show converted code, only ruby code and no text part

       -N     numbering: add line numbers	     (for '-x/-X')

       -U     unique: compress empty lines to a line (for '-x/-X')

       -C     compact: remove empty lines	     (for '-x/-X')

       -b     body only: no preamble nor postamble   (for '-x/-X')

       -z     syntax checking

       -e     escape (equal to '--E Escape')

       -p pattern
	      embedded pattern (default '<% %>')

       -l lang
	      convert but no execute (ruby/php/c/java/scheme/perl/js)

       -E e1,e2,...
	      enhancer names (Escape, PercentLine, BiPattern, ...)

       -I path
	      library include path

       -K kanji
	      kanji code (euc/sjis/utf8) (default none)

       -c context
	      context data string (yaml inline style or ruby code)

       -f datafile
	      context data file ('*.yaml', '*.yml', or '*.rb')

       -T     don't expand tab characters in YAML file

       -S     convert mapping key from string to symbol in YAML file

       -B     invoke 'result(binding)' instead of 'evaluate(context)'

       --pi=name
	      parse '<?name ... ?>' instead of '<% ... %>'

   supported properties:
	      * (common)

       --escapefunc=nil
	      : escape function name

       --pattern="<% %>"
	      : embed pattern

       --trim=true
	      : trim spaces around <% ... %>

       --preamble=nil
	      : preamble (no preamble when false)

       --postamble=nil
	      : postamble (no postamble when false)

       --escape=nil
	      : escape expression or not in default

	      * (basic) * (pi)

       --pi="rb"
	      : PI (Processing Instrunctions) name

       --embchar="@"
	      : char for embedded expression pattern('@{...}@')

	      * ruby * php * c

       --indent=""
	      : indent spaces (ex. '  ')

       --out="stdout"
	      : output file pointer name

	      * java

       --indent=""
	      : indent spaces (ex. '  ')

       --buf="_buf"
	      : output buffer name

       --bufclass="StringBuffer" : output buffer class (ex. 'StringBuilder')

	      * scheme

       --func="_add"
	      : function name (ex. 'display')

	      * perl

       --func="print"
	      : function name

	      * javascript

       --docwrite=true
	      : use 'document.write()' when true

EXAMPLES

       Run 'erubis -l php example.ephp' to convert the embedded document to php code.

       example.ephp:
	<?xml version="1.0"?>
	<html>
	 <body>
	  <p>Hello <%= $user %>!</p>
	  <table>
	   <tbody>
	    <% $i = 0; %>
	    <% foreach ($list as $item) { %>
	    <%	 $i++; %>
	    <tr bgcolor="<%= $i % 2 == 0 ? '#FFCCCC' : '#CCCCFF' %>">
	     <td><%= $i %></td>
	     <td><%== $item %></td>
	    </tr>
	    <% } %>
	   </tbody>
	  </table>
	 </body>
	</html>

SEE ALSO

       http://rubyforge.org/projects/erubis/

erubis 2.6.2							   January 2009 							 ERUBIS(1)

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Script to parse filenames in a directory and do some actions

Discussion started by: troman

2. Shell Programming and Scripting

perl, testing a database for a match

Discussion started by: rethink

3. Shell Programming and Scripting

awk to match a numeric range specified by two columns

Discussion started by: heecha

4. Shell Programming and Scripting

Korn shell program to parse CSV text file and insert values into Oracle database

Discussion started by: shellguy