Challenge #35: Data Cleansing Practice

[sanjay_shinde]

Had little problem to solve last problem but find a way through. 

[mkreddy]

For removing leading zeroes and in second case text i just converted the field type to numeric

Used Trim function to remove ID string from End

Finally used If and trim function in formula tool

[François_Rs]

Spoiler

[alacoume]

My solution:

[Shreya_p]

Spoiler

[robbie0sc]

Spoiler

Solution

[tomrob]

Spoiler

[AngelPradeesh]

To get the desired outputs please follow the below steps:

1. Use  a formula tool to get the new field. The formula used should be Trim([Field1],"0")

2. Use a formula tool to get the desired output. Formula to be used should be Trimleft([Field1],"0"). Post that, use the text to columns tool to remove the delmiter ":". Finally use the select tool to get the desired fields

3. Use formula tool to get the desired output. Formula used should be TrimRight([ID],"ID")

4. Use the formula tool to get the desired output. The formula used should be " If Length([Safety Code])=6 then "SC"+[Safety Code] else left ([Safety Code],8) endif

Thank you!

[corleyr]

Here is my solution

[benjimoser]

My Solution

Spoiler