Visitors can check out the Forum FAQ by clicking this link. You have to register before you can post: click the REGISTER link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. View our Forum Privacy Policy.
Want to receive the latest contracting news and advice straight to your inbox? Sign up to the ContractorUK newsletter here. Every sign up will also be entered into a draw to WIN £100 Amazon vouchers!
Nope, they've just used a comma to separate the thousands. And occasionally put the currency code in as well.
REGEXP_SUBSTR to the rescue, since I can't rely on them putting numbers in a numerical column.
You TRUST users?
I always assume the user is offshore Dave. Totally useless at most things but can stand heights and nothing (i.e. force 12 gale) throws him. Therefore he wanders around a particular oil platform collecting the data.
Downside is that he can't do maths and can't type. So I check absolutely everything and assume nothing.
Comment