Need help on Mapping

[Former Member]

Dear Expert,

     I have a scenario in PI 7.0 where i have to mapp a field like this:

        Source                                                       Target

        123010                                                       12:30:10 (Time format)

Can we achieve this with standard function?

[gagandeep_batra · Accepted solution]

yes using substring and concat function you can achieve this or using date function also

[Harish]

Hi Anirban,

you can check if input field is exist and have length equal to 6 then apply the dateformat function.

Regards,

Harish

[former_member184720]

incase the input field is optional - I would also suggest you to validate the length first and then do the above suggested date transformation so that mapping will not fail.

[former_member184681]

Hi,

Use standard DateTrans function with the following attributes:

Regards,

Greg