Discussion board where members can get started with Qlik Sense.
my data column is like below and I want to get rid of the highlighted red part.
Do you have any suggestion?
Any help is appreciated!
Go to Solution.
load *,left(Remark,index(Remark & ' ',' ',1)) as Remark1;load * inline [Remark16/09/17-THEBE or İŞ21/12/17-FOUR RIGOLETTO � �Ş21/12/17-FOUR RIGOLETTO21/12/17-FOUR RIGOLETTO İŞ15/12/17-SERENITAS N D� �Ş09/12/16-KITE BAY . �Ş21/12/17-WARRIOR � e21/12/17-FOUR RIGOLETTO �23/12/17-DEIMOS AĞ �Ş9/16/2017-THEBE İD�18/07/17-KAVALA SEAS �kö21/06/17-NORD EMPEROR21/06/17-NORD EMPEROR Ğ �Ş9/16/2017-THEBE Ğkö17/12/17-LOUISA BOLTEN � e22/12/17-INCE POINT];
Thank you so much, it worked.
May I ask also another question, how can I get the date information from the remark column.
I have tried below code, it is working if the date is 8 digit but some dates are 7 digit like '16/09/17' and in this case it is not working.
Do you have any suggestion for getting the date information from the remark column?
alt(DATE(Date#(left(Remark,8),'DD/MM/YY')),DATE(Date#(purgechar(left(Remark,10),'-'),'MM/DD/YYYY'))) as Date
Your dates are in different formats.Make sure you check it properly
Again thank you.
it is worked.
NP.. happy to help my friend.