hii..
I have a pipe delimited file
For ex:
TEST_1-8J6TZN|ASLANK|BHR-09||TRAM
I want to grep for NULL in the 4th field only from the above file
Please suggest
Also let me know if there is any limitation in the suggested command
Thanks all in advance..!! (5 Replies)
the file has several date fields.for example, #2, #3,and #5 are date fields.
I want grep year '2002' just within #2 field and get all the rows which content year '2002' in the #2 field. is it possible to do this? how to do it? Thanks (2 Replies)
:confused: I have a tab delimited file that I need to extract data from and into a file with specific field specs. Each field has to be a certain amount of characters. So, the name field (from delimited file) might have only 15 characters but needs to be 25 (in new file) so I need to insert spaces... (5 Replies)
Hi,
I know there are lots of threads on replacing text within files, usually using sed or awk. However, I find it hard to adapt examples that I found to my specific case. I am kind of new to UNIX and have hard times learning the syntax either for sed or awk so I would appreciate any help. Here's... (5 Replies)
Hi,
I have an issue to combine multiple lines of a file. I have records as below.
Fields are delimited by TAB. Each lines are ending with a new line char (\n)
Input
--------
ABC 123456 abcde 987
890456 7890 xyz
ght gtuv
ABC 5tyin 1234 789
ghty kuio
ABC ghty jind 1234
678 ght
... (8 Replies)
I have a text file like this:
subject1:LecturerA:10
subject2:LecturerA:40
if I was given string in column 1 and 2 (which are subject 1 and LecturerA) , i need to update 3rd field of that line containing that given string , which is, number 10 need to be updated to 100 ,for example.
The... (6 Replies)
Hi All,
I'm having a hard time finding a starting point for my issue. I have a 30k line file (fspsec.txt) that I would like to parse into smaller files based on any character existing in field 1.
ACCOUNTANT LEVEL 1 (ACCT.ACCOUNTANT)
OPERATORS: DOEJO (418)
TOOLS: Branch Maintenance
... (2 Replies)
I am trying to remove lines in the target.txt file if $5 before the - in that file matches sorted_list. I have tried grep and awk. Thank you :).
grep
grep -v -F -f targets.bed sort_list
grep -vFf sort_list targets
awk
awk -F, '
> FILENAME == ARGV {to_remove=1; next}
> ! ($5 in... (2 Replies)
I am trying to add a tab after the last digit in $3 in the input. The grep below is all I can think off. Thank you :)
sed -n 's/:/&/p' input
input
chr1 955542 955763AGRN-6|gc=75
chr1 957570 957852AGRN-7|gc=61.2
chr1 976034 976270AGRN-9|gc=74.5
desired output
chr1... (5 Replies)
Discussion started by: cmccabe
5 Replies
LEARN ABOUT PHP
cubrid_result
CUBRID_RESULT(3) 1 CUBRID_RESULT(3)cubrid_result - Return the value of a specific field in a specific rowSYNOPSIS
string cubrid_result (resource $result, int $row, [mixed $field])
DESCRIPTION
This function returns the value of a specific field in a specific row from a result set.
PARAMETERS
o $result
-$result comes from a call to cubrid_execute(3)
o $row
-The row number from the result that is being retrieved. Row numbers start at 0.
o $field
- The name or offset of the $field being retrieved. It can be the field's offset, the field's name, or the field's table dot field
name (tablename.fieldname). If the column name has been aliased ('select foo as bar from...'), use the alias instead of the column
name. If undefined, the first field is retrieved.
RETURN VALUES
Value of a specific field, on success (NULL if value if null).
FALSE on failure.
EXAMPLES
Example #1
cubrid_result(3) example
<?php
$conn = cubrid_connect("localhost", 33000, "demodb");
$req = cubrid_execute($conn, "SELECT * FROM code");
$result = cubrid_result($req, 0);
var_dump($result);
$result = cubrid_result($req, 0, 1);
var_dump($result);
$result = cubrid_result($req, 5, "f_name");
var_dump($result);
cubrid_close_request($req);
cubrid_disconnect($conn);
?>
The above example will output:
string(1) "X"
string(5) "Mixed"
string(4) "Gold"
PHP Documentation Group CUBRID_RESULT(3)