Scott Hoffman
-
Posts
2 -
Joined
-
Last visited
Everything posted by Scott Hoffman
-
Calc to remove letter after space
Scott Hoffman replied to Scott Hoffman's topic in Calculation Engine (Define Fields)
Found this...works great https://www.briandunning.com/cf/1659 -
Calc to remove letter after space
Scott Hoffman posted a topic in Calculation Engine (Define Fields)
I have an import field that has Id numbers that look like (TWC-1707 A , TWC-1707 B , BNC-123 , RWA-34567 A) I'm looking to remove the A,B,C from the Field and put it in another field along with the first part so a field "Id" will have TWC-1707 A , field "MasterId" will be TWC-1707 and field "partnumber" will be A. Is there a calculation to split the field after a space? this is importing from a 3rd party database that cannot be changed.