Home » SQL & PL/SQL » SQL & PL/SQL » Trimming Help (Oracle 9i)
Trimming Help [message #408698] Wed, 17 June 2009 06:15 Go to next message
jolly_makkar
Messages: 63
Registered: March 2008
Member
Hi,

i have to trim data which is like

09/1 ,09/2 ,10/3,10/4,10/5

i need the maximum sequence(after /) ,for which i need to trim first three characters i-e upto '/' .
how can i do this ??..


Thanks

[Updated on: Wed, 17 June 2009 06:19]

Report message to a moderator

Re: Trimming Help [message #408705 is a reply to message #408698] Wed, 17 June 2009 06:33 Go to previous messageGo to next message
jolly_makkar
Messages: 63
Registered: March 2008
Member
sorry guys that was silly ques...solution is so simple

select substr(col,4) from tablename

sorry ... Razz
Re: Trimming Help [message #408712 is a reply to message #408698] Wed, 17 June 2009 06:47 Go to previous messageGo to next message
seyed456
Messages: 220
Registered: May 2008
Location: south india .
Senior Member

Quote:
jolly_makkar
sorry guys that was silly ques...solution is so simple

select substr(col,4) from tablename

sorry ... Razz



We never help unless you specify test case..

[Updated on: Wed, 17 June 2009 06:47]

Report message to a moderator

Re: Trimming Help [message #408715 is a reply to message #408712] Wed, 17 June 2009 06:51 Go to previous messageGo to next message
pablolee
Messages: 2834
Registered: May 2007
Location: Scotland
Senior Member
seyed456 wrote on Wed, 17 June 2009 12:47

We never help unless you specify test case..


Really? Are you sure about that? Are you sure that you meant we, did you possibly mean I?
icon10.gif  Re: Trimming Help [message #408721 is a reply to message #408715] Wed, 17 June 2009 07:03 Go to previous messageGo to next message
seyed456
Messages: 220
Registered: May 2008
Location: south india .
Senior Member

pablolee wrote on Wed, 17 June 2009 06:51
seyed456 wrote on Wed, 17 June 2009 12:47

We never help unless you specify test case..


Really? Are you sure about that? Are you sure that you meant we, did you possibly mean I?



Razz

I mean ORAFAQ...hope you are part of it..
Re: Trimming Help [message #408734 is a reply to message #408721] Wed, 17 June 2009 07:33 Go to previous messageGo to next message
Littlefoot
Messages: 20895
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Well, I've seen people (members of the OraFAQ Forum) helping other people without specifying test case. True, some prefer having test case. The others (I could name a few, if you insist) do create their own test case and - guess what - provide answer!

So I'd say that you are wrong.
Re: Trimming Help [message #408738 is a reply to message #408705] Wed, 17 June 2009 07:44 Go to previous messageGo to next message
joy_division
Messages: 4640
Registered: February 2005
Location: East Coast USA
Senior Member
jolly_makkar wrote on Wed, 17 June 2009 07:33
sorry guys that was silly ques...solution is so simple

select substr(col,4) from tablename

sorry ... Razz


Not really. What about 01/22? substr(x,4) will give a string value of 22, which is less than 3 as a string, but greater than as a number.
Re: Trimming Help [message #408756 is a reply to message #408721] Wed, 17 June 2009 11:14 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
Quote:
pablolee wrote on Wed, 17 June 2009 06:51
seyed456 wrote on Wed, 17 June 2009 12:47

We never help unless you specify test case..


Really? Are you sure about that? Are you sure that you meant we, did you possibly mean I?



Razz

I mean ORAFAQ...hope you are part of it..


I guess I must not be part of ORAFAQ then, as I've created more test cases than you've made posts to this site.
I'll create a test case for someone if they describe their problem well enough.

This tendancy to refuse to help because the OP has not done X or Y or Z does nothing to improve the quality of the posts that people submit, and makes the site look aggressive and unhelpful.

If you don't want to help, then just don't post - it's that simple.

Re: Trimming Help [message #408901 is a reply to message #408698] Thu, 18 June 2009 04:28 Go to previous messageGo to next message
seyed456
Messages: 220
Registered: May 2008
Location: south india .
Senior Member

Really sorry to whom i hurt you ..I admit my mistake.

Re: Trimming Help [message #408959 is a reply to message #408901] Thu, 18 June 2009 08:00 Go to previous message
panyam
Messages: 146
Registered: May 2008
Senior Member

 select substr('12/322',instr('12/322','/')+1) from dual;
Previous Topic: Calculating time difference
Next Topic: Unable to insert XML Data
Goto Forum:
  


Current Time: Mon Dec 05 21:35:53 CST 2016

Total time taken to generate the page: 0.06428 seconds