sed parse a lign into a new sql file Post: 302546205

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

To parse through the file and print output using awk or sed script

suppose if u have a file like that Hen ABCCSGSGSGJJJJK 15 Cock ABCCSGGGSGIJJJL 15 * * * * * * : * * * . * * * : Hen CFCDFCSDFCDERTF 30 Cock CHCDFCSDHCDEGFI 30 * . * * * * * * * : * * :* : : . The output shud be where there is : and . It shud...

2. Shell Programming and Scripting

SED + Regex + SQL Input file

Here's the problem... I have a mysqldump file and I need to put single quotes around the date/time timestamp. So for example I have a line like: INSERT INTO attachments VALUES (1,182,2004-08-06 09:24:04,'description'... and I need it to become INSERT INTO attachments VALUES...

3. Shell Programming and Scripting

sed command to parse Apache config file

Hi there, am trying to parse an Apache 'server' config file. A snippet of the config file is shown below: ..... ProxyPassReverse /foo http://foo.example.com/bar ..... ..... RewriteRule ^/(.*) http://www.example.com/$1 RewriteRule /redirect https://www.example1.com/$1 ........

4. Shell Programming and Scripting

sed parse small xml file

I have a tmp.xml file like: <?xml version="1.0" encoding="UTF-8"?> <Response> <Ip>193.143.121.198</Ip> <Status>OK</Status> <CountryCode>PL</CountryCode> <CountryName>Poland</CountryName> <RegionCode>82</RegionCode> <RegionName>Pomorskie</RegionName> <City>Gdansk</City> ...

5. Shell Programming and Scripting

formating sql file using awk or sed

Hi, I have a file where I would like to add a prompt type object_name statement before every create commnad create or replace force view test_view_01 ( col1 col2 col3 ) as (select a,b,c from sometable ); create or replace view test_view_02 ( col4 col5 col6 ) as

6. Shell Programming and Scripting

script to parse text file into sql commands

Hello all, I tried searching for something similiar before posting but couldn't come up with anything that fit what I need. In Linux, I'm trying to parse through a number of files and take the info in them and put it into mysql. My file is a dump from an expect script: ---filename...

7. Shell Programming and Scripting

Sed to parse log file

Hi all, thanks for reading the post. I'm trying to parse hundreds of log files in a directory. One log file looks similar to below: Investigator : Jim_Foo Custodian : Jim_Foo-HDD1-FOO-1234 Export Path : N:\FOO-1234\Foo_Foo Compute MD5 : No File List Only: No Extensions Selected:...

8. Shell Programming and Scripting

sql dump file - how to get certain values using sed

Hi, I have a dumpfile.sql - ========Start of file================= CREATE DATABASE /*!32312 IF NOT EXISTS*/ `mysql` /*!40100 DEFAULT CHARACTER SET latin1 */; CREATE TABLE `test_table1` ( `id` int ) AUTO_INCREMENT=12 CREATE TABLE `test_table2` ( `id` int ) AUTO_INCREMENT=120...

9. Shell Programming and Scripting

Parse SQL text and only format first SELECT statement.

Hi Forum. Need your expertise on the following question. I have the following file which I would like to parse, find first block of SELECT statment and concatenate all input fields as 1 field (~ delimited): Old File: SELECT /*+ USE_HASH(CCOMM ICAR IMAP IAS IP IMAS IMPS IAP SPCA) */ ...

10. Programming

Parse with SQL

I am trying to parse a string using SQL but am too new and still learning. I have text in a control or field 685 that is variable, but always the same format. field 685 input arr 2q33.3q34(200,900,700-209,000,000)x2 xxx Desired output 2:200900700-209000000 Basically, the # after the...

LEARN ABOUT SUSE

rubibtex

rubibtex(1)							       teTeX							       rubibtex(1)

NAME

       rubibtex - make a bibliography for (La)TeX using Russian letters as item names

SYNOPSIS

       rubibtex BASENAME

DESCRIPTION

       rubibtex is used to run bibtex(1) on auxiliary files with Russian characters in item names (citation keys).  It is part of the T2 package.

       rubibtex  copies the auxiliary file to /tmp, uses sed(1) to convert Cyrillic character commands to their 8-bit ASCII equivalents; runs bib-
       tex(1) on the modified file; and finally moves the original auxiliary file back (overwriting the modified file).

       rubibtex assumes that the bibtex(1) database (bib) files are encoded with the KOI8-R encoding.

FILES

       basename.aux
	      LaTeX auxiliary file

BUGS

       None known, but report any bugs found to the authors.

COPYRIGHT

       The T2 package is Copyright 1997-1999 Werner Lemberg, Vladimir Volovich and any individual authors listed elsewhere in package files.

       It may be distributed under the conditions of the LaTeX Project Public License, either version 1.1 of this license or (at your option)  any
       later version.

SEE ALSO

       bibtex(1), sed(1), <ftp://ftp.vsu.ru/pub/tex/T2/README>.

AUTHOR

       Werner Lemberg <wl@gnu.org>, Vladimir Volovich <TeX@vvv.vsu.ru>.

       This manual page was written by C.M. Connelly <c@eskimo.com>, for the Debian GNU/Linux system.  It may be used by other distributions with-
       out contacting the author.  Any mistakes or omissions in the manual page are my fault; inquiries about or corrections to this  manual  page
       should be directed to me (and not to the primary author).

teTeX								   October 2000 						       rubibtex(1)

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

To parse through the file and print output using awk or sed script

Discussion started by: cdfd123

2. Shell Programming and Scripting

SED + Regex + SQL Input file

Discussion started by: primal

3. Shell Programming and Scripting

sed command to parse Apache config file

Discussion started by: jy2k7ca

4. Shell Programming and Scripting

sed parse small xml file

Discussion started by: unclecameron