Forum Discussion

AlB's avatar
AlB
Icon for Community Champion rankCommunity Champion
3 years ago

Hi hermanos 

Try this

NewColumn = 
SWITCH (
    TRUE (),
    SEARCH ( "ships", TableName[Address] ) >= 1, 
    LEFT ( TableName[Address], 
           FIND ( "@", TableName[Address], SEARCH ( "@", TableName[Address] ) + 1 ) - 1 
         ),
    SEARCH ( "cars", TableName[Address] ) >= 1, 
    LEFT ( TableName[Address], SEARCH ( "@", TableName[Address] ) - 1 ),
    TableName[Address]
)

 

hermanos's avatar
hermanos
Frequent Visitor
3 years ago

It throws me an error. 
"The search Text provided to function 'SEARCH' could not be found in the given text."