Left Text of a specific word

[Gary1478]

Does any have a quick calculation when trying to get all the text left of a specific word in a field? In this case the word is "time".

Thanks.

Gary

[JesseSFR]

name: Left Of

parameters: string, matchstring

definition:

Let(

FirstCharOfMatchString = Position ( string; matchstring ; 1 ; 1 );

Left( string; FirstCharOfMatchString - 1 )

)

All you have to do is pass the string you are `searching for` as matchstring and the string you are `searching` as string. As an example:

Left Of ( "This post was just in time to fix the problem" ; " time" )

would return "This post was just in ". A caveat to this approach is that it will match words like timely or multimedia

Edited July 21, 2007 by Guest

[Gary1478]

Thank you.