1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

How to find first nonspace character from end of the string

Discussion in 'SQL PL/SQL' started by Shanmugapriya, Apr 23, 2018.

  1. Shanmugapriya

    Shanmugapriya Active Member

    Messages:
    55
    Likes Received:
    0
    Trophy Points:
    130
    Location:
    Bangalore
    Hi,

    how to find first nonspace character from end of the string


    ex: 'abc def g '

    I should get 4 in this case. (the first nonspace character from backwards in the above example is g and the position is 4 from backwards.

    Could you help me in getting this


    Thank you,
    Priya
     
  2. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,600
    Likes Received:
    364
    Trophy Points:
    1,430
    Location:
    Aurora, CO
    Ask your instructor.
     
  3. krasnoslobodtsev_si

    krasnoslobodtsev_si Forum Genius

    Messages:
    771
    Likes Received:
    145
    Trophy Points:
    830
    Location:
    Russian Federation
    for example:
    1) to use translate
    2) to use regexp

    Very important!
    Needed to read of the DOCUMENTATION.