Convert .csv to Oracle

[mike2000]

If I have the .CSV file in excel and the data with a lot of ~(tilda) in the data, how can I clean out those ~ and save. Another word, I want to convert this file to Oracle.

Any Suggestion????

thanks

[ngdh]

mike2000

'~' marks should not be an issue as far as Oracle is concerned.

Transfer the file to the host operating system and use sqlload to insert the data into an Oracle table. If the operating system is Unix it would be quite easy to get rid of the tilde marks.
Otherwise update the table once the data is in Oracle.

Good luck

Nick

[Cookies]

OR, open file in excel.
click EDIT.
click REPLACE
fill in replace with your tilde (~) and have a null value in REPLACE_WITH
click OK (or click replace all or whatever)

all your tildes (~) will be gone

load your .csv file with sqlldr

[ngdh]

Originally posted by Cookies
OR, open file in excel.
click EDIT.
click REPLACE
fill in replace with your tilde (~) and have a null value in REPLACE_WITH
click OK (or click replace all or whatever)

all your tildes (~) will be gone

load your .csv file with sqlldr

Hi guys,

Sorry cookies, not targeting you but I'm using Excel 97 and replace won't find tilde marks. What version are you using?


Cheers

Nick

[Cookies]

sorry for late response.

well, convert the file into flat-text and then open in TEXTPAD.
you can then remove the tildes easily in TEXTPAD.

[easwaran_r]

Mike2000
You can replace tildes (~) in excel 97
go to edit menu, replace
then enter ~~ in find what then enter nothing in replace with
click the button replaceall.
This work will be done in no time.

Regards
Easwaran

[ngdh]

Thanks Easwaran


Good answer, what's the rule with this type of search & replace all, special characters must be double entered?

Feel free to suggest RTFM but I'm just curious.

Cheers

Nick