I'm not sure why I'm having trouble with this calculation, but I seem to be having a brain freeze on it.

I need a calculation that will take everything to the right of the 13th ":" in a data stream. There isn't a fixed length to the text that will come after the ":" it just ends. Any suggestions would be most welcome.

Maybe this link will help:

http://www.fmforums.com/forum/showtopic.php?tid/202624/

Trim ( Let ( start = Position ( text ; ":" ; 1 ; 13 ) ;

Right ( text ; Length ( text ) - start )

) )

I didn't see you posting, Barbara. :smile2:

Edited November 10, 200916 yr by Guest

Try:

Let([

start = Position ( YourTextField ; ":" ; 1 ; 13 ) + 1 ;

end = Length ( YourTextField ) - start + 1

];

Middle ( YourTextField ; start ; end )

)

Neither me, LaRetta & Barbara !

Edited November 10, 200916 yr by Guest

Thanks so much. Those were both really helpful!