Comparing the Unique ID Predecessor to Text in a Custom Number Field

[Cole]

All,

I'm writing a formula that is comparing the Unique ID Predecessor to a
Text field. I'm using a custom number field for this formula. When the
two are equal the result is -1.

Although whenever a task has a lag or lead the formula is reading them
as not equal to each other. (Ex. 55SS+3 days should equal 55SS+3 days)
In this scenario, my result is 0 not -1.

Does anyone have a suggestion on how I can tell the formula to ignore
the white space or trim it?

Cole

 

[Jack Dahlgren]

You can use the Instr function to find the existance of and position of the
+ sign, then use the Left function to return all the characters to the left
of that.

Trim won't work because + is not a space.

Of course, if you have multiple predecssors your formula is pretty useless.

A more robust solution would be a VBA macro which can perform more string
manipulation tricks.

-Jack Dahlgren