Field separteur part of a column - incorrect parsing unix
Clash Royale CLAN TAG#URR8PPP
up vote
0
down vote
favorite
I want to do a check in a file before processing it and I would like to check the number of columns. The problem is that I have delimitator also in the text of some fields and because of that I cannot parse correctly and I receive more columns.
Eg:
~new file: 12345~,~125.5~,,,~ example (45), case (20)~,,
7 columns
The problem is the comma inside ~example (45), case (20)~
I tried to replace delimiter ',' with ';' using sed but I had to do more than one iteration.
I would like a general rule that will match multiple cases with a more optimal approach.
Thanks!
awk sed replace
asked 2 mins ago
Mathew Linton
1
New contributor
Mathew Linton 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 |Â
up vote
0
down vote
favorite
I want to do a check in a file before processing it and I would like to check the number of columns. The problem is that I have delimitator also in the text of some fields and because of that I cannot parse correctly and I receive more columns.
Eg:
~new file: 12345~,~125.5~,,,~ example (45), case (20)~,,
7 columns
The problem is the comma inside ~example (45), case (20)~
I tried to replace delimiter ',' with ';' using sed but I had to do more than one iteration.
I would like a general rule that will match multiple cases with a more optimal approach.
Thanks!
awk sed replace
asked 2 mins ago
Mathew Linton
1
New contributor
Mathew Linton 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 |Â
up vote
0
down vote
favorite
up vote
0
down vote
favorite
I want to do a check in a file before processing it and I would like to check the number of columns. The problem is that I have delimitator also in the text of some fields and because of that I cannot parse correctly and I receive more columns.
Eg:
~new file: 12345~,~125.5~,,,~ example (45), case (20)~,,
7 columns
The problem is the comma inside ~example (45), case (20)~
I tried to replace delimiter ',' with ';' using sed but I had to do more than one iteration.
I would like a general rule that will match multiple cases with a more optimal approach.
Thanks!
awk sed replace
asked 2 mins ago
Mathew Linton
1
New contributor
Mathew Linton is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
I want to do a check in a file before processing it and I would like to check the number of columns. The problem is that I have delimitator also in the text of some fields and because of that I cannot parse correctly and I receive more columns.
Eg:
~new file: 12345~,~125.5~,,,~ example (45), case (20)~,,
7 columns
The problem is the comma inside ~example (45), case (20)~
I tried to replace delimiter ',' with ';' using sed but I had to do more than one iteration.
I would like a general rule that will match multiple cases with a more optimal approach.
Thanks!
awk sed replace
awk sed replace
asked 2 mins ago
Mathew Linton
1
New contributor
Mathew Linton is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked 2 mins ago
Mathew Linton
1
New contributor
Mathew Linton is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked 2 mins ago
Mathew Linton
1
New contributor
Mathew Linton is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked 2 mins ago
Mathew Linton
1
asked 2 mins ago
Mathew Linton
1
1
New contributor
Mathew Linton is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
New contributor
Mathew Linton is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
Mathew Linton 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 |Â
add a comment |Â
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
Mathew Linton is a new contributor. Be nice, and check out our Code of Conduct.
Mathew Linton is a new contributor. Be nice, and check out our Code of Conduct.
Mathew Linton is a new contributor. Be nice, and check out our Code of Conduct.
Mathew Linton 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
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2funix.stackexchange.com%2fquestions%2f474609%2ffield-separteur-part-of-a-column-incorrect-parsing-unix%23new-answer', 'question_page');
);
Post as a guest
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
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
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
