extract specific character from string

[former_member520272]

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

[Former Member]

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

[former_member520272]

Hi Ian,

Thanks for the quick response, is there a way to count it from the reverse order? Some of the records have blank spaces before /.

[Former Member]

try (all single quotes in example), this remove spaces before doing split

split(replace({yourfield},' ', ''),'/')[3]

Ian