time field in mapping

[Former Member]

Hi Xi friends..

file to idoc

i want to convert date field value like <b>2006-10-10T14:10:10 </b>

to itime like <b>141010</b>

guide me please

regards

ram

[Former Member · Accepted solution]

Hi,

this will work:

sourcefield --> replaceString(sourceField/constant[T]/constant[]) --> TransformDate(yyyy-mm-ddHH:MM:SS --> HH:MM:SS) --> targetField

Daniel

[Former Member]

Hi friends....

my problem solved...thank you so much for your help...

keep going....

Oza,.

you already answered it...but its not populating when multiple Idocs generating..

thank you

regards

ram

[Former Member]

ram,

DateTransformation will not work if you have the <b>T</b> between your date and time. One option is to use substring function and get the time part alone and then use the Date transformation function...

Regards,

Jai Shankar

[former_member184619]

hi,

i think jai is right... u can use substring fun.

<b>SUBSTRING</b>

Returns a substring O for a string I. Use the dialog for the function properties to specify the position of the substring. Example: substring(“Hello”, 0,1) = “H”, means that the substring from Startindex 0 to Endindex 1 (not including position 1) is shown.

Regards

Sachin

[Former Member]

Hi ram,

Already answered I feel.

You only asked!!!

Thanks,

Tuhin

[former_member184619]

hi ram,

use DateTrans fun.

src format :- yyyy-MM-dd HHmmss

DST format:- HHmmss

regards

Sachin

[Former Member]

Hi,

use dateTrans function from

<b>yyyy-MM-dd hh:mm:ss</b>

to

<b>HHmmss</b>

im not sure if time works with the function.

if not use a user definied function similiar to following:

/people/robin.schroeder/blog/2006/11/21/dynamic-date-conversion-in-message-mapping

Regards,

Robin