I have a large text-file with tab-delimited genetic data that looks like:
KSC112 KSC234 0 0 1 1 A G C T
I simply wan to delete the first column, but since the file has 600 000 columns, it is not possible with awk (seems to be limited at 32k columns).
Does anyone have an idea how to do this? (2 Replies)
Hello,
I am trying to parse a file that resembles the last three groupings into something looking like the first two lines. I've fiddled with sed and awk a bit, but can't get anything to work properly. I need them separated by some delimiter. The file is some 23,000 lines of the stuff....
... (9 Replies)
I want to add a new column to a tab delimited text file. It will be the first column and it will just be 1's. How do I go about doing that? Thanks! (1 Reply)
hello all,
i have an input file like that
A A X0
A B X1
A C X2
...
A Z Xx
B A X1
B B X3
....
Z A Xx
Z B X4
and i want to have an output like that
A B C D
A X0 X1 X2 Xy
B X1 X3 X4 (4 Replies)
Hi,
I have created a tab separated file from the following input file.
ADDRESS1 CITY STATE POSTAL COUNTRY LON LAT
32 PRINZREGENTENSTRASSE ROSENHEIM BAYERN 83022 DEU 1212182 4785699
263 VIA DANTE ALIGHIERI BARI PUGLIA 70122 ITA 1686233 4112154
30 VIA MILANO ... (1 Reply)
Hi,
I have a tab separated. I want to replace all the "&" in 8th column of the file with "and" .I am trying with
awk -F, -vOFS=\\t '{$8=($8=="&")?"and":$8}1' test> test1.txt
My file is abc def ghk hjk lkm hgb jkluy acvf & bhj hihuhu fgg
me mine he her go went has has & had hgf hgy
... (1 Reply)
Hi all,
I'm trying to read a tab separated file and apply some functions on each column. I have an issue with empty column.
Exemple:
$ #cat with the sed to allow you to see my tab
$ cat foo.txt| sed 's/\t/;/g'
a;1;x
b;;yI wanted to something like that:
while read col1 col2 col3
do
... (4 Replies)
I'd like to take the output of `pwsafe --exportdb > database.txt` and convert it to a KeePassX XML friendly format (feature request in pwsafe).
I found flat file converter but the syntax is beyond me with this example. Solutions are welcomed.
More details
Here is the pwsafe --> KeePassX XML... (2 Replies)
Discussion started by: graysky
2 Replies
LEARN ABOUT PHP
cubrid_error_code_facility
CUBRID_ERROR_CODE_FACILITY(3) 1 CUBRID_ERROR_CODE_FACILITY(3)cubrid_error_code_facility - Get the facility code of errorSYNOPSIS
int cubrid_error_code_facility (void )
DESCRIPTION
The cubrid_error_code_facility(3) function is used to get the facility code (level in which the error occurred) from the error code of the
error that occurred during the API execution. Usually, you can get the error code when API returns false as its return value.
PARAMETERS
This function has no parameters.
RETURN VALUES
Facility code of the error code that occurred: CUBRID_FACILITY_DBMS, CUBRID_FACILITY_CAS, CUBRID_FACILITY_CCI, CUBRID_FACILITY_CLIENT
EXAMPLES
Example #1
cubrid_error_code_facility(3) example
<?php
$conn = cubrid_connect("localhost", 33000, "demodb");
$req = @cubrid_execute($conn, "SELECT * FROM unknown");
if (!$req) {
printf("Error facility: %d
Error code: %d
Error msg: %s
",
cubrid_error_code_facility(), cubrid_error_code(), cubrid_error_msg());
cubrid_disconnect($conn);
exit;
}
?>
The above example will output:
Error facility: 1
Error code: -493
Error msg: Syntax: In line 1, column 15 before END OF STATEMENT
Syntax error: unexpected 'unknown'
SEE ALSO cubrid_error_code(3), cubrid_error_msg(3).
PHP Documentation Group CUBRID_ERROR_CODE_FACILITY(3)