How to only take the correct part of data in a cell

[LarsDellen]

Dear all, 

on a steep learning curve (coming from mastering Excel) I try to come up with a formula that takes all the valid data of a cell, up to a specific character and ignores everything from there onward.

I have data coming in like this:
200 WEST NORTH AVENUE *************EMAIL TO: INVOICES@SCHOLLE.COM IL

...and would like to identify the position of the first Asterix (red) minus 1 as there is always a blank space before the Asterix, so I can take the Length from the left until the position of the Asterix.
I can't get my head around how the formula should be composed in Alteryx.

Any help appreciated.

[Emil_Kos · Accepted solution]

Hi @LarsDellen,

I have used combination of find and left in order to create this formula:

Left([Field1], FindString([Field1], ' *'))

Field1 should be replaced with the proper column name.

Please mark my post as a solution if this was helpful!

[LarsDellen]

Thanks for the swift support. I was so close....