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 XFREE86

dh_dwz

DH_DWZ(1)							     Debhelper								 DH_DWZ(1)

NAME
       dh_dwz - optimize DWARF debug information in ELF binaries via dwz

SYNOPSIS
       dh_dwz [debhelperoptions] [-Xitem] [--params]

DESCRIPTION
       Caveat: This tool is experimental and may disappear or change behaviour without any notice.

       dh_dwz is a debhelper program that will optimize the (uncompressed) size of the DWARF debug information in ELF binaries.  It does so by
       running dwz(1) on all the ELF binaries in the package.

OPTIONS
       -Xitem, --exclude=item
	   Exclude files that contain item anywhere in their filename from being stripped. You may use this option multiple times to build up a
	   list of things to exclude.

       -- params
	   Pass params to dwz(1) when it processes ELF binaries.  This is mostly useful for setting memory related parameters (e.g. -l and -L).

NOTES
       If the DEB_BUILD_OPTIONS environment variable contains nostrip, nothing will be stripped, in accordance with Debian policy (section 10.1
       "Binaries").

       While this tool technically does not remove debug information from binaries, it is still skipped when the DEB_BUILD_OPTIONS environment
       variable contains nostrip.  This is because nostrip is often used to optimize build times (e.g. for "build and test"-cycles) rather than
       optimizing for size.

SEE ALSO
       debhelper(7)

       This program is a part of debhelper.

AUTHOR
       Niels Thykier <niels@thykier.net>

11.1.6ubuntu2							    2018-05-10								 DH_DWZ(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