Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Dumb SQL Question

Dumb SQL Question

From: Holly <excyauseme_at_gmail.com>
Date: 10 Jul 2006 11:09:25 -0700
Message-ID: <1152554965.487531.307170@s13g2000cwa.googlegroups.com>


Hi guys. I need some help with a Toad SQL query I'm doing. We have some data in ClearQuest that I'm trying to extract into a delimited file (with '&')

My query works except there is a tricky column (a free-form one) where the users can enter
values like 12345 or 12,345 or 12345,99999,121212. And sometimes they enter AB12345.
This is a big pain, because I'm trying to split the 12345,99999,121212 into separate columns 1, 2 and 3. But then the 12,345 gets me because it is then delimited into two separate columns 1 and 2 when it should have been 12345 in the first place but the user entered it wrong and ClearQuest doesn't check the formatting.

I was using a replace to get the commas out, like:

replace(replace(replace(t1.dumb_cm,'AB'),'&','?'),',','&')||'?'||

and also create '&' as my delimiter.

But now the 12,345 is becoming 12&345& and I don't know how to remove/replace/instr/expreg the thousands separator column out?

I hope this made sense, and if anybody can help out that would be great! Received on Mon Jul 10 2006 - 13:09:25 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US