Extracting substring and converting to column
Hi, Need some help with proceesing a long string.I have a table with several columns;one column has a long string as follows-EntitySubstringARWYT|ZZRZQ_pp29_Nxy13_7|54.58|ZZRZQ_pp29_Nxy13_3|51.72|ZZRZQ_pp29_Nxy13_5|54.31I need to remove first four characters "RWYT" and expected output is as follows: EntitySubstringZZRZQ_pp29_Nxy13_7ZZRZQ_pp29_Nxy13_3ZZRZQ_pp29_Nxy13_5ARWYT|ZZRZQ_pp29_Nxy13_7|54.58...