How would one go about deleting the first two characters on each line of a file on Unix? I thought about using awk, but cannot seem to find if it can explicitly do this. In this case there might or might not be a field separator. Meaning that the data might look like this.
01999999999... (5 Replies)
I have a file that looks like this:
It is a huge file and basically I want to delete everything at the > line except for the number after “C”.
>c1154... (2 Replies)
Hi,
I have a log file whose size is number of characters in the file with multiple lines.
Example:
SQL*Loader: Release 10.2.0.4.0 - Production on Sat Sep 12 07:55:29 2009
Copyright (c) 1982, 2007, Oracle. All rights reserved.
Control File: ../adm/ctl/institution.ctl
Character Set... (4 Replies)
Hi,
I want to delete rows whenever column one has the letters 'rpa'. The file is tab seperated.
e.g.
years 1
bears 1
cats 2
rpat 3
rpa99 4
rpa011 5
then removing 'rpa' containing rows based on the first column
years 1
bears 1
cats 2
thanks (7 Replies)
Hi All,
I have a text file with the following text in it:
file:///About/accessibility.html
file:///About/disclaimer.html
file:///About/disclaimer.html#disclaimer
file:///pubmed?term=%22Dacre%20I%22%5BAuthor%5D
file:///pubmed?term=%22Madigan%20J%22%5BAuthor%5D... (8 Replies)
sed -e "s// /g" old.txt > new.txt
While I do know some control characters need to be escaped, can normal characters also be escaped and still work the same way? Basically I do not know all control characters that have a special meaning, for example, ?, ., % have a meaning and have to be escaped... (11 Replies)
I am trying to find a specific set of characters in a long file. I only want to find the characters in column 265 for 4 bytes.
Is there a search for that? I tried cut but couldn't get it to work.
Ex. I want to find '9999' in column 265 for 4 bytes. If it is in there, I want it to print... (12 Replies)
Hi all, I need help.
I have an input text file (input.txt) like this:
21 GTGCAACACCGTCTTGAGAGG 50
21 GACCGAGACAGAATGAAAATC 73
21 CGGGTCTGTAGTAGCAAACGC 108
21 CGAAAAATGAACCCCTTTATC 220
21 CGTGATCCTGTTGAAGGGTCG 259
Now I need to count A/T/G/C numbers at each character location in column... (2 Replies)
What's one single UNIX pipeline that would delete all of the vowels from one file (global)?
I know I would need to use the sed command. But I'm stuck after that. i know how to replace characters with other characters I just don't know how to fully get rid of it. (4 Replies)
Discussion started by: sarahahah
4 Replies
LEARN ABOUT PHP
sqlite_column
SQLITE_COLUMN(3)SQLITE_COLUMN(3)sqlite_column - Fetches a column from the current row of a result setSYNOPSIS
mixed sqlite_column (resource $result, mixed $index_or_name, [bool $decode_binary = true])
DESCRIPTION
mixed SQLiteResult::column (mixed $index_or_name, [bool $decode_binary = true])
mixed SQLiteUnbuffered::column (mixed $index_or_name, [bool $decode_binary = true])
Fetches the value of a column named $index_or_name (if it is a string), or of the ordinal column numbered $index_or_name (if it is an
integer) from the current row of the query result handle $result.
PARAMETERS
o $result
- The SQLite result resource. This parameter is not required when using the object-oriented method.
o $index_or_name
- The column index or name to fetch.
o $decode_binary
-When the $decode_binary parameter is set to TRUE (the default), PHP will decode the binary encoding it applied to the data if it
was encoded using the sqlite_escape_string(3). You should normally leave this value at its default, unless you are interoperating
with databases created by other sqlite capable applications.
RETURN VALUES
Returns the column value.
NOTES
Note
Use this function when you are iterating a large result set with many columns, or with columns that contain large amounts of data.
SEE ALSO sqlite_fetch_string(3).
PHP Documentation Group SQLITE_COLUMN(3)