Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello there,
I'm struggleing a little bit with the preparation of my data.
From my Excel-File I've got two columns with a Date and Time string. The Format is like this "12.07.2021 09:15:00.000".
Now I tried to seperate this string into two columns, one with the date and one with the time. So I programmed into tJavaFlex the attached code.
I wanted to do the same for the second DateTime-column as well.
My problem with this column is, that some fields are empty. So if I try to seperate with my index-variable I get the error message "String index out of range".
To solve this problem I created an if/else-condition. The if-part worked perfectly well, but I'm struggeling with the else. It should work like this:
If a field is not empty (!=null) the programm should split the column into "Einbau" und "Zeit" else it shpuld write NULL into the "Einbau"-column.
Could anyone help me?
Thanks a lot and see the attached screenshot,
Lara
Hi
I think you should handle the null value first, eg:
(row1.columnName==null){
row3.dateColumn=null;
row3.timeColumn=null;
}else{
balabala
}
Regards
Shong