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 Rhinorhino 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: *

  • Users: Awat
  • Content: Threads
  • Order by date
  1. Awat

    Split String without a Delimiter

    Hi, How can I split a string that doesn't contain a delimiter? I need to extract 3 character codes that are strung together in 1 field without a delimiter. For example, I have a string that looks like this: 212356244120000000000000000 (40 char) I need to split them into 212 356 244 120 and be...
  2. Awat

    Comparing Data from Multiple SQL Expressions

    Hi, I have 10 sql expressions that return 10 different numbers: 139, 141, 143, 145,...,157. Each number associates with data from a field in a table. In CR report, each record could have more than one number...
  3. Awat

    Compare Address with Different Street Abbreviations

    Hi, I compare addresses using StrCmp(str1, str2, 1). I am able to omit the case-sensitivity but am having a trouble with street abbreviations such as Ave, Ave., Avenue. How can I omit the differences so the formula would return 0 (equal)? Thanks.
  4. Awat

    Export horizontally displayed records into excel

    Hi, I have the records displayed horizontally in one line using a variable: stringvar courses := courses + {course}+ " ";. So, instead of ID[tab][tab]Course 001[tab][tab]A 001[tab][tab]B 001[tab][tab]C This is what I have now: ID Course 001[tab][tab]A[tab]B[tab]C However, the...
  5. Awat

    Create a calendar of course meeting weekly and biweekly

    I have a course meeting table that shows only the starting and ending dates of the classes and meeting days of week (meet once, weekly or biweekly on M W T...) The days of week data is quite tricky. The days are determined by the position of the meeting code. Below is how the data look like...

Part and Inventory Search

Back
Top