Recent content by mrcamo

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

considering some colums aare empty and some contain dates in that format

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

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

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

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

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