Discussion Board for collaboration related to QlikView App Development.
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.
Could you explain the logic (generic) how you got the output column?
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
Using MapSubstring() to edit strings | Qlikview Cookbook