Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
SQL Query for condition stored as column in table
With above design, I am trying to avoid multiple where clause statement to be fired on table for fetching more than one condition match records. Also, conditon are unrestricted on field vales of table2, so I do not have control on it other than incorporating condition in table itself. Do you... -
SQL Query for condition stored as column in table
Hi, I need to form an SQL query to fetch the values from table A where conditions are satisfied. These conditions are stored in Table A itself in a column called "condition" Could some one please help to form the query on this? My table structure is as given Table1: documentList Field1: ID... -
Processing Big Text File with no Line break
Thanks Franco and Steve for prompt and useful reply! Steve is right, I do mean approximate chunks so that word will not break also file size is more than 1 GB so can not store whole thing together in a buffer. Let's have a real world example, I need to replace all "nuclear" with "atomic", here... -
Processing Big Text File with no Line break
Hi, I need to process 1 GB large text document which has no line break or separating character (i.e. all file content is in single line). I tried using perl read buffer command but it breaks the last word, which I do not want to break because I am doing some addition processing for word...
