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...
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...
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...
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...
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...
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...
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??
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...
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...
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...
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)...
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...
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...
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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.