Challenge #35: Data Cleansing Practice
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
mollyhatch
8 - Asteroid
08-24-2020
11:12 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
jacq999
6 - Meteoroid
08-25-2020
01:16 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
lauren83
7 - Meteor
08-25-2020
09:22 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
PriyankaaJ
7 - Meteor
08-26-2020
01:39 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Spoiler
1) just convert the field to type "double". Or use a formula tool and use the function toNumber()




2) cleanse it to remove letters and punctuation and then trim it
3) use the if condition and string functions like sub-string and length in a formula tool
4) again, use a combination of if condition with sub-string and length functions in a formula tool
rogshih
8 - Asteroid
08-26-2020
04:05 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Going to do a few more Beginner challenges before moving on to Intermediate ones.
Since I am using these challenges to study for the Core Exam, I've been recording my study session and putting them online to help keep myself accountable everyday! It's not the highest quality video, but I do talk through my thought process live and try to solve the challenge.
BobHabbijam
8 - Asteroid
08-27-2020
07:26 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
p_padham
8 - Asteroid
08-27-2020
12:52 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
etechman
8 - Asteroid
08-28-2020
11:14 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
bconard2
6 - Meteoroid
08-31-2020
05:11 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
DataHabanero
9 - Comet
08-31-2020
09:49 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator