Search results for query: *

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...

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!

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

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.

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...

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

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...

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...

Perfect! Thanks so much.

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!

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...

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...

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...

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...

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

Thanks! That helped alot. How can I only show those ticket numbers on the report instead of all the other description info in that field?

Well, I am looking for results such as: SR 1-98087019 SR 1-98358183 1-98465813 which I am getting but I am also getting things like 1-800 numbers, ticket numbers, etc. I just verified that it will always contain 1-9 followed by 7 numbers. Any suggestions?

Yes! That worked. Unfortunately it brings back alot of junk but I guess that it so be expected from some keyword searches. Thanks again!

Every time I try to save this as a record selection formula it does not seem to save. I don't get any errors but then when I go back to see the record selection it isn't there? Any ideas? Thanks!

Crystal 10 and Oracle I would like to build a report that shows all tickets owned by a certain assignment group. Unfortunately that info is only found in a description field. How can I do a keyword search on that description field to find all tickets that contain '1-' or 'SR'? Thanks so much!