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!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Cornelius19

    How to find numbers containing only digits?

    Thanks, that is perfect. Cornelius
  2. Cornelius19

    How to find numbers containing only digits?

    Actually, I meant how to find *numbers* i.e. *records containing only digits*. Sorry for the confusion.
  3. Cornelius19

    How to find numbers containing only digits?

    Hello, I would like to find all the records that contain only digits. So far, I have this: SELECT * FROM tmp1 WHERE (word LIKE N'[0-9]') It returns only ten results, each containing a single digit. What I need is to find all the records containing only digits, like '378'...
  4. Cornelius19

    from tawk to gawk - multidimensional arrays

    Thanks a lot Feherke. I will try to explore the perl option. Cornelius
  5. Cornelius19

    from tawk to gawk - multidimensional arrays

    Thanks for the post. I understood that this is only a simulated multi-dimensional array and in reality it is a single dimensional array with indexes concatenated into a single one. However, in this case, I might not need multi-dimensional arrays, just brake the single index into substrings...
  6. Cornelius19

    from tawk to gawk - multidimensional arrays

    Hi, I use gawk but need to run an old awk script, written for the tawk compiler (http://www.tasoft.com/). The syntax is slightly different, for instance, they declare multi-dimensional arrays like this: ary[word][dialect][24] = "A"; This does not compile under gawk, but I can easily convert...
  7. Cornelius19

    How to change the default value to case sensitive?

    Thanks for the link. I understand from that post that there are three levels of collation and it is possible to change the collation at any of these levels: - server collation - database collation - column collation I even found how to make the collation case sensitive at the column level: you...
  8. Cornelius19

    How to change the default value to case sensitive?

    Hi, Our Microsoft SQL Server was installed as case insensitive by default. How to change the default value to case sensitive (without re-installing it again)? I hope we just need to change a simple setting somewhere… Cornelius
  9. Cornelius19

    Finding identical records with empty fields

    Thanks a lot PHV, this is exactly what I need. Cornelius
  10. Cornelius19

    Finding identical records with empty fields

    Hi, I would expect the following query to show identical records from t1 and t2: SELECT t1.f1, t1.f2 FROM t1 INNER JOIN t2 ON (t1.f2 = t2.f2) AND (t1.f1 = t2.f1); It works fine when none of the fields is empty. However, if both tables contain the same value in f1 but f2 is empty, the query...
  11. Cornelius19

    Location of the Import Specification

    Thanks a lot! Cornelius
  12. Cornelius19

    Location of the Import Specification

    When you click on File/Get External Data/Import and you choose a text file, the Import Text Wizard appears. You click on Advanced and can set up an Import Specification and save it. I guess this is saved into a text file. Where is that text file? I would like to document the process this...
  13. Cornelius19

    six "syntax error" messages

    Thanks a lot – it is really great to be able to get help from knowledgeable people like you! I applied PHV’s modification and feherke’s function (and a couple of other easy changes). Now I can run the script, get an output file and the result looks good. Cornelius P.-S. I consider posting the...
  14. Cornelius19

    six "syntax error" messages

    Thanks a lot again. All the syntax error messages disappeared but a new one appeared instead: awk: iprjen.awk:117: (FILENAME=iprjen.uni FNR=1) fatal: attempt to use scalar `a PrintArray' as array Here are lines 112-117: # if we have a print array, process it first if (...
  15. Cornelius19

    six "syntax error" messages

    Thanks a lot for the suggestion: I used coma and single pair of brackets instead of the double pair of brackets and the two error messages disappeared. I still get some errors however, here are the next two (the fifth and sixths are the same as the third): awk: iprjen.awk:306...
  16. Cornelius19

    six "syntax error" messages

    Hi, I need to run an awk script written by someone else seven years ago and probably working fine in that configuration. Now I receive six "syntax error" messages (no other errors), the first two are: awk: iprjen.awk:72: aFtagHierarchy[$1][ awk: iprjen.awk:72...
  17. Cornelius19

    character count per column

    Thanks, the case sensitive search works now fine. Cornelius
  18. Cornelius19

    Case Sensitive search

    Thanks, I replaced = with LIKE and it works fine! Cornelius
  19. Cornelius19

    character count per column

    Hi, Thanks a lot, it resolved half of my problem: for any specific character, I can get the total number of occurrences by creating a count table with the above query and adding a Sum(count.NumberOfA) etc. query. It even works for non-ASCII characters. However, I still have two issues: 1) I...
  20. Cornelius19

    Case Sensitive search

    Hi, How can George’s code be combined with wildcards? I tried the following but it did not return any result: Select * From @Temp Where Data Collate SQL_Latin1_General_CP1_CS_AS = 'Blu%' Any idea? Cornelius

Part and Inventory Search

Back
Top