Skip to Content
avatar image
Former Member

mapping...

Hi,

I am getting transaction time as

TransactionTime-2011-08-23 20:17:50.000 it want to split into two fields date and time how to acheive

1st field i achieved-using substring 0-10

2nd field i want to acheive 20:17:50 i am getting error if i use substring 12-23

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Jul 28, 2017 at 11:58 AM

    If ter is a space between date and time field try the below UDF

    For substring try with the below(11,11) since second parameter is number of characters not the end value.

    Add comment
    10|10000 characters needed characters exceeded

  • Jul 28, 2017 at 04:27 PM

    I would use replaceString function with source string as first parameter, date part from previous step as second and '' as third. I guess I'm too lazy :-)

    Regards, Evgeniy.

    Add comment
    10|10000 characters needed characters exceeded