cancel
Showing results for 
Search instead for 
Did you mean: 

Splitting of value i.e. Time format

Former Member
0 Kudos

Dear Experts,

Its about splitting the values i.e. the time . I got from Source system the value of time field as "YYYY-MM-DD-HR-MIN-SEC" and in the receiver I want to split the above value as "YYYY-MM-DD"  and "HR-MIN-SEC".

Can we perform by Message Mapping or if not, any one to share how to write UDF?

Regards

Rebecca

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos


Hi Rebecca,

You can use date/time seperator in datetrans function.

If you want to split and need to pass the date to two receiver fields means you can use substring (If you are getting same format).

below is the link for sample UDF function for date trans.

Thanks & Reagrds,

A.Neelima.

Harish
Active Contributor
0 Kudos

Hi Rebecca,

you can use the standard function Datetrans, please refer the below discussion for more detail

regards,

Harish

former_member184720
Active Contributor
0 Kudos

Just to add, you need to give the date and time separator manually as you don't find the separator "-" in the drop down.

input format : yyyy-MM-dd-HH-mm-ss

output : yyyy-MM-dd

You can even use sub-string function if it's always the same format

Harish
Active Contributor
0 Kudos

you can also refer the below screenshot