Data Cleaning
- 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
Hi I need to clean up some data i have an input column which has data i want to split it up into two column and then get final output column. The Split input 1 and split input 2 are just for understanding purpose i need to get the final result as shown in column output.
Input | Split Input 1 | Split Input 2 | Output |
HETH HA11 - | HETH | HA11 - | HA11 |
MARO MU32:B | MARO | MU32:B | MU32:B |
TGRA TB01:B | TGRA | TB01:B | TB01:B |
BURL BS02 - | BURL | BS02 - | BS02 |
CAMP CM47:D | CAMP | CM47:D | CM47:D |
SPLE SG19 - | SPLE | SG19 - | SG19 |
EDGE EC05 L | EDGE | EC05 L | EC05 |
Solved! Go to Solution.
- Labels:
- Tips and Tricks
- 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
Hi @ahsansalik
Here is how you can do it.
1. Split to column using text to columns delimiter space
2. Trim space and hyphen
Hope this helps 🙂
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thanks for your kind response in row 7 if you see the L is still in the final output which i want to get rid off
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thanks for your kind response in row 7 if you see the L is still in the final output which i want to get rid off aswell as i dont need - and any extra character like L
- 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 can however using your workflow add another formula to remove L but if i get anything else then i would have to add another formula function so i need to make it geneic
