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.
Solved! Go to 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!
Thanks for the swift support. I was so close....