Challenge #35: Data Cleansing Practice

[kmcdaniel]

Spoiler

I found the TrimLeft and other string functions within the formulas module to be quite helpful for this exercise.
Handled the last 2 challenges with a single formula using conditional logic commands.

workflow tools

[SueDonim]

Spoiler

Spoiler

Part 1:
- Convert input to number using ToNumber function

Part 2:

- Convert input to number using ToNumber function (this automatically removed all text characters - but did have to resize to INT32 to hold larger number)

Part 3:
- Remove "ID" from right 2 characters of field (if it exists)

Part 4:

- Calculate string length

  -- If = 6 append "SC" to front

  -- If >8 grab left-most 8 characters

  -- Otherwise, no change

Pleasant surprise was converting string to number removed text automatically.

Lessons learned:

- converting string

- be careful about length of new field (can be huge accidentally)

[KenL]

Here is my solution!

[Fer_R]

Hi, 

Solution is attached. Great challenge!!

[jusdespommes]

Good Regex practice 🙂

Spoiler

[varunvarma87]

Challenge 35 completed

Spoiler

[BSilverblatt]

Thanks for the challenge! This is my solution.

[palakjindal]

Sharing my solution!