Deleting unnecessary string

[L_Hop]

Hello,

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

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

[pradosh_thakur · Accepted solution]

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
];

[L_Hop]

Thank you so much, it worked.

regards;

OY

[L_Hop]

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]

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

[L_Hop]

Again thank you.

it is worked.

regards;

OY.

[pradosh_thakur]

NP.. happy to help my friend.