Hi
I have a script that loops though lines of a file and reads each line in to a variable ($LINE).
I want to look at the line and split it into it's constituent parts.
e.g. a line might be "This is a string"
I want to then have variables set to each element thus:
A=This
B=is
C=a... (3 Replies)
could anyone help in running split cmd
split("String1,outputArray,"delimiter);
with sample script?.
for eg i have abc-def-ghi-sdf-
my ultimate aim of asking this is i have a string containing hypens,
i want to get the string before last n(2) Hypens (4 Replies)
Hi,
I am new to scripting and need help splitting a string using space as the delimiter.
How can I do that?
I want the result to be stored in an Array.
I tried using
set -A arr $(echo $FILE)
echo $arr
The result of the above was ''.
Thanks. (2 Replies)
Hi,
can we split a number like this.. if i have something like 85743975945738, can it be converted as 8574-3975-945738 in ksh shell using single command...
Thanks! (5 Replies)
Hi
I am facing a problem in spitting a string.
Here is the string
--------------------
subject1=10;subject2=30;subject3=40;subjectcode=10001;...
Now, I want only marks not the subject code. (there can be 'n' subjects)
ie.
10
30
40
My doubt
----------
How do I... (5 Replies)
I am trying to get some data from a file and print it on the same line.
I have a script that gets the body of emails and display it, but i want it to display each emails body in one line no matter how big it is. eg
insted of this
email1: bla bla bla
bla bla bla
bal
email2: bla bla bla... (7 Replies)
Hi,
We have a SunOS 5.10 Generic_142900-13 sun4v sparc SUNW,T5240.
I'm trying to find a way to split a string into 2 variables.
Ex:
parm1="192.168.1.101/parent/child"
What I need to do is split the string above into:
host="192.168.1.101"
location="parent/child"
I saw the... (3 Replies)
Hi All,
How to split the string KAR_Celltick_Ban_GSMGW3 and want to pickup the third filed. Sometime the string may be "KAR_Celltick_Ban" like this
Thanks in advance (1 Reply)
value=malayalam
# i need to store the value in an array by splitting the character
#the output i need is
m
a
l
a
y
a
l
a
m
Please use CODE tags for output data as well as required by forum rules! (5 Replies)
Discussion started by: Meeran Rizvi
5 Replies
LEARN ABOUT PHP
mssql_num_fields
MSSQL_NUM_FIELDS(3)MSSQL_NUM_FIELDS(3)mssql_num_fields - Gets the number of fields in resultSYNOPSIS
int mssql_num_fields (resource $result)
DESCRIPTION mssql_num_fields(3) returns the number of fields in a result set.
PARAMETERS
o $result
- The result resource that is being evaluated. This result comes from a call to mssql_query(3).
RETURN VALUES
Returns the number of fields, as an integer.
EXAMPLES
Example #1
mssql_num_fields(3) example
<?php
// Connect to MSSQL and select the database
$link = mssql_connect('KALLESPCSQLEXPRESS', 'sa', 'phpfi');
mssql_select_db('php', $link);
// Select some data from our database
$data = mssql_query('SELECT [name], [age] FROM [php].[dbo].[persons]');
// Construct a table
echo '<table border="1">';
$header = false;
// Iterate through returned results
while ($row = mssql_fetch_array($data)) {
// Build the table header
if (!$header) {
echo '<thead>';
echo '<tr>';
for ($i = 1; ($i + 1) <= mssql_num_fields($data); ++$i) {
echo '<td>' . ucfirst($row[$i]) . '</td>';
}
echo '</tr>';
echo '</thead>';
echo '<tbody>';
$header = true;
}
// Build the row
echo '<tr>';
foreach($row as $value) {
echo '<td>' . $value . '</td>';
}
echo '</tr>';
}
// Close table
echo '</tbody>';
echo '</table>';
// Clean up
mssql_free_result($data);
mssql_close($link);
?>
SEE ALSO mssql_query(3), mssql_fetch_field(3), mssql_num_rows(3).
PHP Documentation Group MSSQL_NUM_FIELDS(3)