Forum Discussion

projects's avatar
projects
Regular Visitor
5 years ago
Solved

String match condition in conditional columns not working

Hello everyone,
I am trying to group the "Attribute" column data (row-wise) by creating a conditional column and pasting the group name against each element depending on what it's name is in the "Attributes" column. But, the problem I am facing is that, if the name of the element is too long and is shown in the form of wrapped text ( shown in two lines one below another)  in that "Attributes" column, the matching string entered in the conditional column does not exactly match with the original name in the attributes column and hence the conditinal column returns a null value. For example, if I am trying to match "Girder Pre Casting LHS Planned Date" in the Attributes column with the string " Girder Pre casting LHS" as a conditional matching string, the output comes as a null value and not the output string that I specified in the condition. Please refer to the screenshot attached for better clarity.   

  • Hi, projects 

     

    Go to the advanced editor and change the match value to "A" & "#(lf)" & "B", note that no space should be left between A and B. In you case, the Value should be: "Girder Pre Casting"&"#(lf)"&"LHS"

    my sample:

    Please refer to the attachment below for details

     

     

    Hope this helps.

     

    Best Regards,
    Community Support Team _ Zeon Zheng
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

3 Replies

    • projects's avatar
      projects
      Regular Visitor

      Thank You amitchandak , but I have multiple conditions here and I am not sure if text.contains works for multiple conditions because I have multiple groups and different outputs for different strings matched. Please refer the screenshot below for more information.

  • Hi, projects 

     

    Go to the advanced editor and change the match value to "A" & "#(lf)" & "B", note that no space should be left between A and B. In you case, the Value should be: "Girder Pre Casting"&"#(lf)"&"LHS"

    my sample:

    Please refer to the attachment below for details

     

     

    Hope this helps.

     

    Best Regards,
    Community Support Team _ Zeon Zheng
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.