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!

Recent content by redbunny78

  1. redbunny78

    Excel multiple values in one column, need to split

    I have an excel spreadsheet with several values that have been stored in one field. How can I best split them into other columns? This is what it currently looks like: Name Dr.William R. Hendee Rose Y. Byland MD. Ms. Cynthia Allen I need it to look like this: A B...
  2. redbunny78

    Excel multiple values in one column, need to split

    I'll look those up and see where that gets me. I am just new to this. I wasn't trying to get anyone to do everything for me. Just some clues about where to start. Thanks!
  3. redbunny78

    Excel multiple values in one column, need to split

    None! I don't even have a clue how to go about doing this :(
  4. redbunny78

    Excel multiple values in one column, need to split

    I asked and they said to just put the MD if there is Dr as the Salutation. They are assuming it catches most of the intances and the rest can be done manually.
  5. redbunny78

    Excel multiple values in one column, need to split

    I have an excel spreadsheet with several values that have been stored in one field. How can I best split them into other columns? This is what it currently looks like: A B C Salutation Name Designation Dr. William R. Hendee...
  6. redbunny78

    Updating a table using excel as a source

    I'm a bit confused about which transformation this would be. I don't see update as an option. Sorry for being so generic, this is the first time I've used it. Thanks
  7. redbunny78

    Updating a table using excel as a source

    Using SQL 2000 I need to update a pricing table based on data I have in an excel spreadsheet. I need to update the table partprice based on the partnum. The excel spreadsheet has two columns that contain the partnum and the updated price. What is the best method to do this? A DTS package...
  8. redbunny78

    Record selection with prefixes

    Using Crystal 10 and Oracle I need help with the record selection criteria for a report: - I would like to show all tickets opened after midnight the previous day by assignment group. The opentime is a datetime field - The assignment group needs to be limited to results with the following...
  9. redbunny78

    Group by first nine characters

    Perfect! Thanks so much.
  10. redbunny78

    Group by first nine characters

    Using crystal 10 and Oracle I am trying to group on a report by the first nine characters of a job name. What is the best way to do so? Thanks!
  11. redbunny78

    Showing yesterdays data on a YTD report

    It is a formula for UTC time conversion. DateTime((ToNumber(Left({ADS_JOB.JOB_DATETIME},4))) , (ToNumber(Mid({ADS_JOB.JOB_DATETIME},5,2))) , (ToNumber(Mid({ADS_JOB.JOB_DATETIME},7,2))) , (ToNumber(Mid({ADS_JOB.JOB_DATETIME},9,2))) , (ToNumber(Mid({ADS_JOB.JOB_DATETIME},11,2))) ,00) The...
  12. redbunny78

    Showing yesterdays data on a YTD report

    Sorry, I guess that was confusing... The YTD formulas actually aren't the same as the ones I need for yesterday and last 3 days. So I have a report with a few YTD formulas (the YTD is in the record selection formula) and need to show yesterdays results for the following formulas...
  13. redbunny78

    Showing yesterdays data on a YTD report

    I have a YTD report that shows has several formulas but I need to show the same data results for yesterday and the last 3 days. What is the best way to do so? The output would look like: Current YTD % 96% 2007 YTD / Success Rate 82,150 / 92.4 Yesterday / Success Rate 76% / 42 Last 3...
  14. redbunny78

    Showing YTD for previous years

    Using Crystal X and Oracle I have a report that shows YTD numbers based on a DateTime field. I also need to show the YTD numbers for last year and for this month last year. The output would look like: 2007 YTD /Success Rate 1160595/96% 2006 Oct /Success Rate 1440179/95% 2006 /Success Rate...
  15. redbunny78

    Keyword searches in description fields

    Yes! That works. Thanks so much for all the help.
See more

Part and Inventory Search

Back
Top