Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
];
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
];
Thank you so much, it worked.
regards;
OY
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
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.
regards;
OY.
NP.. happy to help my friend.