Coping from .txt file to excel I lose about 1340 lines from 61787, where do they disappear to?
The txt file is filled with data I've extracted from some json's in this format:
filename|title_of_article
I've made sure that all of them have a title so no empty strings there.
When I copy this information into excel with the text to columns option set to "|" only.
The information is split properly into 2 columns however I end up losing about 1340 lines along the way. How does that happen?
When I do the same but do not set the Text to column options beforehand I copy everything to excel. I lose no lines.
Where does this problem come from?
I ran a vlookup and here are some of the lines that didn't copy in the first way:
as far as I can see there is nothing special about them.
excel
asked Nov 23 '18 at 13:23
cyberacybera
9612
add a comment |
The txt file is filled with data I've extracted from some json's in this format:
filename|title_of_article
I've made sure that all of them have a title so no empty strings there.
When I copy this information into excel with the text to columns option set to "|" only.
The information is split properly into 2 columns however I end up losing about 1340 lines along the way. How does that happen?
When I do the same but do not set the Text to column options beforehand I copy everything to excel. I lose no lines.
Where does this problem come from?
I ran a vlookup and here are some of the lines that didn't copy in the first way:
as far as I can see there is nothing special about them.
excel
asked Nov 23 '18 at 13:23
cyberacybera
9612
probably the text to columns is generating some extra lines and either replacing the data that is in there (you should get a message when this happens though) or maybe have you go over the limit for an older version of excel? It seems you are not exceeding it, but the limit of rows for excel 2007 is 65536 for instance
– Chrisvdberge
Nov 23 '18 at 13:31
a sample of the data would be helpful. And make sure there are no | present in the data on which you don't want to split
– Chrisvdberge
Nov 23 '18 at 13:31
@Chrisvdberge I've made sure there are no | in the data as if there were they would push information into next columns, but there is nothing in them. Also I'm using office365 so its a pretty recent version.
– cybera
Nov 23 '18 at 13:33
@Chrisvdberge I'm intrigued by the possibility of excel overwriting lines, but I can't figure out how that could be happening. Is there a series of symbols that excel would interpret this way? I also added an example of some of the missing lines in the original post.
– cybera
Nov 23 '18 at 13:37
add a comment |
The txt file is filled with data I've extracted from some json's in this format:
filename|title_of_article
I've made sure that all of them have a title so no empty strings there.
When I copy this information into excel with the text to columns option set to "|" only.
The information is split properly into 2 columns however I end up losing about 1340 lines along the way. How does that happen?
When I do the same but do not set the Text to column options beforehand I copy everything to excel. I lose no lines.
Where does this problem come from?
I ran a vlookup and here are some of the lines that didn't copy in the first way:
as far as I can see there is nothing special about them.
excel
asked Nov 23 '18 at 13:23
cyberacybera
9612
The txt file is filled with data I've extracted from some json's in this format:
filename|title_of_article
I've made sure that all of them have a title so no empty strings there.
When I copy this information into excel with the text to columns option set to "|" only.
The information is split properly into 2 columns however I end up losing about 1340 lines along the way. How does that happen?
When I do the same but do not set the Text to column options beforehand I copy everything to excel. I lose no lines.
Where does this problem come from?
I ran a vlookup and here are some of the lines that didn't copy in the first way:
as far as I can see there is nothing special about them.
excel
excel
asked Nov 23 '18 at 13:23
cyberacybera
9612
asked Nov 23 '18 at 13:23
cyberacybera
9612
edited Nov 23 '18 at 13:36
cybera
asked Nov 23 '18 at 13:23
cyberacybera
9612
asked Nov 23 '18 at 13:23
cyberacybera
9612
asked Nov 23 '18 at 13:23
cyberacybera
9612
9612
probably the text to columns is generating some extra lines and either replacing the data that is in there (you should get a message when this happens though) or maybe have you go over the limit for an older version of excel? It seems you are not exceeding it, but the limit of rows for excel 2007 is 65536 for instance
– Chrisvdberge
Nov 23 '18 at 13:31
a sample of the data would be helpful. And make sure there are no | present in the data on which you don't want to split
– Chrisvdberge
Nov 23 '18 at 13:31
@Chrisvdberge I've made sure there are no | in the data as if there were they would push information into next columns, but there is nothing in them. Also I'm using office365 so its a pretty recent version.
– cybera
Nov 23 '18 at 13:33
@Chrisvdberge I'm intrigued by the possibility of excel overwriting lines, but I can't figure out how that could be happening. Is there a series of symbols that excel would interpret this way? I also added an example of some of the missing lines in the original post.
– cybera
Nov 23 '18 at 13:37
add a comment |
probably the text to columns is generating some extra lines and either replacing the data that is in there (you should get a message when this happens though) or maybe have you go over the limit for an older version of excel? It seems you are not exceeding it, but the limit of rows for excel 2007 is 65536 for instance
– Chrisvdberge
Nov 23 '18 at 13:31
a sample of the data would be helpful. And make sure there are no | present in the data on which you don't want to split
– Chrisvdberge
Nov 23 '18 at 13:31
@Chrisvdberge I've made sure there are no | in the data as if there were they would push information into next columns, but there is nothing in them. Also I'm using office365 so its a pretty recent version.
– cybera
Nov 23 '18 at 13:33
@Chrisvdberge I'm intrigued by the possibility of excel overwriting lines, but I can't figure out how that could be happening. Is there a series of symbols that excel would interpret this way? I also added an example of some of the missing lines in the original post.
– cybera
Nov 23 '18 at 13:37
probably the text to columns is generating some extra lines and either replacing the data that is in there (you should get a message when this happens though) or maybe have you go over the limit for an older version of excel? It seems you are not exceeding it, but the limit of rows for excel 2007 is 65536 for instance
– Chrisvdberge
Nov 23 '18 at 13:31
probably the text to columns is generating some extra lines and either replacing the data that is in there (you should get a message when this happens though) or maybe have you go over the limit for an older version of excel? It seems you are not exceeding it, but the limit of rows for excel 2007 is 65536 for instance
– Chrisvdberge
Nov 23 '18 at 13:31
a sample of the data would be helpful. And make sure there are no | present in the data on which you don't want to split
– Chrisvdberge
Nov 23 '18 at 13:31
a sample of the data would be helpful. And make sure there are no | present in the data on which you don't want to split
– Chrisvdberge
Nov 23 '18 at 13:31
@Chrisvdberge I've made sure there are no | in the data as if there were they would push information into next columns, but there is nothing in them. Also I'm using office365 so its a pretty recent version.
– cybera
Nov 23 '18 at 13:33
@Chrisvdberge I've made sure there are no | in the data as if there were they would push information into next columns, but there is nothing in them. Also I'm using office365 so its a pretty recent version.
– cybera
Nov 23 '18 at 13:33
@Chrisvdberge I'm intrigued by the possibility of excel overwriting lines, but I can't figure out how that could be happening. Is there a series of symbols that excel would interpret this way? I also added an example of some of the missing lines in the original post.
– cybera
Nov 23 '18 at 13:37
@Chrisvdberge I'm intrigued by the possibility of excel overwriting lines, but I can't figure out how that could be happening. Is there a series of symbols that excel would interpret this way? I also added an example of some of the missing lines in the original post.
– cybera
Nov 23 '18 at 13:37
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53447521%2fcoping-from-txt-file-to-excel-i-lose-about-1340-lines-from-61787-where-do-they%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53447521%2fcoping-from-txt-file-to-excel-i-lose-about-1340-lines-from-61787-where-do-they%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
probably the text to columns is generating some extra lines and either replacing the data that is in there (you should get a message when this happens though) or maybe have you go over the limit for an older version of excel? It seems you are not exceeding it, but the limit of rows for excel 2007 is 65536 for instance
– Chrisvdberge
Nov 23 '18 at 13:31
a sample of the data would be helpful. And make sure there are no | present in the data on which you don't want to split
– Chrisvdberge
Nov 23 '18 at 13:31
@Chrisvdberge I've made sure there are no | in the data as if there were they would push information into next columns, but there is nothing in them. Also I'm using office365 so its a pretty recent version.
– cybera
Nov 23 '18 at 13:33
@Chrisvdberge I'm intrigued by the possibility of excel overwriting lines, but I can't figure out how that could be happening. Is there a series of symbols that excel would interpret this way? I also added an example of some of the missing lines in the original post.
– cybera
Nov 23 '18 at 13:37