Convert text to columns
- 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
Hello,
I'm looking to convert values in Summary and Description field to date and number columns.
Input:
Summary | Desc |
Error Report for 11/1 | There were 88 active error for 11/1 NCS: 80 Errors Tow: 0 Errors Tage: 8 Errors CG: 0 Errors  |
Error Report for 11/5 | There were 87 active error for 11/5 NCS: 0 Errors Tow: 0 Errors Tage: 77 Errors CG: 10 Errors |
Expected Output:
Systems | CG | TOW | NCS | TAGE | |
Dates | Active Errors | Errors | Errors | Errors | Errors |
11/1/2024 | 88 | 0 | 0 | 80 | 8 |
11/5/2024 | 87 | 10 | 0 | 0 | 77 |
Solved! Go to Solution.
- Labels:
- Custom Tools
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@geeklarokcmie a REGEX tool would probably help you get what you need. You could use that to parse out the fields and get the values you are looking for. Are the values in the DESC field stored as tab separated items, line breaks, or how?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Values in the Description field are separated into multiple lines with space after each line
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@geeklarokcmie here is an example of how you could use the Regex tool to get yourself started. If the errors are always going to be in that same order, you could simply use a select tool after and rename Errors1 to be NCS, Errors2 to be TOW, etc. You would then just need the digits portion of the regex tool to be returned.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@geeklarokcmie
Parsing non-structured data is not requiring much skills but just patience. 😁
here is my try on this.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
