awk+cat Post: 302566906

9 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Difference between cat , cat > , cat >> and touch !!!

Hi Can anybody tell the difference between Difference between cat , cat > , cat >> and touch command in UNIX? Thanks

2. Shell Programming and Scripting

cat & awk

Hi there, Can show some hit why i got this error? For eg i have a.txt in which consist of contents as below 1|781494-0015|IV\|I||C|RECHARGE|Success\|V\|\||2007-12-04 02:33:13.000| 2|762405-0405|IV\|I||C|RECHARGE|Success\|V\|\||2007-12-04 02:33:17.000| In fact , i want to perfrom to have...

3. Shell Programming and Scripting

cat in the command line doesn't match cat in the script

Hello, So I sorted my file as I was supposed to: sort -n -r -k 2 -k 1 file1 | uniq > file2 and when I wrote > cat file2 in the command line, I got what I was expecting, but in the script itself ... sort -n -r -k 2 -k 1 averages | uniq > temp cat file2 It wrote a whole...

4. UNIX for Dummies Questions & Answers

tr, sed, awk, cat or scripting

I need to change all Newline caracters (\12) to Fieldseparator(\34). tr -A '\12' '\34' <file1> file2 Replace all delete (\177) with Newline (\12) tr -A '\177' '\12' <file2> file3 Put the name of the file first in all rows. awk '{printf "%s\34%s\n", FILENAME,$0} file3 > file4 So far no...

5. Shell Programming and Scripting

Understanding Awk and Cat

Hi Guys, I was recently come across some code to hopefully learn a little bit about putting Shell commands into PHP application to run on a Linux server. However, I don't understand the command AT ALL... and was wondering if anyone can interpret it: cat userIDs.dat | awk '{s=s+1; if...

6. Shell Programming and Scripting

Using cat and awk.......

Im trying to use cat and awk to calculate the total space, then display it using the print command. But something in my script is not correct? cat | awk '{print$1}' | sort -n | grep -v used | awk '{sum += $1} END { p rint sum;}' ??? Any help would be greatly appreciated!!

7. UNIX for Dummies Questions & Answers

How to pass cat file in awk statement?

Hi, I am working on kernel parameters, want to check values under /proc/sys/kernel below I tried for kernel.sem SEMMNS: 4096 cat /proc/sys/kernel/sem | awk '{print $2}' awk '{ if ($2 < 33000) print }' /proc/sys/kernel/sem |awk '{print $2}' 32000 The above...

8. Shell Programming and Scripting

Spacing off when files combined using awk or cat

I have 133 .txt files in a directory that I am combining into 1 file. The problem is when I use awk or cat to combine the files I get out put like this: output 85 138662360 KCNT1 86 138662962 KCNT1 82 138657053 KCNT1 83 138657635 KCNT1 95 138646881 KCNT1...

9. Shell Programming and Scripting

Need to add prefix using sed or awk from cat the file

I need the use sed or AWK using cat the file Node1 TDEV RW 1035788 TDEV RW 1035788 Server1 TDEV RW 69053 Server2 TDEV RW 69053 TDEV RW 103579 Server3 TDEV RW 69053 server4 RDF1+TDEV RW 69053 RDF1+TDEV RW 517894 RDF1+TDEV RW 621473 server6 TDEV RW 34526 TDEV RW 34526

LEARN ABOUT PHP

sqlite_escape_string

SQLITE_ESCAPE_STRING(3) 												   SQLITE_ESCAPE_STRING(3)

sqlite_escape_string - Escapes a string for use as a query parameter

SYNOPSIS

       string sqlite_escape_string (string  $item)

DESCRIPTION

       sqlite_escape_string(3)	will  correctly  quote the string specified by $item for use in an SQLite SQL statement. This includes doubling up
       single-quote characters ( ') and checking for binary-unsafe characters in the query string.

	Although the encoding makes it safe to insert the data, it will render simple text comparisons and LIKE clauses in your  queries  unusable
       for  the  columns  that contain the binary data. In practice, this shouldn't be a problem, as your schema should be such that you don't use
       such things on binary columns (in fact, it might be better to store binary data using other means, such as in files).

PARAMETERS

	      o $item
		- The string being quoted.  If the $item contains a NUL character, or if it begins with a character whose ordinal value  is  0x01,
		PHP will apply a binary encoding scheme so that you can safely store and retrieve binary data.

RETURN VALUES

	Returns an escaped string for use in an SQLite SQL statement.

NOTES

       Note

	       Do  not	use  this  function to encode the return values from UDF's created using sqlite_create_function(3) or sqlite_create_aggre-
	      gate(3) - use sqlite_udf_encode_binary(3) instead.

       Warning

	      addslashes(3) should NOT be used to quote your strings for SQLite queries; it will lead to  strange  results  when  retrieving  your
	      data.

SEE ALSO

       sqlite_udf_encode_binary(3).

PHP Documentation Group 												   SQLITE_ESCAPE_STRING(3)