Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAmy solution
This is my second weekly challenge Please have a look over the solution.
1. Remove leading zeros : A) Used 'Select' tool > change data type to 'Double', B) Used ToNumber function
2. Trim leading zeros and / descriptive texts : Used ToNumber function
3. Remove 'ID' from the end : A) Wrote conditional function IF Right([ID], 2)='ID' THEN Left([ID], Length([ID])-2) ELSE [ID] ENDIF; B) Used TrimRight
4. Add 'SC' and remove anything after 8 characters : Wrote conditional function IF Length([Safety Code])>8 THEN Left([Safety Code], 😎 ELSE IF Length([Safety Code])=6 THEN 'SC'+[Safety Code] ELSE [Safety Code] ENDIF ENDIF
Looking forward to better approaches.
Regards
KD