Unexpected benefit of jury duty is having the time to catch up on challenges. My first go at both a hard and easy solution are very similar. So I decided to try another approach. Dynamic Replace, I'm beginning to understand you......
Also, I love RegEx
The Arrange tool needs some love, a powerful data transformation tool, but this week's challenge does take advantage of all its capabilities.
If EndsWith([Salary], Substring([Name],7,1)) AND ToNumber([Salary],1,1)<[Value] THEN [Rate] ELSE Null() ENDIFThis takes advantage of how the ToNumber() function works, it will convert all numbers prior to the first non-numeric character. We can suppress the conversion warning with the additional arguments.