Remove some special ascii character

9 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

Remove a word that ends with special character "!"

Hi all. I want to use sed to remove a word that ends with "!" in the first page of a file. The word I want to remove is: "DNA!". I have search for an answer and nothing of what I found helped me. ~faizlo

2. Shell Programming and Scripting

Remove word after special character "/"

Hi There, I have one requirement to remove word after character "/". Input file is 2017-07-12|02|user1l|domain1/userl|0 2017-07-12|02|user2|domain1/user2|5 2017-07-12|02|user3|domain2/user3|0 2017-07-12|02|user4|domain1/user4|432 and require OP file is ...

3. Shell Programming and Scripting

Remove blank space and insert special character

Hi Folks, I have a huge data of the below format abc #apple 1200 06/23 ghj #orange 1500 06/27 uyt #banana 2300 05/13 efg #vegetable 0700 04/16 After first 3 letters, i have 9 spaces and after fruit there are no specific fixed space, but it varies...

4. UNIX for Dummies Questions & Answers

What is ASCII character?

Hi Guru, I have put one post yesterday and get answer. thanks for your help. my question today is: what is ascii character for following non printable characters: ( we need filter these characters out in another process) ^MM-^E^MM-^E. Old post link: ...

5. Shell Programming and Scripting

Remove special character ($) from file names

Hello I've searched here and on the 'net for examples of a script or command line function that will remove the $ character from all file names only that can be done within the directory that contains the file names - which are all html files. ie, I have a directory that contains html files...

6. Shell Programming and Scripting

remove special character from a specific column

Hello , i have a text file like this : A123 c12AB c32DD aaaa B123 23DS 12QW bbbb C123 2GR 3RG cccccc i want to remove the numbers from second and third column only. i tried this : perl -pe 's///g' file.txt > newfile.txt but it will remove the number from...

7. Shell Programming and Scripting

remove special character from a textfile

Can any one plse help me writing shell script to removing some special character pattern (like / > -------, / > / > ------- etc....as shown below) from the text file ASAP. / > ------- <tag-normalization tag-name="EXECSERVPRODUCT" read-only="false" part="body"> ...

8. Shell Programming and Scripting

read in a file character by character - replace any unknown ASCII characters with spa

Can someone help me to write a script / command to read in a file, character by character, replace any unknown ASCII characters with space. then write out the file to a new filename/ Thanks!

9. Shell Programming and Scripting

Remove box like special character from end of string

Hi All, How to remove a box like special character which appears at the end of a string/line/record. I have no clue what this box like special character is. It is transparent square like box. This appears in a .DAT file at the end of header. I'm to compare a value in header with a parameter....

LEARN ABOUT PHP

sqlsrv_num_rows

SQLSRV_NUM_ROWS(3)														SQLSRV_NUM_ROWS(3)

sqlsrv_num_rows - Retrieves the number of rows in a result set

SYNOPSIS

       mixed sqlsrv_num_rows (resource	$stmt)

DESCRIPTION

	Retrieves the number of rows in a result set. This function requires that the statment resource be created with a static or keyset cursor.
       For more information, see sqlsrv_query(3), sqlsrv_prepare(3), or Specifying a Cursor Type and Selecting Rows in the Microsoft SQLSRV  docu-
       mentation.

PARAMETERS

	      o $stmt
		-  The	statement  for	which the row count is returned. The statment resource must be created with a static or keyset cursor. For
		more information, see sqlsrv_query(3), sqlsrv_prepare(3), or Specifying a Cursor Type and Selecting Rows in the  Microsoft  SQLSRV
		documentation.

RETURN VALUES

	Returns  the  number  of  rows retrieved on success and FALSE if an error occurred. If a forward cursor (the default) or dynamic cursor is
       used, FALSE is returned.

EXAMPLES

       Example #1

	      sqlsrv_num_rows(3) example

	      <?php
	      $server = "serverNamesqlexpress";
	      $connectionInfo = array( "Database"=>"dbName", "UID"=>"username", "PWD"=>"password" );
	      $conn = sqlsrv_connect( $server, $connectionInfo );

	      $sql = "SELECT * FROM Table_1";
	      $params = array();
	      $options =  array( "Scrollable" => SQLSRV_CURSOR_KEYSET );
	      $stmt = sqlsrv_query( $conn, $sql , $params, $options );

	      $row_count = sqlsrv_num_rows( $stmt );

	      if ($row_count === false)
		 echo "Error in retrieveing row count.";
	      else
		 echo $row_count;
	      ?>

SEE ALSO

       sqlsrv_has_rows(3), sqlsrv_rows_affected(3).

PHP Documentation Group 													SQLSRV_NUM_ROWS(3)

Shell Programming and Scripting