The first if statement checks if all 3 columns from a row contain uppercase A-Z only.
The second statement checks if the first two columns from a row contain uppercase A-Z only AND if the third column contains a dot.
Greetings & Happy New Years To All!
A client of mine FTP'ed their files up to the server and it all ended up being in UPPERCASE when it all should be in lowercase. Is there a builtin command or a script anyone knows of that will automagically convert all files to lowercase?
Please advise asap... (4 Replies)
Hi,
I need a shell script which changes a bunch of files in a particular directory from lowercase to UPPERCASE.
I am not very familiar with shell scripts so a detailed explanation would be greatly appreciated!!!!
Thanks ini advance!
:) (7 Replies)
Hey, I've just started learning shell script today.
How would I write a bash script file that changes file names from uppercase to lowercase in that directory, the program should warn the user and NOT overwrite the existing file if it's already in lowercase?
for example in a directory i... (1 Reply)
Inside a script I have 2 variables COMP=cy and PT=t. further down the same script I require at the same line to call those 2 variables the first time uppercase and after lowercase ${COMP}${PT}ACE,${COMP}${PT}ace. Can somebody help me
Thanks in advance
George Govotsis (7 Replies)
hi,
i need to write a bash script that does two things.
the program will take from the command line a file name, which is a C code, and an integer, which is the size of my indentation
i would then have to indent every nested code by the number of columns provided by the user in the... (1 Reply)
I just started to learn unix...
and i needed to make a basic script.
i need to
1. read a file (.txt)
2. count the words of EVERY sentece
3. sentences with odd number of words need to be converted into lowercase
sentences with even number of words need to be converted into uppercase
... (6 Replies)
listprocs.sh contains ps -ef | grep "swikar"
1) Write a shell script to convert an input file to all upper case. Name your shell script toupper.sh.
Hint: tr ' ' ' ' will convert all lower case letters to upper case
To use your script, try the following command:
cat... (1 Reply)
Hello,
I have a list of files in a directory whose names are all in uppercasse, including the file format for eg *.MP3 . I would like to convert these to the normal way we write it ie ABC.MP3 to be converted to Abc.mp3 . I know that this can be done manually by using a lot of "mv" or rename... (6 Replies)
Discussion started by: ajayram
6 Replies
LEARN ABOUT PHP
pdostatement.fetchcolumn
PDOSTATEMENT.FETCHCOLUMN(3) 1 PDOSTATEMENT.FETCHCOLUMN(3)PDOStatement::fetchColumn - Returns a single column from the next row of a result set
SYNOPSIS
public mixed PDOStatement::fetchColumn ([int $column_number])
DESCRIPTION
Returns a single column from the next row of a result set or FALSE if there are no more rows.
Note
PDOStatement.fetchColumn(3) should not be used to retrieve boolean columns, as it is impossible to distinguish a value of FALSE from
there being no more rows to retrieve. Use PDOStatement.fetch(3) instead.
PARAMETERS
o $column_number
- 0-indexed number of the column you wish to retrieve from the row. If no value is supplied, PDOStatement.fetchColumn(3) fetches
the first column.
RETURN VALUES PDOStatement.fetchColumn(3) returns a single column in the next row of a result set.
Warning
There is no way to return another column from the same row if you use PDOStatement.fetchColumn(3) to retrieve data.
EXAMPLES
Example #1
Return first column of the next row
<?php
$sth = $dbh->prepare("SELECT name, colour FROM fruit");
$sth->execute();
print("Fetch the first column from the first row in the result set:
");
$result = $sth->fetchColumn();
print("name = $result
");
print("Fetch the second column from the second row in the result set:
");
$result = $sth->fetchColumn(1);
print("colour = $result
");
?>
The above example will output:
Fetch the first column from the first row in the result set:
name = lemon
Fetch the second column from the second row in the result set:
colour = red
SEE ALSO PDO.query(3), PDOStatement.fetch(3), PDOStatement.fetchAll(3), PDO.prepare(3), PDOStatement.setFetchMode(3).
PHP Documentation Group PDOSTATEMENT.FETCHCOLUMN(3)