Hi Guys,
I wanted to count the number of records for a particular field of a file. whose fields are separated by comma","
I fI use this command.
cat "filename" cut -sd "," -f13 | wc -l
This shows all the lines count including the blank values for the field number 13. I wanted to count... (2 Replies)
I'm not 100% sure if this was the right place to post in but here i go:
I'm attempting to migrate a physical windows disk onto my SAN through the use of the dd copy command. I'm booting into knoppix, running dd, and then bringing the server back up into windows running on the SAN. Everything... (2 Replies)
I have the test data with 10 column separated by comma and each column has more than 1000000 rows. Can anyone help me to find empty field in all columns and delete that empty field alone and lift that column up by one row.
Data with empty field:
A74203XYZ,A21718XYZ,A72011XYZ,A41095XYZ,... (7 Replies)
May data
Name = Andi
Address = none
Phone = 82728
Name = Peter
Address = none
Phone = 98799
The expected output
Name,Address,Phone
Andi,none,82728
Peter,none,98799
what i have done (6 Replies)
Hi all !
I'm sure it is a basic question but I didn't find any threads that fit my need.
How to remove empty fields with awk?
Or in other words, how to shift all the fields after an empty field on the left?
input:
1|2||3|4|5||6
wanted:
1|2|3|4|5|6
I tried:
awk '{for(i=1; i<=NF;... (7 Replies)
HI
Input A.txt
ABC907 ABC907_1B_9
ABC985 ABC985_1A_9
ABC985 ABC985_1B_9
ABC985 ABC985_1C_9
ABC05037 ABC05037_1A_9
ABC05037 ABC05037_1B_9
Base of column 2 last third char.
If It is A the 1,if B then 2 If C then 3
File B.txt
ABC907 ABC907_1B_9 2
ABC985 ABC985_1A_9 1
ABC985... (8 Replies)
Hi ! programmers
I have a need of detecting empty field in file
my file looks like this
40.900|-71.600|1.6|20|1|1961|21.00|3.700||1|US|28035|10029370|31
40.900|-71.600|5.7|20|1|1961|21.00|3.700||1|US|28035|10029370|31
40.900|-71.600|7.8|20|1|1961|21.00|3.700||1|US|28035|10029370|31... (7 Replies)
Hi All,
I am trying to write a shell script which takes parse the web form find the input field and dump the data of that field into one xml file. The form looks like,
<input type="button" id="btnSave" value="Save" onclick="saveXmlData()"/>
<form name="submitForm"... (1 Reply)
How to Copy non-empty files into subdirectory
I have directory A
there are bunch of files: a.txt a.txt.target b.txt b.target.txt.......
How can i find out the non-empty file within *.txt.target and copy them into a subdirectory B?
Thank you. (2 Replies)
Discussion started by: grace_shen
2 Replies
LEARN ABOUT PHP
get_magic_quotes_gpc
GET_MAGIC_QUOTES_GPC(3) 1 GET_MAGIC_QUOTES_GPC(3)get_magic_quotes_gpc - Gets the current configuration setting of magic_quotes_gpcSYNOPSIS
bool get_magic_quotes_gpc (void )
DESCRIPTION
Returns the current configuration setting of magic_quotes_gpc
Keep in mind that attempting to set magic_quotes_gpc at runtime will not work.
For more information about magic_quotes, see this security section.
RETURN VALUES
Returns 0 if magic_quotes_gpc is off, 1 otherwise. Or always returns FALSE as of PHP 5.4.0.
CHANGELOG
+--------+---------------------------------------------------+
|Version | |
| | |
| | Description |
| | |
+--------+---------------------------------------------------+
| 5.4.0 | |
| | |
| | Always returns FALSE because the magic quotes |
| | feature was removed from PHP. |
| | |
+--------+---------------------------------------------------+
EXAMPLES
Example #1
get_magic_quotes_gpc(3) example
<?php
// If magic quotes are enabled
echo $_POST['lastname']; // O'reilly
echo addslashes($_POST['lastname']); // O\'reilly
// Usage across all PHP versions
if (get_magic_quotes_gpc()) {
$lastname = stripslashes($_POST['lastname']);
}
else {
$lastname = $_POST['lastname'];
}
// If using MySQL
$lastname = mysql_real_escape_string($lastname);
echo $lastname; // O'reilly
$sql = "INSERT INTO lastnames (lastname) VALUES ('$lastname')";
?>
NOTES
Note
If the directive magic_quotes_sybase is ON it will completely override magic_quotes_gpc. So even when get_magic_quotes_gpc(3)
returns TRUE neither double quotes, backslashes or NUL's will be escaped. Only single quotes will be escaped. In this case they'll
look like: ''
SEE ALSO addslashes(3), stripslashes(3), get_magic_quotes_runtime(3), ini_get(3).
PHP Documentation Group GET_MAGIC_QUOTES_GPC(3)