file formating using awk Unicorn Meta Zoo #1: Why another podcast? Announcing...
Will I be more secure with my own router behind my ISP's router?
Why isn't everyone flabbergasted about Bran's "gift"?
Why aren't road bicycle wheels tiny?
Is it appropriate to mention a relatable company blog post when you're asked about the company?
Does a Draconic Bloodline sorcerer's doubled proficiency bonus for Charisma checks against dragons apply to all dragon types or only the chosen one?
Why doesn't the university give past final exams' answers?
How to begin with a paragraph in latex
How long can a nation maintain a technological edge over the rest of the world?
Is Bran literally the world's memory?
Where/What are Arya's scars from?
SQL Server placement of master database files vs resource database files
Test if all elements of a Foldable are the same
Is there a possibility to generate a list dynamically in Latex?
What is the ongoing value of the Kanban board to the developers as opposed to management
What to do with someone that cheated their way though university and a PhD program?
Retract an already submitted Recommendation Letter (written for an undergrad student)
When speaking, how do you change your mind mid-sentence?
Why did Israel vote against lifting the American embargo on Cuba?
What is the purpose of the side handle on a hand ("eggbeater") drill?
How can I wire a 9-position switch so that each position turns on one more LED than the one before?
Philosophers who were composers?
Suing a Police Officer Instead of the Police Department
`FindRoot [ ]`::jsing: Encountered a singular Jacobian at a point...WHY
How would it unbalance gameplay to rule that Weapon Master allows for picking a fighting style?
file formating using awk
Unicorn Meta Zoo #1: Why another podcast?
Announcing the arrival of Valued Associate #679: Cesar Manara
2019 Community Moderator Election Results
Why I closed the “Why is Kali so hard” questionHow to use awk or sed to convert csv diffs into more readable formatRearrange the file contentawk array using number as value did not workHow to repeat a sequence of numbers in a column using awk commandHow to apply awk command on all fields except a few specific rowsRemove specific column if exists in CSV fileUNIX - command to split the file into multiple files with all the lines for every 3 unique values in a columnConvert one (long) column into multiple (short) columns of unequal lengthsAWK different resultprocessing multiple files with awk problem
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ margin-bottom:0;
}
my input file contain data as below format
1503668542862176 manager=10001|Bounced=999|Analyst=10004|Business Analyst=10005|Programmer=10003
1552024948590636 manager=10001|Bounced=999|Analyst=10004
1551728916565460 Bounced=999|Analyst=10004
1553617087089790 Analyst=10004
1538058487418963 manager=10001|Architect=10002|Analyst=10004
i have to convert second column as every key value should be double quoted and | should be replaced with , as below using awk .
1503668542862176 "manager"="10001","Bounced"="999","Analyst"="10004","Business Analyst"="10005","Programmer"="10003"
1552024948590636 "manager=10001","Bounced"="999","Analyst"="10004"
1551728916565460 "Bounced"="999","Analyst"="10004"
1553617087089790 "Analyst"="10004"
1538058487418963 "manager"="10001","Architect"="10002","Analyst"="10004"
can some one help me here
awk
edited 4 hours ago
Nasir Riley
3,1222410
asked 4 hours ago
SandeepSandeep
1
New contributor
Sandeep is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
my input file contain data as below format
1503668542862176 manager=10001|Bounced=999|Analyst=10004|Business Analyst=10005|Programmer=10003
1552024948590636 manager=10001|Bounced=999|Analyst=10004
1551728916565460 Bounced=999|Analyst=10004
1553617087089790 Analyst=10004
1538058487418963 manager=10001|Architect=10002|Analyst=10004
i have to convert second column as every key value should be double quoted and | should be replaced with , as below using awk .
1503668542862176 "manager"="10001","Bounced"="999","Analyst"="10004","Business Analyst"="10005","Programmer"="10003"
1552024948590636 "manager=10001","Bounced"="999","Analyst"="10004"
1551728916565460 "Bounced"="999","Analyst"="10004"
1553617087089790 "Analyst"="10004"
1538058487418963 "manager"="10001","Architect"="10002","Analyst"="10004"
can some one help me here
awk
edited 4 hours ago
Nasir Riley
3,1222410
asked 4 hours ago
SandeepSandeep
1
New contributor
Sandeep is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
Can you clarify what constitutes a “key value”? Is “Apollo13” one value or two? How about “Maroon 5”? How about “read-only”, “read/write”, “I.B.M.” and “Unix & Linux”?
– G-Man
3 hours ago
add a comment |
my input file contain data as below format
1503668542862176 manager=10001|Bounced=999|Analyst=10004|Business Analyst=10005|Programmer=10003
1552024948590636 manager=10001|Bounced=999|Analyst=10004
1551728916565460 Bounced=999|Analyst=10004
1553617087089790 Analyst=10004
1538058487418963 manager=10001|Architect=10002|Analyst=10004
i have to convert second column as every key value should be double quoted and | should be replaced with , as below using awk .
1503668542862176 "manager"="10001","Bounced"="999","Analyst"="10004","Business Analyst"="10005","Programmer"="10003"
1552024948590636 "manager=10001","Bounced"="999","Analyst"="10004"
1551728916565460 "Bounced"="999","Analyst"="10004"
1553617087089790 "Analyst"="10004"
1538058487418963 "manager"="10001","Architect"="10002","Analyst"="10004"
can some one help me here
awk
edited 4 hours ago
Nasir Riley
3,1222410
asked 4 hours ago
SandeepSandeep
1
New contributor
Sandeep is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
my input file contain data as below format
1503668542862176 manager=10001|Bounced=999|Analyst=10004|Business Analyst=10005|Programmer=10003
1552024948590636 manager=10001|Bounced=999|Analyst=10004
1551728916565460 Bounced=999|Analyst=10004
1553617087089790 Analyst=10004
1538058487418963 manager=10001|Architect=10002|Analyst=10004
i have to convert second column as every key value should be double quoted and | should be replaced with , as below using awk .
1503668542862176 "manager"="10001","Bounced"="999","Analyst"="10004","Business Analyst"="10005","Programmer"="10003"
1552024948590636 "manager=10001","Bounced"="999","Analyst"="10004"
1551728916565460 "Bounced"="999","Analyst"="10004"
1553617087089790 "Analyst"="10004"
1538058487418963 "manager"="10001","Architect"="10002","Analyst"="10004"
can some one help me here
awk
awk
edited 4 hours ago
Nasir Riley
3,1222410
asked 4 hours ago
SandeepSandeep
1
New contributor
Sandeep is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
edited 4 hours ago
Nasir Riley
3,1222410
asked 4 hours ago
SandeepSandeep
1
New contributor
Sandeep is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
edited 4 hours ago
Nasir Riley
3,1222410
edited 4 hours ago
Nasir Riley
3,1222410
edited 4 hours ago
Nasir Riley
3,1222410
3,1222410
asked 4 hours ago
SandeepSandeep
1
New contributor
Sandeep is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked 4 hours ago
SandeepSandeep
1
asked 4 hours ago
SandeepSandeep
1
1
New contributor
Sandeep is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
New contributor
Sandeep is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
Sandeep is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
Can you clarify what constitutes a “key value”? Is “Apollo13” one value or two? How about “Maroon 5”? How about “read-only”, “read/write”, “I.B.M.” and “Unix & Linux”?
– G-Man
3 hours ago
add a comment |
Can you clarify what constitutes a “key value”? Is “Apollo13” one value or two? How about “Maroon 5”? How about “read-only”, “read/write”, “I.B.M.” and “Unix & Linux”?
– G-Man
3 hours ago
Can you clarify what constitutes a “key value”? Is “Apollo13” one value or two? How about “Maroon 5”? How about “read-only”, “read/write”, “I.B.M.” and “Unix & Linux”?
– G-Man
3 hours ago
Can you clarify what constitutes a “key value”? Is “Apollo13” one value or two? How about “Maroon 5”? How about “read-only”, “read/write”, “I.B.M.” and “Unix & Linux”?
– G-Man
3 hours 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
});
}
});
Sandeep 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%2f514139%2ffile-formating-using-awk%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
Sandeep is a new contributor. Be nice, and check out our Code of Conduct.
Sandeep is a new contributor. Be nice, and check out our Code of Conduct.
Sandeep is a new contributor. Be nice, and check out our Code of Conduct.
Sandeep 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%2f514139%2ffile-formating-using-awk%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
Can you clarify what constitutes a “key value”? Is “Apollo13” one value or two? How about “Maroon 5”? How about “read-only”, “read/write”, “I.B.M.” and “Unix & Linux”?
– G-Man
3 hours ago