The solution is quite simple: you search for records with more than 2 double-quotes between any two delimiter-characters (in your case ","). The following regexp should do this. Use grep to search for such lines and grep -v to search for valid lines:
Note that this will not find such lines if the problematic field is the first one. Search for such lines with the slightly altered regexp:
With older Linux servers, the command:
ls -al
would output text that would have the filenames all lined up in the same column (the owner and group names were truncated to produce a uniform right column).
In newer distros (i.e. RHEL 3), the command will push the right column out when owners... (0 Replies)
Hi, I try to marshal a unsigned int and a char * into a buffer, and then unmarshal them later to get them out. I need to put the char * in the front and unsigned int at the end of the buffer. However, my system always give me "BUS ERROR". I am using Sun Sparcs Sloris 2.10.
My code to marshal the... (1 Reply)
Hi there,
I'm trying to find files that are greater then 30 days old, zip them and move to a different directory. I'm encountering an issue passing a variable (FilesToFind) to name within the find command. Here's the code I'm running:
#! /usr/bin/sh
FileDir=/home/ariba... (2 Replies)
The client's app gets a 'suspend error' which they say is due to a null pointer exception. Application people say nothing's wrong with the app. Network people say the network's fine. I'm supposed to see what's wrong with the system to be causing this error. I checked the NIC card settings, which... (1 Reply)
Hi Gurus,
This is my raw data. How would I able to format this output into a better alignment?
/dev/vg00/lvol5 /home 0.12 GB 0.02 GB 0.10 GB 19%
/dev/vg00/misc /misc 28.43 GB 4.92 GB 23.51 GB 17%
/dev/vg00/lvol6 /opt 8.25 GB 5.43 GB 2.82 GB 65%
/dev/vgsap/ora10264 ... (10 Replies)
HI all,
I tried to edit my files using HP-UX but my output tends to not align when I add another character in the files
to edit my files i used the command is as follow
chmod +w filename
vi filename
Help, :eek: (1 Reply)
can someone please explain to me what i'm doing wrong with this code:
WELT=$(awk '(($1 ~ "^${caag}$") || ($2 ~ "^${caag}$"))' /tmp/Compare.TEXT)
when run from the command line, it works. but it seems to be having a problem doing the comparison when variables are involved.
i tested from... (1 Reply)
Hi
I have a JAVA based application in development and production environment. These two environments are exactly identical in terms of OS, hardware and application components.
Initially the OS was Solaris 5.6 and the application was working fine in both environments. But later when the OS... (12 Replies)
Hi Guru,
I need some advice on how to add blank spaces to the code, rather than me just adding <space-bar spaces> which does not work.
Current output of the code
File System Backed Up - ALL_LOCAL_DRIVES
Daily - Incremental Backup Schedule - 1 Month Retention
• 7pm - PRD... (2 Replies)
Discussion started by: Junes
2 Replies
LEARN ABOUT PHP
odbc_tables
ODBC_TABLES(3) 1 ODBC_TABLES(3)odbc_tables - Get the list of table names stored in a specific data sourceSYNOPSIS
resource odbc_tables (resource $connection_id, [string $qualifier], [string $owner], [string $name], [string $types])
DESCRIPTION
Lists all tables in the requested range.
To support enumeration of qualifiers, owners, and table types, the following special semantics for the $qualifier, $owner, $name, and $ta-
ble_type are available:
o If $qualifier is a single percent character (%) and $owner and $name are empty strings, then the result set contains a list of
valid qualifiers for the data source. (All columns except the TABLE_QUALIFIER column contain NULLs.)
o If $owner is a single percent character (%) and $qualifier and $name are empty strings, then the result set contains a list of
valid owners for the data source. (All columns except the TABLE_OWNER column contain NULLs.)
o If $table_type is a single percent character (%) and $qualifier, $owner and $name are empty strings, then the result set contains
a list of valid table types for the data source. (All columns except the TABLE_TYPE column contain NULLs.)
PARAMETERS
o $connection_id
-The ODBC connection identifier, see odbc_connect(3) for details.
o $qualifier
- The qualifier.
o $owner
- The owner. Accepts search patterns ('%' to match zero or more characters and '_' to match a single character).
o $name
- The name. Accepts search patterns ('%' to match zero or more characters and '_' to match a single character).
o $types
- If $table_type is not an empty string, it must contain a list of comma-separated values for the types of interest; each value
may be enclosed in single quotes (') or unquoted. For example, "'TABLE','VIEW'" or "TABLE, VIEW". If the data source does not sup-
port a specified table type, odbc_tables(3) does not return any results for that type.
RETURN VALUES
Returns an ODBC result identifier containing the information or FALSE on failure.
The result set has the following columns:
oTABLE_QUALIFIER
oTABLE_OWNER
oTABLE_NAME
oTABLE_TYPE
oREMARKS
The result set is ordered by TABLE_TYPE, TABLE_QUALIFIER, TABLE_OWNER and TABLE_NAME.
SEE ALSO odbc_tableprivileges(3).
PHP Documentation Group ODBC_TABLES(3)