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 TouchToneTommy 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: DarthGAD
  • Content: Threads
  • Order by date
  1. DarthGAD

    How do I parse text between two "tabs" in a memo field

    QUESTION: How do I parese a list of names stored in a memo field so I can put them on separate rows of data. BACKGROUND: I have a memo field that includes, among other things a list of names separated by comas. The names are between two tags <SME> and </SME>. Here is an example: The list of...
  2. DarthGAD

    How to combine result sets from different DB using Business View

    Crystal Reports XI with BusinessObjects Enterprise XI BusinessViews MS SQL 2000 Databases I have two database servers SERVER1 AND SERVER2. SERVER1 stores realtime data in a table. SERVER2 stores historical data and has a view to access the data. Datasets are compatible (Same fields) SAMPLE...
  3. DarthGAD

    Extract multiple words from one VARCHAR field

    I have a database that stores the IP address' of a computer in one field separated by a space. If the computer is mulitihomed it may have mulitple IP address'. I need to take the input: Computer ID IpAdress' 11114444 192.168.1.1 10.254.44.3 162.168.160.1 22224444 169.254.180.185 10.254.55.1...
  4. DarthGAD

    How to create a dynamic parameter for a command parameter

    I am using Crystal XI Pro stand alone. I will be using it in conjunction with BO Enteprise XI soon. How do you careate a dynamic parameter for a Command parameter. I have a command with one parameter group. If I crate a dynamic paramter I am prompted for the value of the command parameter...
  5. DarthGAD

    Remove carriage return and extra spaces from string

    I need to remove any carriage returns ChrW(13) and extra spaces ChrW(10) from a String. EXAMPLE: Hello, This is a nice day to fly a kite. Bye. DESIRED OUTCOME: Hello, this is a nice day to fly a kite. Bye. I can think of several ways of looping through the text but I am hoping someone else...
  6. DarthGAD

    Diff. betw. 2 times excluding holidays, weekend, & After Business Hrs

    I need to calculate the time lapse between two DateTime Entries excluding holidays, weekends, and after business hours. I am using Crystal Pro 10 with SQL, Access, and Excel. I found a solution in the FAQ but it seems to have a problem. The solution is found in faq767-5430 The problem is...

Part and Inventory Search

Back
Top