App Connect

Expand all | Collapse all

string with space in concatenation trimming white space at the end of first string

  • 1.  string with space in concatenation trimming white space at the end of first string

    Posted yesterday
    Hi Guys,

    Anyone knows how to concatenate two strings with a space without the IIB integration bus trimming the space during transmission.when i create a variable with a space separating the string i can see in the debug the string is concatenated well but on transmission i have noted that the space seems to be trimmed and i am getting errors.if i hard code the variable the string is sent and i am getting the valid response. please can someone help me fix this problem

    ------------------------------
    Kenneth Muragu
    ------------------------------


  • 2.  RE: string with space in concatenation trimming white space at the end of first string

    Posted 20 hours ago
    Hi Kenneth,

    You didn't mention how you're attempting this transformation. Are you doing this via ESQL, Mapping Node? So, this is what I would do via ESQL. I would not add the space to the end of the first variable, I would add it during the concatenation process itself.

    DECLARE cVariable1 CHAR 'FirstString';
    DECLARE cVariable2 CHAR 'SecondString';
    DECLARE cConcatString CHAR cVariable1  || ' ' || cVariable2;
    
    Result in cConcatString would be 'FirstString SecondString'​


    ------------------------------
    James E. (Jim) Berube
    Technical Account Manager (TAM) - Specialist, IBM Expertise Connect
    IBM Cloud and Cognitive Software
    ------------------------------