This could be an example of a record I have to work with:
Code:
2009-07-20 17:18:03.0,"15.134.13.45.13","XXXXXX","15.134.13.45.13","xxxxxxx.xxxxxxx.IT","PIN6","SQLPLUS","PFZ5","SELECT","SIP_JDSIS3_T","IFRI","='3435354454334'","select PfrfID_ID0, substr(IFRI,1,15) IFRI2, substr(ORIGINARY_IFRI,1,15) ""TO_CHAR(CAST((( TIMESTAMP '1970-01-01 00:00:00 GMT' + numtodsinterval(ROUND(CREATED_T), 'SECOND') ) at TIME ZONE 'MET') AS DATE), 'DD/MM/YYYY HH24:MI.SS') CREATED, TO_CHAR(CAST((( TIMESTAMP '1970-01-01 00:00:00 GMT' + numtodsinterval(ROUND(CREATION_DATE), 'SECOND') ) at TIME ZONE 'MET') AS DATE), 'DD/MM/YYYY HH24:MI.SS') CREAT_DATE, TO_CHAR(CAST((( TIMESTAMP '1970-01-01 00:00:00 GMT' + numtodsinterval(ROUND(MOD_T), 'SECOND') ) at TIME ZONE 'MET') AS DATE), 'DD/MM/YYYY HH24:MI.SS') from SIP_IFR03_T where IORI='3653453437941'","1"
I read it from a csv file in UNIX format.
The result of the simple script example I posted before is that this informations are printed in multiple lines... and some caracters are disappearing, so I have no possibility to work with it...
I really have no idea......
Thank you!
---------- Post updated at 03:00 PM ---------- Previous update was at 02:56 PM ----------
My intention was to use the pattern "," as separator for the field and add an empty field where it needs it, with awk.
But Double Quote are disappearing...And the single record is splitted in little parts...
mmm...
Last edited by vgersh99; 09-02-2009 at 01:47 PM..
Reason: code tags, PLEASE!
Still working on manipulating SQL statements. Some are very long (10-20k). I'm using a shell script to read the SQL statements that are stored in a DB2 table and writing the records out to a file on Unix. The records appear to be getting truncated at 8k.
Is there any way for me to avoid the... (1 Reply)
Hi, I'm writing a long script for bash (on RHEL 5.0) to execute many commands. So, my idea is to create a function to deal with error checking and logging (see ceckoutput() below). This works with all commands except for sed. I think it may be a problems with escaped characters. So I did the... (4 Replies)
I have a text file which represents a http flow like this:
HTTP/1.1 200 OK
Date: Fri, 23 Jan 2009 17:16:24 GMT
Server: Apache
Last-Modified: Fri, 23 Jan 2009 17:08:03 GMT
Accept-Ranges: bytes
Cache-Control: max-age=540
Expires: Fri, 23 Jan 2009 17:21:31 GMT
Vary: Accept-Encoding ... (1 Reply)
Hello,
I am currently trying to edit an ldif file. The ldif specification states that a newline followed by a space indicates the subsequent line is a continuation of the line. So, in order to search and replace properly and edit the file, I open the file in textwrangler, search for "\r " and... (14 Replies)
Hi all-
I've got a file that will have multiple columns. In one column there will be a string that is 10 digits in length, but I need to trim the first four zeros to make it 6 characters?
example:
0000001234
0000123456
0000234566
0000000321
output:
001234
123456
234566
000321 (5 Replies)
how i can read a long integer from standar input and a string with as many characters as specified in the number?
i thing that i must use the read command ofcourse.... (6 Replies)
Hi, this is my first post and hope to make some contribution soon.
I'm still learning the basics of UNIX and Linux and BASH. Thus my need to understand the subject at hand. I don't have a problem with technical detail, so hit me :)
I have a script where two commands use the contents of a... (2 Replies)
Hi Friends ,
Need help here , I Have a file which has as a number of rows (records) in it .
00012919 7836049 S
00012920 7836049 S
00012921 3828157 Y
00012922 3828157 Y
00012923 3828157 S
T005290070331000012923
I Have another file which has few more... (3 Replies)
Hi Experts,
I have a Unix csv file which has long records ie the record length is more than 80 so it goes to the next line.So when its in unix though it spans to two or three lines it still counts it as one record.
But what is happening is for the records that are long when i copy it into excel i... (0 Replies)
Good morning all, I have a machine running IRIX and I need to edit a text file on the terminal that is literally thousands of lines. Does anyone know the most efficient way to edit portions of files like these? Obviously simply using the vi command isn't going to work since I get a too many lines... (1 Reply)
Discussion started by: James C
1 Replies
LEARN ABOUT DEBIAN
interface-order
INTERFACE-ORDER(5) resolvconf INTERFACE-ORDER(5)NAME
interface-order - resolvconf configuration file
DESCRIPTION
The file /etc/resolvconf/interface-order is used to control the order in which resolvconf nameserver information records are processed by
those resolvconf update scripts that consult this file. (The name of the file is apt because a resolvconf nameserver information record is
named after the interface with which it is associated.)
The file contains a sequence of shell glob patterns, one per line. The position of a record in the order is the point at which its name
first matches a pattern.
Patterns may not contain whitespace, slashes or initial dots or tildes. Blank lines and lines beginning with a '#' are ignored.
Resolvconf update scripts in /etc/resolvconf/update.d/ that consult this file include the current default versions of dnsmasq, pdnsd and
libc. (Actually they don't read the file directly; they call the utility program /lib/resolvconf/list-records which lists records in the
specified order and omits the names of empty records.)
EXAMPLE
# /etc/resolvconf/interface-order
# Use nameservers on the loopback interface first.
lo*
# Next use records for Ethernet interfaces
eth*
# Next use records for Wi-Fi interfaces
wlan*
# Next use records for PPP interfaces
ppp*
# Last use other interfaces
*
AUTHOR
Resolvconf was written by Thomas Hood <jdthood@gmail.com>.
COPYRIGHT
Copyright (C) 2004, 2011 Thomas Hood
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.
SEE ALSO resolvconf(8)resolvconf 18 May 2011 INTERFACE-ORDER(5)