Edit - Unix & Linux Stack Exchange

You are not logged in. Your edit will be placed in a queue until it is peer reviewed.

We welcome edits that make the post easier to understand and more valuable for readers. Because community members review edits, please try to make the post substantially better than how you found it, for example, by fixing grammar or adding additional resources and hyperlinks.

Required fields*

Rev

It is working but creating two columns of IDs and 3rd column with first file and 4th column again IDs then File2 and File3.

Anjali Chaudhary
– Anjali Chaudhary

2020-01-02 16:02:59 +00:00
Commented Jan 2, 2020 at 16:02
1) What do you mean saying "column"? There are 2 part of each line: "key " and "the rest", because if we count columns, the line "MYORGANISM_I_05140.t1 Atypical/PIKK/FRAP VALUES to be taken -NA-" has 7 columns? There is nothing specified about "columns" in the task.

Yurko
– Yurko

2020-01-02 16:41:32 +00:00
Commented Jan 2, 2020 at 16:41
2) I created your 3 files and executed the one line command specified above. I printed my output. Is your output different? Can you provide with more details?

Yurko
– Yurko

2020-01-02 16:41:52 +00:00
Commented Jan 2, 2020 at 16:41
It is working on these sample FILES but with my original file, it is not working. May be because my files are having tab delimiter.

Anjali Chaudhary
– Anjali Chaudhary

2020-01-02 17:12:29 +00:00
Commented Jan 2, 2020 at 17:12
I edited both: a) the single line command, 2) version with explanation. The code added is "|sed 's/\t/ /'", it should make files with tab separator working.

Yurko
– Yurko

2020-01-02 17:30:58 +00:00
Commented Jan 2, 2020 at 17:30

Add a comment |

Correct minor typos or mistakes
Clarify meaning without changing it
Add related resources or links
Always respect the author’s intent
Don’t use edits to reply to the author

create code fences with backticks ` or tildes ~
```
like so
```
add language identifier to highlight code
```python
def function(foo):
print(foo)
```
put returns between paragraphs
for linebreak add 2 spaces at end
_italic_ or **bold**
indent code by 4 spaces
backtick escapes `like _so_`
quote by placing > at start of line
to make links (use https whenever possible)

<https://example.com>

[example](https://example.com)

<a href="https://example.com">example</a>

formatting help »
answering help »