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!

  • Congratulations strongm 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: mrcamo
  • Order by date
  1. mrcamo

    Moddeling problem

    Thanks.. but the point is that everyday, x amount of coaches will be booked from the local depot, ... these could have a different registration plate ever day, so how feasibile is it holding a coach liscence plate number if there may only ever be one coach wil that liscence plate used on one day...
  2. mrcamo

    Moddeling problem

    Hi Im trying to model the following scenario: - a company organises excursions - for each excursion a member of staff books the required number of coaches for the number of customers whom have booked on that day to take them on the excursion -multiple excursions run in parralell to different...
  3. mrcamo

    control file help

    yes cheers, thats fine, another problem however.. one field in the database I am exporting from is Time.. i.e 07:40:00 .... but when I import this into access and then export as CSV it seems to be adding a date to it... instead of showing "07:40:00" it shows "30/12/1899 07:40:00" no idea...
  4. mrcamo

    control file help

    considering some colums aare empty and some contain dates in that format
  5. mrcamo

    control file help

    do you know how i can format dates in this format via the control file..? 31/01/2001 00:00:00
  6. mrcamo

    control file help

    sorry i have sorted that out aswell.. max characters is 255 unless specified :)
  7. mrcamo

    control file help

    Another problem im facing... say i manually remove all the character returns (in the csv) there is one row that keeps failing.. there is no line break in the row in the csv but the field is 340(including spaces) characters long. iv been testing it with random strings and anything of that size...
  8. mrcamo

    control file help

    I have fixed those issues, i managed to get a copy of the origional data and imported it into access and then exported as a csv using " (this worked for what was the memo field) But... the csv contains some record where the line breaks half way through the memo field (carridge return...
  9. mrcamo

    control file help

    O.K I see what your both saying now... I have 2 questions,, Considering I dont have the source application and only have the CSV file... 1.How do I replace single quotes with doubles quotes on every column? 2. One column was exported without quotes or single quotes (it was a memo field) how...
  10. mrcamo

    control file help

    I ahve done that, but I would also like to know how i could use a string function or something like that via the control file on the column that will escape single quotes between enclosing single quotes... surely it can be done??
  11. mrcamo

    control file help

    so there is no SQL string function that will escape single quotes in a string !?!?
  12. mrcamo

    control file help

    the file im trying to upload is over 1200 rows, I have just shown an extract. In the address field, some rows contain embedded commas and some contain embedded single quotes.. When I use OPTIONALLY ENCLOSED BY "'" it overcomes problems with commas but not embedded single quotes is there not a...
  13. mrcamo

    control file help

    sorry let me explain (my fault for being unclear).. lets say I had data that was like -> '24,arly street' '18 matthew's close' ... one string including an embedded single quote and one an embeddedcomma if i dont use OPTIONALLY ENCLOSED BY "'" ... and i do use a substring function then "24...
  14. mrcamo

    control file help

    sorry yes " ' " does work. however the comma in the row is a problem, as that comma breaks the fields, iv got 2000 rows, some of which in that field contain a comma, surely theres something I can do or a method of formatting the column to ignore commas between the enclosed single quotes other...
  15. mrcamo

    control file help

    Sorry forgot to say... im importing into a different table than my controll file shows in the first post: CustiD - Number(1) Suffix - VarChar2 (3) Fname -VarChar2 (20) Lname -VarChar2 (20) CustSpecNo - Number(4) Address1 -VarChar2 (100) Address2 -VarChar2 (100) Address3 -VarChar2 (100)...
  16. mrcamo

    control file help

    unfortunatly neither of them aproaches work, the second one is in my origional post, When porting data into oracle from that csv via sqlldr the enclosing single quotations on strings are carried accross.. I have solved the problem using substr, but now it is the problem with the comma in the...
  17. mrcamo

    control file help

    I have managed to use decode to turn false/true into y/n and also a substr function to remove enclosing single speach marks... the next problem I am facing is commas in the address field.. do you have any suggestions how to deal with the commas or alternative soloutions to the others? 2 rows...
  18. mrcamo

    control file help

    Hi Im importing a simple data set using sql loader, below is the controll file im using... The field named 'CustName' imports all the records but surround them in the oracle table with single quotes ... eg 'Dave' .. not Dave.. how can i alter the control file to remove these sinngle quotes when...
  19. mrcamo

    WOLAP software

    O.K thanks, In the event that a company allready has a data warehouse and data marts set up and they use client / server OLAP tools direct on these data sources... if they wanted to expand to allow OLAP functionallity via the web then does this mean that they would have to find a WOLAP...
  20. mrcamo

    top down vs bottom up

    is it not possible to apply top down and bottom up methods to the design of cubes ? and at the same time apply top down and bottom up methods to the design of star schemas. My point is that I am trying to write a document which describes the difference between top down and bottom up...

Part and Inventory Search

Back
Top