Please help to see why this formula returns 1 instead of 0?

IFTRIM(Deliverable Item) <> TRIM('DAT.040 Approved Deliverables'.Deliverable Item[LOOKUP: 'SYS.910 Other Settings'.Audit Version Lookup])THEN 1ELSE 0

Deliverable Item is ：Channel Data Mgmt Platform: Pre-study to build one single harmonized platform for all our Partner data, expanding our capability to deliver data driven insights ；

'DAT.040 Approved Deliverables'.Deliverable Item[LOOKUP: 'SYS.910 Other Settings'.Audit Version Lookup]) is：

Channel Data Mgmt Platform: Pre-study to build one single harmonized platform for all our Partner data, expanding our capability to deliver data driven insights；

Accepted answers

licx13

Update the progress，the issue has been soloved .

All comments

Vinay VaradarajM

@licx13

It appears there is a space before the semicolon in first expression.

regards,

vinayvm

licx13

@vinayvm

Yes, there are indeed spaces in the first expression, but I used the trim function for comparison. Why didn't I remove the spaces?

Vinay VaradarajM

@licx13 ,

The trim function removes leading and trailing spaces, and any extra spaces between words (replaces with single space char). So, there would still remain a diff between the two texts you are comparing. Therefore, it is returning the right result.

Here is the detail about trim function:

https://help.anaplan.com/trim-351955a5-838c-4f3b-9073-96732fc259a9

Perhaps, you might want to try this function with shorter texts just for clarity.

regards,

vinayvm

licx13

If necessary, how can I compare long texts with only the last few spaces left?Is there a way to remove the last blank space?

thanks

Sai_Bharadwaj_Venati

Is it possible to compare after ignoring semicolon/last character… To ignore semicolon you can get length of character and use left function -1….After removing semicolon you can use the trim formula which you're using currently

licx13

The problem now is that the last char of this long text is a space. I tried to use the trim function to remove it, but it was unsuccessful.

Text is :

"Channel Data Mgmt Platform: Pre-study to build one single harmonized platform for all our Partner data, expanding our capability to deliver data driven insights "

Need help

Sai_Bharadwaj_Venati

can you please share screenshot of your formulas

licx13

*Resource Name is：

“Channel Data Mgmt Platform: Pre-study to build one single harmonized platform for all our Partner data, expanding our capability to deliver data driven insights ”

trim *Resource Name still is:

“Channel Data Mgmt Platform: Pre-study to build one single harmonized platform for all our Partner data, expanding our capability to deliver data driven insights ”

why?

licx13

Update the progress，the issue has been soloved .

Quick Links

Can you help?

Unanswered questions

Sorting General List
Hi, I wonder if there's a way I can sort my general list alphabetically. The list is used as a drop down menu in a line item module and I want the drop down menu to be easy to navigate. I've already tried the Order List action. I already have a module with a text-formatted line item based on that list. But when I try to…
Predefaulting A Feild in ANAPLAN
Hello Anaplan Community, I have a special requirement from a customer and would appreciate your input. Let me explain the situation: We have a hierarchy with three levels: Level 1, Level 2, and Level 3. Screen 1: Creation of Level 1 Items On this screen, the user selects a team. Based on their selection, an action runs to…
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…