Hey Guys,
I have a very urgent requirement regaridng the searching for value on the text file.
The text file is in the below format
Number Description
"112323", mysampletest1
"12122412", mysampletest2
"11232143", mysampletest3
I need to get the first column like
112323... (2 Replies)
Say I had a text file that contained four columns, like the following:
Mack Christopher:237 Avondale Blvd:970-791-6419:S
Ben Macdonor:30 Dragon Rd:647-288-6395:B
I'm making a loop that will replace the fourth column a line in the file with the contents of a variable 'access', but I have no... (6 Replies)
Hi,
I need to find out the last column value from a text file which is delimited by a tab.
The issue here is the last column# for each record can be different i.,e, 1st record can have the last column as 15 and the second record can have the last column as "17".
I have to search a string... (3 Replies)
I want to add a new column to a tab delimited text file. It will be the first column and it will just be 1's. How do I go about doing that? Thanks! (1 Reply)
I would like to extract the last column of a text file but different rows of the text file have different numbers of columns. How do I go about doing that? Thanks! (1 Reply)
Hi,
I am converting a .DBF file to pipe delimited file
my requirement is like
lets say my .DBF is residing in path /a/b/c/d/f/abc.DBF
I need my .txt file as
having a column with source _cd =f
sample data in .DBF in folder "f"
c1 c2 c3
1 2 3
in txt file it should be... (4 Replies)
Hi,
I have a text file with many column (1,000,000+). I want to add a column of 0's as the third column. I tried:
awk '{$3=0}1' input file > output file
But it simply replaces the third column with 0's instead of adding a new column. How do I go about doing this? Thanks! (2 Replies)
Hi,
I need to compare 2 text files with around 60000 rows and 1 column. I need to compare these and write the mismatch data to 3rd file.
File1 - file2 = file3
wc -l file1.txt
58112
wc -l file2.txt
55260
head -5 file1.txt
101214200123
101214700300
101250030067
101214100500... (10 Replies)
Discussion started by: Divya Nochiyil
10 Replies
LEARN ABOUT PHP
db2_field_scale
DB2_FIELD_SCALE(3) 1 DB2_FIELD_SCALE(3)db2_field_scale - Returns the scale of the indicated column in a result setSYNOPSIS
int db2_field_scale (resource $stmt, mixed $column)
DESCRIPTION
Returns the scale of the indicated column in a result set.
PARAMETERS
o $stmt
- Specifies a statement resource containing a result set.
o $column
- Specifies the column in the result set. This can either be an integer representing the 0-indexed position of the column, or a
string containing the name of the column.
RETURN VALUES
Returns an integer containing the scale of the specified column. If the specified column does not exist in the result set,
db2_field_scale(3) returns FALSE.
SEE ALSO db2_field_display_size(3), db2_field_name(3), db2_field_num(3), db2_field_precision(3), db2_field_type(3), db2_field_width(3).
PHP Documentation Group DB2_FIELD_SCALE(3)