SPLIT COLUMN INTO MULTIPLE 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
Hi I have a problem separating columns properly because the values are stuck into one column only.
From this: (only one column)
JournalNumber Date AccountCode Debit Credit |
22222222 2/2/2019 5555999 9000 0 |
33333330 3/2/2019 4444000 800 0 |
34344344 2/5/2019 5555555 700 0 |
To this:
JournalNumber | Date | AccountCode | Debit | Credit |
22222222 | 2/2/2019 | 5555999 | 9000 | 0 |
33333330 | 3/2/2019 | 4444000 | 800 | 0 |
34344344 | 2/5/2019 | 5555555 | 700 | 0 |
What are the appropriate tools I could use with this one. Can you help me with this one pls?
Solved! Go to Solution.
- Labels:
- Topic of Interest
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @enkenmendoza,
Thank you for your question to the Community!
I moved your post to the Designer Discussions forum where you can ask anything about Designer.
This article "Q&A: Where Do I Post My Questions?" should also help you out.
Let us know how it goes!
Cheers,
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @enkenmendoza ,
As you can see from your input, your different columns are separated with a whitespace. You can use that whitespace as a delimiter to split to different columns using the Text to columns tool.
Then with the dynamic rename tool, you can grab the column headers from the first row of data, and probably clean the leading and trailing whitespaces in the last column with the Trim function in a formula tool.
Hope that helps, let me know if that worked for you.
Regards,
Angelos
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@enkenmendoza
Based on your sample data, it seems that Space as delimiter should work.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
A simple way to achieve this is with text to columns. Your values are split by a varying number of spaces. I used a data cleansing to remove duplicate spaces, so each value was separated only by 1 space. I then used text to columns with a delimiter on a space, to create 5 columns. A select removed the original field, and a dynamic rename bumped the headers up.
Hope this helps!
![](/skins/images/33644471E927638F516C93A75ADDEE18/responsive_peak/images/icon_anonymous_message.png)