date

[JoseGarcia]

Hi there, 
My 'start'  columns is displaying data in different ways (it should read as a date format). 
To remove the 'A' I ma using Purge function but is disturbing other Column records.
Could you look at picture and advise how could I harmonise all entries to display within the same date format?

Thanks a million.
Jose

[Chanty4u · Accepted solution]

Hi try below

load * ,
PurgeChar(a,' A') as New,
date(a)as Date;;

LOAD * INLINE [
a
44238
18-oct-20 A
15-sep-20 A
-
44151
45001

];

[JoseGarcia]

It did worked! 🙂

i've got the same scenario with another column. 
Can I copy and paste?
The name of the column is 'Finish'

[Chanty4u]

Yes just replace the column name.

[JoseGarcia]

I replaced column name, but not working. 
Where am I going wrong:

load * ,
PurgeChar(Finish, 'A') as new1;
LOAD * INLINE [
Finish
44238
18-oct-20 A
15-sep-20 A
-
44151
45001

];

[Chanty4u]

you missed this 

date(Finish)as Date_New;

[JoseGarcia]

sorry to be such a pain 😞
For the Column 'Finish' , It does not function.
What is wrong with my head?

load * ,
PurgeChar(Finish, 'A') as New1,
date(Finish)as Date_New;;

LOAD * INLINE [
Finish
44238
18-oct-20 A
15-sep-20 A
-
44151
45001

];

[JoseGarcia]

I've added a picture, if clariffies some how 😞