Going to exact line in CSV without going over all lines?
I have a large CSV file, and I need to go "directly" (one operation) to a specific line of that file (lets say line # 103500). I was initially thinking of doing cat over the file, and reading the stdout in awk and then printing the exact line number based on the index (which is essentially O(N) in worst case).
Then I dug further and figured out this:
sed -n '103500'p filename
Which prints the precise line. However, I am not sure if it really does so in O(1) (or its worst case is still O(N)). Please help. Thanks.
awk sed grep cat
asked 19 mins ago
khankhan
1111
add a comment |
I have a large CSV file, and I need to go "directly" (one operation) to a specific line of that file (lets say line # 103500). I was initially thinking of doing cat over the file, and reading the stdout in awk and then printing the exact line number based on the index (which is essentially O(N) in worst case).
Then I dug further and figured out this:
sed -n '103500'p filename
Which prints the precise line. However, I am not sure if it really does so in O(1) (or its worst case is still O(N)). Please help. Thanks.
awk sed grep cat
asked 19 mins ago
khankhan
1111
Perhaps related: Efficient way to print lines from a massive file using awk, sed, or something else?
– steeldriver
8 mins ago
add a comment |
I have a large CSV file, and I need to go "directly" (one operation) to a specific line of that file (lets say line # 103500). I was initially thinking of doing cat over the file, and reading the stdout in awk and then printing the exact line number based on the index (which is essentially O(N) in worst case).
Then I dug further and figured out this:
sed -n '103500'p filename
Which prints the precise line. However, I am not sure if it really does so in O(1) (or its worst case is still O(N)). Please help. Thanks.
awk sed grep cat
asked 19 mins ago
khankhan
1111
I have a large CSV file, and I need to go "directly" (one operation) to a specific line of that file (lets say line # 103500). I was initially thinking of doing cat over the file, and reading the stdout in awk and then printing the exact line number based on the index (which is essentially O(N) in worst case).
Then I dug further and figured out this:
sed -n '103500'p filename
Which prints the precise line. However, I am not sure if it really does so in O(1) (or its worst case is still O(N)). Please help. Thanks.
awk sed grep cat
awk sed grep cat
asked 19 mins ago
khankhan
1111
asked 19 mins ago
khankhan
1111
asked 19 mins ago
khankhan
1111
asked 19 mins ago
khankhan
1111
asked 19 mins ago
khankhan
1111
1111
Perhaps related: Efficient way to print lines from a massive file using awk, sed, or something else?
– steeldriver
8 mins ago
add a comment |
Perhaps related: Efficient way to print lines from a massive file using awk, sed, or something else?
– steeldriver
8 mins ago
Perhaps related: Efficient way to print lines from a massive file using awk, sed, or something else?
– steeldriver
8 mins ago
Perhaps related: Efficient way to print lines from a massive file using awk, sed, or something else?
– steeldriver
8 mins ago
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "106"
};
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: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
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%2funix.stackexchange.com%2fquestions%2f495673%2fgoing-to-exact-line-in-csv-without-going-over-all-lines%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 Unix & Linux Stack Exchange!
- 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%2funix.stackexchange.com%2fquestions%2f495673%2fgoing-to-exact-line-in-csv-without-going-over-all-lines%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
Perhaps related: Efficient way to print lines from a massive file using awk, sed, or something else?
– steeldriver
8 mins ago