07-23-2009
segregate the file based on matching patterns
print 'test'
SETUSER 'dbo'
go
create proc abc
as
/Some code here/
go
SETUSER
go
print 'test1'
SETUSER 'dbo'
go
Create Procedure xyz
as
/some code here/
go
SETUSER
go
print 'test2'
SETUSER 'dbo'
go
now i want to create two files(with the proc names) out of it
abc.txt
xyz.txt
i need to cut the line from the first appeareance of "create" and before the first appeareance of "go"
and name the each file with the procedure name
so the two files will have the data
abc.txt will have
create proc abc
as
/Some code here/
xyz.txt will have
Create Procedure xyz
as
/some code here/
please advise on this issue
---------- Post updated at 10:09 AM ---------- Previous update was at 09:48 AM ----------
i tried
awk '/[cC]reate/,/^go/' a.txt> b.txt
how to replace set b.txt with proc name
and how to eliminate go
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi there,
I've an input file as follows:
*START
1001 a1
1002 a2
1003 a3
1004 a4
*END
*START
1001 b1
1002 b2
1004 b4
*END
*START
1001 c1
1004 c4
*END (6 Replies)
Discussion started by: kbirde
6 Replies
2. Shell Programming and Scripting
Please help me out and drag me out the deadlock I am stuck into:
I have a file. I want the statements under a if...then condition be listed in a separate file in the manner condition|statement.Following are the different input pattern and corresponding output parameters.any generic code to... (7 Replies)
Discussion started by: joyan321
7 Replies
3. Shell Programming and Scripting
I have a file name in $f. If $f has "-" at the beginning, or "=", or does not have extension ".ry" or ".xt" or ".dat" then cerr would not be empty.
Tried the following but having some problems.
set cerr = `echo $f | awk '/^-|=|!.ry|!.xt|!.dat/'` (4 Replies)
Discussion started by: kristinu
4 Replies
4. UNIX for Dummies Questions & Answers
%%%%% (9 Replies)
Discussion started by: lucasvs
9 Replies
5. Shell Programming and Scripting
At the top of the XYZ file, I need to insert the ABC data value of column 2 only when ABC column 1 matches the prefix XYZ file name (not the ".txt"). Is there an awk solution for this?
ABC Data
0101 0.54
0102 0.48
0103 1.63
XYZ File Name
0101.txt
0102.txt
0103.txt
... (7 Replies)
Discussion started by: ncwxpanther
7 Replies
6. UNIX for Dummies Questions & Answers
Hello :)
I am in this situation:
Input: two tab-delimited files, `File1` and `File2`. `File2` (`$2`) has to be parsed by patterns found in `File1` (`$1`).
Expected output: tab-delimited file, `File3`. `File3` has to contain the same rows as `File2`, plus the corresponding value in... (5 Replies)
Discussion started by: dovah
5 Replies
7. Shell Programming and Scripting
Hi All,
I have scenario where I need to zip huge number of DB audit log files newer than 90 days and delete anything older than that. If the files are too huge in number,zipping will take long time and causing CPU spikes. To avoid this I wanted to segregate files based on how old they are and... (2 Replies)
Discussion started by: veeresh_15
2 Replies
8. Shell Programming and Scripting
Hi ,
I have a situation where I need to search an xml file for the presence of a tag
<FollowOnFrom> and also , presence of partial part of the following tag <ContractRequest _LoadId and if these 2 exist ,then
extract the value from the following tag <_LocalId> which is
"CW2094139". There... (2 Replies)
Discussion started by: paul1234
2 Replies
9. Shell Programming and Scripting
Delete patterns matching
OS version: RHEL 7.3
Shell : Bash
I have a file like below (pattern.txt). I need to delete all lines starting with the following words (words separated by comma below) and ) character.
LOGGING, NOCOMPRESS, TABLESPACE , PCTFREE, INITRANS, MAXTRANS, STORAGE,... (3 Replies)
Discussion started by: John K
3 Replies
10. Shell Programming and Scripting
Hello,
I need to know all IP range (ip_prefix), associated with us-west-2 region only from this link - https://ip-ranges.amazonaws.com/ip-ranges.json (it can be opened in wordpad for better visibility)
Please suggest, how would I do it. If vi, awk or sed is needed, I have downloaded it on my... (7 Replies)
Discussion started by: solaris_1977
7 Replies
LEARN ABOUT DEBIAN
grcompiler
grcompiler(1) grcompiler(1)
NAME
grcompiler - Compile GDL into a TrueType Font
SYNOPSIS
grcompiler [-d] [-D] [-g] [-n number] [-v number] [-w number] [-wall] [-q] gdl-file font-file [output-file] [output-fontname]
Description
Grcompiler compiles a Graphite Description Language description of the smarts for a font along with a TrueType Font to create a graphite
font with graphite tables in it.
-d Generate XML debugger file.
-D Generate all debugger files.
-g Permit and ignore invalid glyph definitions.
-nnumber
Set name table start location.
-q Quiet mode (no messages except on error).
-vnumber
Set Silf table version number.
-wnnnn Ignore warning with the given number. This option may be repeated.
-wall Display all warnings.
Environment
grcompiler makes use of the following environment variables
GDLPP Specifies the command to execute to run the GDL preprocessor
Files
gdlerr.txt
Warnings and errors are output to this file.
dbg_classes.txt
Debug file that specifies the classes stored in the font in terms of their GDL source and containing glyph ids in hex.
dbg_cmap.txt
Debug file giving Unicode to glyph mapping of all the glyphs in the font and vice versa.
dbg_enginecode.txt
Debug file containing the action code and constraint code associated with each pass and rule in a pass.
dbg_fsm.txt
Debug file that gives the finite state machines of each pass and the rules referenced. For each pass, a mapping is given between
glyph and column number.
dbg_glyphattrs.txt
Debug file containing all the glyph attributes and their names, along with values specified for each glyph.
dbg_parsetree.txt
Debug file giving the complete parse tree of the GDL source file.
dbg_ruleprec.txt
Debug file that lists the rules in precedence order (order in which they will be tested) for each pass.
$_temp.gdl
Debug file containing the output of gdlpp
Author
Martin Hosken <mhosken@users.sourceforge.net>
$Date: 2012-05-29 11:36:50 $ grcompiler(1)