Delimiter as text separator

[macrabbit]

Hello,

 

I need to remove text in a field which is separated by a ":".

Is there a way of telling FM to use ":" as a delimiter and remove or replace any text that is following a ":" ?

 

Thanks!

[doughemi]

This calculation should do it:

 

Let([

len = length(Self);

colon_pos = Position(Self; ":"; 1;1);

up_to_colon = Left(Self; colon_pos);

after_colon = Right(Self; len - colon_pos +1)];

up_to_colon & "new text to display after colon"

)

 

Set the field as a text field and set it to auto enter the above calculation. If the data in the field is being imported or manually entered after the record is created, uncheck the "do not replace the existing value..." checkbox.