Given: A table that has data that is separated by spaces and you have columns that have multi-word values that you want to keep delimited by spaces.
Action: In a app with suitable search / replace functionality, follow these steps
- Replace all ' ' (two space occurrences) with a tab character
- Replace all ' ' (two tab occurrences) with a tab character
- Repeat step 2 until the two tab term is no longer found.
No comments:
Post a Comment