Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have Date Field in that field having values like '1.10.2019 to 13.10.2019'
' 14.10.2019 to 28.10.2019'
i want to divide this values into two fields,
From_Date field: To_Date:
'1.10.2019' '14.10.2019'
' 14.10.2019' ' 28.10.2019'
How can i do?
Thanks,
Hi @Nari999,
You can use the Subfield function like this:
origin:
load * inline [
dates;
'1.10.2019 to 13.10.2019';
'14.10.2019 to 28.10.2019';
] (delimiter is ';');
result:
load SubField(dates,'to',1) as From_Date,
SubField(dates,'to',-1) as To_Date
resident origin;
Result
Regards,
Ezir
Hi @Nari999,
You can use the Subfield function like this:
origin:
load * inline [
dates;
'1.10.2019 to 13.10.2019';
'14.10.2019 to 28.10.2019';
] (delimiter is ';');
result:
load SubField(dates,'to',1) as From_Date,
SubField(dates,'to',-1) as To_Date
resident origin;
Result
Regards,
Ezir