split long string based on position of delimiter
HiI have a column that has long strings (see example below). I want to extract all the text after the 7th delimiter of "_" from the right. I tried munger but doesnt seem working well at the end part. can someone provide suggestion how I can do it right? 1)shjdjsh._ndjrpe_hfkjd_tyrwytre5_hlhm_jgds.d._jkdjf_hfkd_adesired output: ndjrpe_hfkjd_tyrwytre5_hlhm_jgds.d._jkdjf_hfkd_a
2)hhd_wew_klf:_jdbfjdf...