Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I want to remove characters from field that appear in brackets.
Product_A-(01)
Product_A-(02)
Product_A_Blue-(01)
Product_A_Blue-(02)
Should appear as;
Product_A-
Product_A_Blue-
Can anyone help with this?
Thanks
Danny
=Left(Product, Index(Product, '(')-1)
=Left(Product, Index(Product, '(')-1)
PurgeChar(FieldName, '1234567890( )') as FieldName
Perfect! Thanks!