This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
It would be great if there was a way for the Text to Columns tool did not drop the last empty when using Split to Rows.
For example, if I had the data:
Notice that each value has two commas (representing three values per cell), and If I configure to split into rows on the comma character, what would you expect the result to be:
I would expect Result C if I selected "Skip Empty Fileds", and that is what happens if I select that option.
But If I do not want to skip empty fields, I would expect Result B, but what I get is Result A where the last value/field is dropped/skipped.
What would it take to Result B as the output from the Text to Columns tool?
Confirmed - same behavior still seen in version 2019.2 - drops last column if empty.
My work-around was as follows. Case: reading in several files with varying numbers of columns (but at least within each file, the first row is headers, and the data have consistent # columns with header). Desired output - vertical version of each file, with name/value pair per "cell" of data, regardless if the "cell" was empty (a la your "Result B").
What I did:
If the tool worked like you'd expect (your "Result B"), you would only need the J output. But including the L ensured that I got cases where the last column is always empty.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.