10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
hai guys,
pick the 1st field and calculate max length.
if suppose max length is 2,
then compare the all records if <2 then add zero's prefix of the record.
for ex:
s.no,sname
1,djud
37,jtuhe
in this max length of the 1st field is 2 right
the output wil be
s.no,sname
01,djud... (6 Replies)
Discussion started by: Suneelbabu.etl
6 Replies
2. Shell Programming and Scripting
Hi,
I have a huge file that has data something like shown below:
huge_file.txt
start regexp
Name=Name1
Title=Analyst
Address=Address1
Department=Finance
end regexp
some text
some text
start regexp
Name=Name2
Title=Controller
Address=Address2
Department=Finance
end regexp (7 Replies)
Discussion started by: r3d3
7 Replies
3. Shell Programming and Scripting
Hi All,
I am new to perl and was trying to write a simple program which will generate a text file as output..
now the output which i am getting is something like this..
==================================================================================================
Col1 ... (8 Replies)
Discussion started by: smarty86
8 Replies
4. Shell Programming and Scripting
Hello Everyone,
I am stuck with one issue while working on abstract flat file which i have to use as input and load data to table.
Input Data-
------ ------------------------ ---- -----------------
WFI001 Xxxxxx Control Work Item A Number of Records
------ ------------------------... (5 Replies)
Discussion started by: sonali.s.more
5 Replies
5. UNIX for Dummies Questions & Answers
Hey Any one...
Do u know any way I can modify the max username length in unix? I guess it is 32/64 characters by default. Suppose I want to increase it to 128.
i hav tried /etc/skel
but no use...
How can I do that? (2 Replies)
Discussion started by: MayureshRisbud
2 Replies
6. UNIX for Advanced & Expert Users
Hi,
This is my first post to this site. So kindly forgive if I am writing in a wrong section.
My query is that...
I want to modify the max username length size. I guess it is 32/64 on CentOS. Now I want to change it to 128. Is there any way to do that?
Thanks in advance!! :) (4 Replies)
Discussion started by: ajay303
4 Replies
7. Shell Programming and Scripting
Hi all,
I have a flat file of 1000 rows. I want to check the length of the 5th column. The one having the longest length , I want to set it as DEFINED PARAMETER.
So later I can check others with that particular number only.
Any ideas ?? (2 Replies)
Discussion started by: ganesh123
2 Replies
8. UNIX for Dummies Questions & Answers
Hi all,
I tried to write a shell to read huge file and eliminate max length record which is wrong generated record. But I get an error
remove_sp.sh: line 27: syntax error near unexpected token `else'
remove_sp.sh: line 27: ` else $LINE >> REJFILE'
My shell is here:
#!/bin/sh... (5 Replies)
Discussion started by: mr_bold
5 Replies
9. Shell Programming and Scripting
i have a shell script which takes several args. what is the maximum length of string i can give as argument? (6 Replies)
Discussion started by: senthilk615
6 Replies
10. UNIX for Dummies Questions & Answers
Hi Guys,
Could anyone shed some light on the length of a Unix filepath max length pls ?
thanks !
Wilson (3 Replies)
Discussion started by: wilsontan
3 Replies
MSSQL_FIELD_LENGTH(3) MSSQL_FIELD_LENGTH(3)
mssql_field_length - Get the length of a field
SYNOPSIS
int mssql_field_length (resource $result, [int $offset = -1])
DESCRIPTION
Returns the length of field no. $offset in $result.
PARAMETERS
o $result
- The result resource that is being evaluated. This result comes from a call to mssql_query(3).
o $offset
- The field offset, starts at 0. If omitted, the current field is used.
RETURN VALUES
The length of the specified field index on success or FALSE on failure.
EXAMPLES
Example #1
mssql_field_length(3) example
<?php
// Connect to MSSQL and select the database
mssql_connect('MANGOSQLEXPRESS', 'sa', 'phpfi');
mssql_select_db('php');
// Send a select query to MSSQL
$query = mssql_query('SELECT [name], [age] FROM [php].[dbo].[persons]');
// Print the field length
echo 'The field 'age' has a data length of ' . mssql_field_length($query, 1);
// Free the query result
mssql_free_result($query);
?>
The above example will output something similar to:
The field 'age' has a data length of 4
NOTES
Note
Note to Windows Users
Due to a limitation in the underlying API used by PHP (MS DBLib C API), the length of VARCHAR fields is limited to 255. If you need
to store more data, use a TEXT field instead.
SEE ALSO
mssql_field_name(3), mssql_field_type(3).
PHP Documentation Group MSSQL_FIELD_LENGTH(3)