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.


    capture3.png (15.0 kB)
    capture1.png (41.0 kB)
    capture.png (33.5 kB)
    capture.png (73.8 kB)
    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