Text manipulation in formula field

[btkGT06]

I am trying to create a custom text field to use for grouping and want
to chop the outline number at the last decimal. This would allow all
tasks to have an outline number equal to the header one above them
etc. Is there a string function for this.

Otherwise, is it possible to use a VB macro in order to define group
levels depending on what filter is applied and what outline levels are
there??

Thanks again,
Bryant

 

[Jan De Messemaeker]

Hi,

Cstr function will make sure your outline number is text
Instr will locate the dots
and Left using the Instr output will give you the desired string.

In VBA, as soon as you can define the logic, all is possible.

HTH