Skip to Content
avatar image
Former Member

extract specific character from string

Hello Experts,

I am trying to extract specific character from a string field. Data format example:

/southwest/science/samuel, john, 23445/

/northwest/english/larry, dan, 38543/

from above i just need to extract Science and English.

Your help will be appreciated.

Thanks

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Sep 26, 2017 at 08:10 AM

    Assuming they are always in front of the third / this will give you what you want, replace text with your field

    split('/southwest/science/samuel, john, 23445/','/')[3]

    Ian

    Add comment
    10|10000 characters needed characters exceeded