B2B Integration

Sterling B2B Integration

Come for answers, stay for best practices. All we're missing is you.

 View Only

  • 1.  ITX--Date&Time format for multiple separator

    Posted 05/05/20 02:10 PM
    Hi,

    Is there any Date format is there which can accept multiple separator?

    CCYY-MM-DD--so if in place of Hyphen if / or \ or . present in the input data then map should accept the data as valid date

    using fromdatetime,i can convert this incoming date to expected output date format.

    Please suggest if there is any format as such or any way to accept the date with different separator

    Thanks
    Santanu

    ------------------------------
    Santanu Baral
    ------------------------------

    #SupplyChain
    #B2BIntegration


  • 2.  RE: ITX--Date&Time format for multiple separator

    Posted 05/12/20 02:45 AM
    Edited by System Admin 03/22/23 11:52 AM
    Hi,

    You could have your input filed as string/character and use the TODATETIME function to first recognize the input date format.
    TODATETIME - function converts a text string of a specified format to a date-time item.
    you could use this in combination with FROMDATETIME()  to generate output in required format.

    Knowledge center has more information on these functions.

    https://www.ibm.com/support/knowledgecenter/en/SSVSD8_10.0.0/com.ibm.websphere.dtx.funcexp.doc/references/r_funcs_express_TODATETIME_date_time.htm


    ------------------------------
    Karthikeyan RAGHURAMACHANDRAN
    ------------------------------



  • 3.  RE: ITX--Date&Time format for multiple separator

    Posted 05/12/20 07:49 AM
    Hi,

    Thanks for your reply.

    my challenge here is ,we are planning to create generic map for multiple partners.

    So different partners can send date & time differently.

    As of now,we have found CCYY-MM-DD,CCYY/MM/DD,CCYY.MM.DD ,CCYYMMDD,MM/DD/CCYY,MMDDCCYY

    We can use multiple IF ELSE function with TODATETIME(Field1,"CCYY-MM-DD")  to check all these date format

    but is there any way to pass all these date combinations in a single TODATETIME function? or a date&time format which can check multiple separator

    Like CCYY-M-D---using this format we can check single digit as well as double digit date,month

    I have checked type tree customise option to get a date & time format for multiple separator but could not able to get it.

    Initially i thought to use MEMBER function with TODATETIME function but it does not work

    Thanks
    Santanu

    ------------------------------
    Santanu Baral
    ------------------------------

    Original Message


  • 4.  RE: ITX--Date&Time format for multiple separator

    Posted 05/14/20 04:10 AM
    Hi,

    if you can "predict" the possible formats, I think the way to go would be a partition on the date item, so that you accept all predictible formats. This has the great advantage of leaving the item as a date, thus avoiding having to convert from a string.

    Another possibility would be to use  a combination of MID, ISNUMBER and LEAVENUMBERS functions:
         - If LEAVENUMBERS keeps the item as is, and the length is 8, the format is CCYYMMDD
          - If LEAVENUMBERS keeps the item as is, this means it contains only numeric digits, and the length is 6, the format is YYMMDD (good luck if you also receive YYDDMM )
        - if the character in 3rd position is not a number, it is the separator and teh format is MM?DD?CCYY
        - if the 5th character is not a number, it is the separator.

    I'd use a functional map for this, so that the "code" is reusable, and the ASFUNCTION function so that it can be used everywhere.

    Hope that helps!

    ------------------------------
    Laurent Barthelemy
    Technical director
    Satisco
    mont saint guibert
    +33 616792115
    ------------------------------

    Original Message


  • 5.  RE: ITX--Date&Time format for multiple separator

    Posted 05/14/20 09:04 AM
    Thank you so much

    ASFUNCTION looks promising....

    I have already gone through the details present in knowledgecenter where i have gone through the details.

    However is there any other sample or details with example of this function.

    ------------------------------
    Santanu Baral
    ------------------------------

    Original Message


  • 6.  RE: ITX--Date&Time format for multiple separator

    Posted 05/15/20 10:37 AM
    I favour the partition Type tree object approach, as it gives greater clarity.  It would be essential to ensure the order in which the combinations were attempted, to ensure there were no inaccurate validations.

    ------------------------------
    Jane Moreau
    ------------------------------

    Original Message


Related Content