I have the data with number of symbols and i want to split the data as the output model.
I am attach the excel file.Please give the suggestion.
Thanks in advance.
I am assuming
1) you want data from first occurrence of "T"
2) the (HOL), and ($) will always at the end of string
in such scenario below formula may help you out
Thanks for giving good suggestion and one more of split 11-TS7865HFD-HTGE in this last words are shows only like HTGE instead of TS7865HFD. Please give suggestion.
Just add one more subfield as below
IF the answer helped you to solve your issue kindly mark it as correct and helpful.
Hi you can do it using MapSubString:
mapping LOAD * INLINE [
" ", ""
trim(MapSubString('ReplaceMap', mid(data, Index(data, 'T'), len(data)))) as ReplacedString
LOAD * INLINE [
02-TS 65HGT, TS65HGT
03 TG 98HJ(HOL), TG98HJ
04 TG.78.KJI, TG78KJI