I have the following file. The first column is Type. Always the file will have one H and one T type in between all D type reocrds.
Need todo some validations.
Validations:
1. Number of "D" type records should be same as count mentioned in 5th field of "T" type record.
2. 10, 11 & 12 fileds should be same in all "D" type records and match with "T" type record of 2, 3 and 4 fileds respectively.
Hi,
I have a file called inputs. Now that file has the values like this:
1 2 3
Now In my script called 'get.sh' I do this :
exec < inputs
read a b c d
Now I know that there will not be any value in d. How can I check it. I need the exact condition for checking whether the variable has... (1 Reply)
Hi there,
im writing a script and trying the get the 2nd parameter and check it if its valid file or valid directory,
Example:
./test -a quiz1
i need to check quiz1 ($2)
if it matches any name of a file or directory.
Thanks (3 Replies)
i have a file in unix in which the records are like this
aaa 123 233
aaa 234 222
aaa 242 222
bbb 122 111
bbb 122 123
ccc 124 222
In the output i want only the below records
aaa
ccc
The validation logic is 1st column and 2nd column need to be considered
if both columns values are... (8 Replies)
i have a input file like this
001|rahim|bajaj|20090102
while reading the file i need to check whether the first column is a number
second column is a name
is there any methodology to check for the same
thanks in advance (2 Replies)
Hi,
I have not used Unix in a very long time and I am very rusty. I would appreciate any help I can get from the more experienced and experts in Shell script.
I am reading one file at a time from a folder. The file is a flat file with no delimeters or carriage return. Col1 through col6 is... (5 Replies)
Pardon my ignorance but I am lost on how to do this
I have a file called "Sample.txt", it is pipe delimited, it should have 13 fields. But some of the records do not, I would like to set up a shell script
where I can pass in a parameter "Sample.txt" and it would split the file into records... (2 Replies)
Hi,
I have a xml file and a xsd file(xml schema file). Here using unix script i wanted to validate the xml file by referring to xsd file. The validation is in terms of Datatype,Field length and null values. If the data present in the xml file is not matching in terms of datatype,field length... (3 Replies)
Hi,
I have basic knowledge on unix shell scripting(not an expert).
My requirement is reading the csv file using the schema defined in the configuration file and if the condition is not mached then move the unmatched record to a error file and matched good records into other file.
In brief: ... (43 Replies)
Ladies and Gents,
I need to be able to verify the file and validate the file format. Is there a way to verify this using ksh? Please forgive me, I'm very new to UNIX scripting.
12345_dbname_1_sqlname.sql
12345 - change number
dbname - database name
1 - sequence
sqlname - sql... (4 Replies)
Discussion started by: Philani
4 Replies
LEARN ABOUT PHP
cubrid_field_type
CUBRID_FIELD_TYPE(3) 1 CUBRID_FIELD_TYPE(3)cubrid_field_type - Return the type of the column corresponding to the given field offsetSYNOPSIS
string cubrid_field_type (resource $result, int $field_offset)
DESCRIPTION
This function returns the type of the column corresponding to the given field offset. The returned field type could be one of the follow-
ing: "int", "real", "string", etc.
PARAMETERS
o $result
-Array type of the fetched result CUBRID_NUM, CUBRID_ASSOC, CUBRID_BOTH.
o $field_offset
- The numerical field offset. The $field_offset starts at 0. If $field_offset does not exist, an error of level E_WARNING is also
issued.
RETURN VALUES
Type of the column, on success.
FALSE when invalid field_offset value.
-1 if SQL sentence is not SELECT.
EXAMPLES
Example #1
cubrid_field_type(3) example
<?php
$conn = cubrid_connect("localhost", 33000, "demodb");
$result = cubrid_execute($conn, "SELECT * FROM code");
$col_num = cubrid_num_cols($result);
printf("%-15s %-15s %s
", "Field Table", "Field Name", "Field Type");
for($i = 0; $i < $col_num; $i++) {
printf("%-15s %-15s %s
",
cubrid_field_table($result, $i), cubrid_field_name($result, $i), cubrid_field_type($result, $i));
}
cubrid_disconnect($conn);
?>
The above example will output:
Field Table Field Name Field Type
code s_name char
code f_name varchar
PHP Documentation Group CUBRID_FIELD_TYPE(3)