Inner_join not working though column headers exist and data overlap

[IdoBar]

Inner_join not working though column headers exist and data overlap (see attached csv_files.zip)

See the following outputs:

>cat Dingo_BioSamples_table.csv
Acc,BioSample,SampleName,**SRS**,Breed
3366709,SAMN03366709,RKW13760,SRS1025425,Dingo
8873190,SAMN08873190,NewGuineaSingingDog01,SRS3259288,New Guinea Singing Dog
4851104,SAMN04851104,1756,SRS1397565,Village Dog Sub-Saharan Africa
4851101,SAMN04851101,PT49,SRS1397563,Village Dog
3366710,SAMN03366710,RKW13759,SRS1025423,Israeli wolf
> head Canine_SRA_table.csv
SRA,SRX,SRP,**SRS**,SRR
SRA699439,SRX4041934,SRP144493,SRS3259403,SRR7120307
SRA699439,SRX4041933,SRP144493,SRS3259404,SRR7120306
SRA699439,SRX4041932,SRP144493,SRS3259402,SRR7120305
SRA699439,SRX4041931,SRP144493,SRS3259401,SRR7120304
SRA699439,SRX4041930,SRP144493,SRS3259400,SRR7120303
SRA699439,SRX4041929,SRP144493,SRS3259399,SRR7120302
SRA699439,SRX4041928,SRP144493,SRS3259398,SRR7120301
SRA699439,SRX4041927,SRP144493,SRS3259397,SRR7120300
SRA699439,SRX4041926,SRP144493,SRS3259396,SRR7120299
> cat Dingo_BioSamples_table.csv | dplyr inner_join Canine_SRA_table.csv
Warning message:
package ‘dplyr’ was built under R version 4.0.3
/30days/ibar/dplyr-cli-ae532e85493b.rds

There's definitely overlap in the values of SRS in the data, based upon the join should be made.

 grep SRS1397565 Canine_SRA_table.csv
SRA699439,SRX4036182,SRP144493,SRS1397565,SRR7107945

[coolbutuseless]

I don't have bandwidth to look into this. PRs welcome.