02-17-2009
what "last" part? inserting into a database? need to know what database...
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hey Guys,
I have a very urgent requirement regaridng the searching for value on the text file.
The text file is in the below format
Number Description
"112323", mysampletest1
"12122412", mysampletest2
"11232143", mysampletest3
I need to get the first column like
112323... (2 Replies)
Discussion started by: rahman_riyaz
2 Replies
2. UNIX for Dummies Questions & Answers
Say I had a text file that contained four columns, like the following:
Mack Christopher:237 Avondale Blvd:970-791-6419:S
Ben Macdonor:30 Dragon Rd:647-288-6395:B
I'm making a loop that will replace the fourth column a line in the file with the contents of a variable 'access', but I have no... (6 Replies)
Discussion started by: Sotau
6 Replies
3. Shell Programming and Scripting
Hi,
I need to find out the last column value from a text file which is delimited by a tab.
The issue here is the last column# for each record can be different i.,e, 1st record can have the last column as 15 and the second record can have the last column as "17".
I have to search a string... (3 Replies)
Discussion started by: naveen_sangam
3 Replies
4. UNIX for Dummies Questions & Answers
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)
Discussion started by: evelibertine
1 Replies
5. UNIX for Dummies Questions & Answers
I have a text file in the following format:
13412 NA06985 0 0 2 46.6432798439 4 4 4 4
13412 NA06991 NA06993 NA06985 2 48.8478948517 4 4 2 4
13412 NA06993 0 0 1 45.8022601455 4 4 2 4
13401 NA06994 0 0 1 48.780669145 4 4 4 4
13401 NA07000 0 0 2 47.7312017846 2 4 4 4
13402 NA07019... (3 Replies)
Discussion started by: evelibertine
3 Replies
6. UNIX for Dummies Questions & Answers
Hi,
I have a text file in the following format:
Code:
13412 NA06985 0 0 2 46.6432798439 4 4 4 4
13412 NA06991 NA06993 NA06985 2 48.8478948517 4 4 2 4
13412 NA06993 0 0 1 45.8022601455 4 4 2 4
13401 NA06994 0 0 1 48.780669145 4 4 4 4
13401 NA07000 0 0 2 47.7312017846 2 4 4 4 ... (2 Replies)
Discussion started by: evelibertine
2 Replies
7. UNIX for Dummies Questions & Answers
I would like to extract the last column of a text file but different rows of the text file have different numbers of columns. How do I go about doing that? Thanks! (1 Reply)
Discussion started by: evelibertine
1 Replies
8. Shell Programming and Scripting
Hi,
I am converting a .DBF file to pipe delimited file
my requirement is like
lets say my .DBF is residing in path /a/b/c/d/f/abc.DBF
I need my .txt file as
having a column with source _cd =f
sample data in .DBF in folder "f"
c1 c2 c3
1 2 3
in txt file it should be... (4 Replies)
Discussion started by: angel12345
4 Replies
9. UNIX for Dummies Questions & Answers
Hi,
I have a text file with many column (1,000,000+). I want to add a column of 0's as the third column. I tried:
awk '{$3=0}1' input file > output file
But it simply replaces the third column with 0's instead of adding a new column. How do I go about doing this? Thanks! (2 Replies)
Discussion started by: evelibertine
2 Replies
10. Shell Programming and Scripting
Hi,
I need to compare 2 text files with around 60000 rows and 1 column. I need to compare these and write the mismatch data to 3rd file.
File1 - file2 = file3
wc -l file1.txt
58112
wc -l file2.txt
55260
head -5 file1.txt
101214200123
101214700300
101250030067
101214100500... (10 Replies)
Discussion started by: Divya Nochiyil
10 Replies
LEARN ABOUT PHP
fbsql_select_db
FBSQL_SELECT_DB(3) 1 FBSQL_SELECT_DB(3)
fbsql_select_db - Select a FrontBase database
SYNOPSIS
bool fbsql_select_db ([string $database_name], [resource $link_identifier])
DESCRIPTION
Sets the current active database on the given link identifier.
The client contacts FBExec to obtain the port number to use for the connection to the database. If the database name is a number the sys-
tem will use that as a port number and it will not ask FBExec for the port number. The FrontBase server can be stared as FRontBase
-FBExec=No -port=<port number> <database name>.
Every subsequent call to fbsql_query(3) will be made on the active database.
PARAMETERS
o $database_name
- The name of the database to be selected. If the database is protected with a database password, the you must call fbsql_data-
base_password(3) before selecting the database.
o $
link_identifier -A FrontBase link identifier returned by fbsql_connect(3) or fbsql_pconnect(3).If optional and not specified, the
function will try to find an open link to the FrontBase server and if no such link is found it will try to create one as if
fbsql_connect(3) was called with no arguments.
RETURN VALUES
Returns TRUE on success or FALSE on failure.
SEE ALSO
fbsql_connect(3), fbsql_pconnect(3), fbsql_database_password(3), fbsql_query(3).
PHP Documentation Group FBSQL_SELECT_DB(3)