OraFAQ Forum: SQL & PL/SQL

Home » SQL & PL/SQL » SQL & PL/SQL » Trimming Help (Oracle 9i)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Trimming Help [message #408698]

Wed, 17 June 2009 06:15

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

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

Report message to a moderator

Re: Trimming Help [message #408712 is a reply to message #408698]

Wed, 17 June 2009 06:47

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

pablolee
Messages: 2882
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?

Report message to a moderator

Re: Trimming Help [message #408721 is a reply to message #408715]

Wed, 17 June 2009 07:03

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?

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

Report message to a moderator

Re: Trimming Help [message #408734 is a reply to message #408721]

Wed, 17 June 2009 07:33

Littlefoot
Messages: 21823
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.

Report message to a moderator

Re: Trimming Help [message #408738 is a reply to message #408705]

Wed, 17 June 2009 07:44

joy_division
Messages: 4963
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.

Report message to a moderator

Re: Trimming Help [message #408756 is a reply to message #408721]

Wed, 17 June 2009 11:14

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.

Report message to a moderator

Re: Trimming Help [message #408901 is a reply to message #408698]

Thu, 18 June 2009 04:28

seyed456
Messages: 220
Registered: May 2008
Location: south india .

Senior Member

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

Report message to a moderator

Re: Trimming Help [message #408959 is a reply to message #408901]

Thu, 18 June 2009 08:00

panyam
Messages: 146
Registered: May 2008

Senior Member

 select substr('12/322',instr('12/322','/')+1) from dual;

Report message to a moderator

Previous Topic:	Calculating time difference
Next Topic:	Unable to insert XML Data

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Dec 03 15:39:32 CST 2024