Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

onur0707
New Contributor III

Deleting unnecessary string

Hello,

            my data column is like below and I want to get rid of the highlighted red part.

datascreenshot.PNG

 

Remark
16/09/17-THEBE                  or İŞ
21/12/17-FOUR RIGOLETTO        �   �Ş
21/12/17-FOUR RIGOLETTO
21/12/17-FOUR RIGOLETTO            İŞ
15/12/17-SERENITAS N            D� �Ş
09/12/16-KITE BAY                . �Ş
21/12/17-WARRIOR                �    e
21/12/17-FOUR RIGOLETTO         �
23/12/17-DEIMOS                AĞ �Ş
9/16/2017-THEBE              İD�
18/07/17-KAVALA SEAS             �kö
21/06/17-NORD EMPEROR
21/06/17-NORD EMPEROR           Ğ �Ş
9/16/2017-THEBE                 Ğkö
17/12/17-LOUISA BOLTEN          �    e
22/12/17-INCE POINT

Do you have any suggestion?

Any help is appreciated!

Thanks

OY

1 Solution

Accepted Solutions
pradosh_thakur
Honored Contributor II

Re: Deleting unnecessary string

try this

load *,left(Remark,index(Remark & '  ','  ',1)) as Remark1;
load * inline [
Remark
16/09/17-THEBE                  or İŞ
21/12/17-FOUR RIGOLETTO        �   �Ş
21/12/17-FOUR RIGOLETTO
21/12/17-FOUR RIGOLETTO            İŞ
15/12/17-SERENITAS N            D� �Ş
09/12/16-KITE BAY                . �Ş
21/12/17-WARRIOR                �    e
21/12/17-FOUR RIGOLETTO         �
23/12/17-DEIMOS                AĞ �Ş
9/16/2017-THEBE              İD�
18/07/17-KAVALA SEAS             �kö
21/06/17-NORD EMPEROR
21/06/17-NORD EMPEROR           Ğ �Ş
9/16/2017-THEBE                 Ğkö
17/12/17-LOUISA BOLTEN          �    e
22/12/17-INCE POINT
];

Learning never stops.
6 Replies
pradosh_thakur
Honored Contributor II

Re: Deleting unnecessary string

try this

load *,left(Remark,index(Remark & '  ','  ',1)) as Remark1;
load * inline [
Remark
16/09/17-THEBE                  or İŞ
21/12/17-FOUR RIGOLETTO        �   �Ş
21/12/17-FOUR RIGOLETTO
21/12/17-FOUR RIGOLETTO            İŞ
15/12/17-SERENITAS N            D� �Ş
09/12/16-KITE BAY                . �Ş
21/12/17-WARRIOR                �    e
21/12/17-FOUR RIGOLETTO         �
23/12/17-DEIMOS                AĞ �Ş
9/16/2017-THEBE              İD�
18/07/17-KAVALA SEAS             �kö
21/06/17-NORD EMPEROR
21/06/17-NORD EMPEROR           Ğ �Ş
9/16/2017-THEBE                 Ğkö
17/12/17-LOUISA BOLTEN          �    e
22/12/17-INCE POINT
];

Learning never stops.
onur0707
New Contributor III

Re: Deleting unnecessary string

Thank you so much, it worked.

regards;

OY

onur0707
New Contributor III

Re: Deleting unnecessary string

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.

=date(left([Remark],8),'DD/MM/YYYY') .

Do you have any suggestion for getting the date information from the remark column?


regards;

OY

pradosh_thakur
Honored Contributor II

Re: Deleting unnecessary string

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

Learning never stops.
onur0707
New Contributor III

Re: Deleting unnecessary string

Again thank you.

it is worked.

regards;

OY.

pradosh_thakur
Honored Contributor II

Re: Deleting unnecessary string

NP.. happy to help my friend.

Learning never stops.
Community Browser