Entering edit mode
3.2 years ago
fec2
▴
50
Hi,
I run an analysis and the software replaced the bacteria name with codes, and I have txt file as below:
Order Original Name Code
1 Allostreptomyces_psammosilenae_DSM_42178 S1_f1
2 Embleya_hyalina_NBRC_13850 S2_f2
3 Embleya_scabrispora_DSM_41855 S3_f3
Because the analysis involved few hundreds bacteria, it would be difficult to replace it one by one in the output txt file. May I know any method for me replace the code back to my bacteria original name? Thanks in advance.
Best regards,
Felix
Hi, the changes.sed file is empty. Anyway I am using Macbook, I have also tried using gawk and gsed but the changes.sed file still empty.
Mac implements sed etc slightly differently. It may also do the same for awk. Try building the pipe up part by part.
I'm afraid that's not enough information for me to be able to tell you why it isn't working
Hi, I generated the changes.sed file using excel and save as .txt file as below:
But when run the second command I got error as below:
Any suggestion?
Make sure you are using
GNU sed
as distributed incoreutils
.I have changed my command to gsed, but result remain the same.
It may be due to you producing the file with Excel. How did you export the file? Any invisible characters will break this.
I saved the file as tab delimitated text file.
OK, so how did you make the file you showed above? did you use the
sed
commands I gave you on the tab-separated file?Sorry, I don't know why the command is not working on my side. But still, thanks for your sed command, I manually run all the sed command one by one using && in the terminal.