Repository revision
20:fbf99087e067

Repository 'text_processing'
hg clone https://toolshed.g2.bx.psu.edu/repos/bgruening/text_processing

Replace Text tool metadata
Miscellaneous
Replace Text
in a specific column
tp_replace_in_column
toolshed.g2.bx.psu.edu/repos/bgruening/text_processing/tp_replace_in_column/9.3+galaxy1
9.3+galaxy1
awk --version | head -n 1
True
Version lineage of this tool (guids ordered most recent to oldest)
toolshed.g2.bx.psu.edu/repos/bgruening/text_processing/tp_replace_in_column/9.3+galaxy1 (this tool)
toolshed.g2.bx.psu.edu/repos/bgruening/text_processing/tp_replace_in_column/9.3+galaxy0
toolshed.g2.bx.psu.edu/repos/bgruening/text_processing/tp_replace_in_column/1.1.3
toolshed.g2.bx.psu.edu/repos/bgruening/text_processing/tp_replace_in_column/1.1.2
toolshed.g2.bx.psu.edu/repos/bgruening/text_processing/tp_replace_in_column/1.0.0
tp_replace_in_column
Requirements (dependencies defined in the <requirements> tag set)
name version type
gawk 5.3.0 package
Additional information about this tool
awk
            -v OFS="\t"
            -v FS="\t"
            --re-interval
            --sandbox 
            '{ 
            #for $replacement in $replacements:
                \$$replacement.column = gensub( /$replacement.find_pattern/, "$replacement.replace_pattern", "g", \$$replacement.column ) ;
            #end for
            print \$0 ; }'
            '$infile'
        > '$outfile'

    
None
False
Functional tests
name inputs outputs required files
Test-1 infile: replace_text_in_column1.txt
replacements_0|column: 4
replacements_0|find_pattern: .+_(R.)
replacements_0|replace_pattern: \\1
name: value
replace_text_in_column1.txt
value
Test-2 infile: replace_text_in_column1.txt
replacements_0|column: 1
replacements_0|find_pattern: [a-z]{2}([a-z])
replacements_0|replace_pattern: \\1
replacements_1|column: 4
replacements_1|find_pattern: .+_(R.)
replacements_1|replace_pattern: \\1
name: value
replace_text_in_column1.txt
value