Challenge #2: Preparing Delimited Data
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I suppose there are a lot of ways to do this, I chose to parse everything.
Started with a RegEx replace, then Text to Columns and finished with DateTime tool.
I suppose this could be an issue if you wanted to retain double or single quotes that may have been contained within the string as opposed to surrounding the strings, but I figured I'd try something different.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
This was a really cool exercise especially working with the Text to Column parsing tool.
I ran a few iterations for possible solutions, but ultimately I ended up using the formula tool to to remove the quotes from the column attribute and the dateparse function in the poem date attribute to reformat from a string to a date.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Surprised to know how the "Text To Columns" tool allows you to add more than one delimiter at once. Used regular expression to replace the quotes in my date column which got created after parsing from "Text To Columns" tool. Easy-Peassy task as compared to Challenge #1 ;)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator