Removing characters based on FIND

[jb]

Hi,
Can anyone tell me what the Alteryx formula equivalent should be for this excel statement?
=LEFT(J3,(FIND(":L",J3,1))-1)

The "J3" cell in this case is a column called "Ad Name" and we are trying to convert a value like this:

Sample|FY16|Sample|CPM|1x1|RON|CRM|EE75+||PC|V|SSIC|P|Deal ID_:15_EE No Kids:L13686562_04/29

to be shortened based on where it finds ":L" to be:

Hotwire|FY16|Turn|CPM|1x1|RON|CRM|EE75+||PC|V|SSIC|P|Deal ID_:15_EE No Kids

Thanks!

[JohnJPS · Accepted solution]

Does this work:

Left([Ad Name],FindString([Ad Name],":L")-1)