How could I easily expand a list of numbers with hyphens replacing repeated parts?
I used grep (online tool) to extract a list of data where repeated parts are sometimes substituted with hyphens (-o flag).
RegEx used was: [0-9]{8}(, -[0-9]*)*|[0-9]{8}
Sample data below:
33520470
33520850, -60, -70, -80, -90
25453810
13340820
61040146, -55
60819060, -79
60819088
And my desired output would be:
33520470
33520850
33520860
33520870
33520880
33520890
25453810
13340820
61040146
61040155
60819060
60819079
60819088
Could this be done with grep? If not, could you suggest any unix or other tools to achieve this result? I was thinking sed or awk.
Thank you in advance!
awk sed grep
New contributor
add a comment |
I used grep (online tool) to extract a list of data where repeated parts are sometimes substituted with hyphens (-o flag).
RegEx used was: [0-9]{8}(, -[0-9]*)*|[0-9]{8}
Sample data below:
33520470
33520850, -60, -70, -80, -90
25453810
13340820
61040146, -55
60819060, -79
60819088
And my desired output would be:
33520470
33520850
33520860
33520870
33520880
33520890
25453810
13340820
61040146
61040155
60819060
60819079
60819088
Could this be done with grep? If not, could you suggest any unix or other tools to achieve this result? I was thinking sed or awk.
Thank you in advance!
awk sed grep
New contributor
You can't use grep for that. awk will work, but you will need a small program to do it.
– RalfFriedl
12 mins ago
add a comment |
I used grep (online tool) to extract a list of data where repeated parts are sometimes substituted with hyphens (-o flag).
RegEx used was: [0-9]{8}(, -[0-9]*)*|[0-9]{8}
Sample data below:
33520470
33520850, -60, -70, -80, -90
25453810
13340820
61040146, -55
60819060, -79
60819088
And my desired output would be:
33520470
33520850
33520860
33520870
33520880
33520890
25453810
13340820
61040146
61040155
60819060
60819079
60819088
Could this be done with grep? If not, could you suggest any unix or other tools to achieve this result? I was thinking sed or awk.
Thank you in advance!
awk sed grep
New contributor
I used grep (online tool) to extract a list of data where repeated parts are sometimes substituted with hyphens (-o flag).
RegEx used was: [0-9]{8}(, -[0-9]*)*|[0-9]{8}
Sample data below:
33520470
33520850, -60, -70, -80, -90
25453810
13340820
61040146, -55
60819060, -79
60819088
And my desired output would be:
33520470
33520850
33520860
33520870
33520880
33520890
25453810
13340820
61040146
61040155
60819060
60819079
60819088
Could this be done with grep? If not, could you suggest any unix or other tools to achieve this result? I was thinking sed or awk.
Thank you in advance!
awk sed grep
awk sed grep
New contributor
New contributor
edited 3 mins ago
Sigmund Freud
New contributor
asked 19 mins ago
Sigmund FreudSigmund Freud
1
1
New contributor
New contributor
You can't use grep for that. awk will work, but you will need a small program to do it.
– RalfFriedl
12 mins ago
add a comment |
You can't use grep for that. awk will work, but you will need a small program to do it.
– RalfFriedl
12 mins ago
You can't use grep for that. awk will work, but you will need a small program to do it.
– RalfFriedl
12 mins ago
You can't use grep for that. awk will work, but you will need a small program to do it.
– RalfFriedl
12 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
});
}
});
Sigmund Freud is a new contributor. Be nice, and check out our Code of Conduct.
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%2f498538%2fhow-could-i-easily-expand-a-list-of-numbers-with-hyphens-replacing-repeated-part%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
Sigmund Freud is a new contributor. Be nice, and check out our Code of Conduct.
Sigmund Freud is a new contributor. Be nice, and check out our Code of Conduct.
Sigmund Freud is a new contributor. Be nice, and check out our Code of Conduct.
Sigmund Freud is a new contributor. Be nice, and check out our Code of Conduct.
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%2f498538%2fhow-could-i-easily-expand-a-list-of-numbers-with-hyphens-replacing-repeated-part%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
You can't use grep for that. awk will work, but you will need a small program to do it.
– RalfFriedl
12 mins ago