【Question】
I have a file that looks like this:

>Unc14086

AGAGUUUGAU

>Unc35443

GCACGAGAAA

So, every n (n may vary) lines the next line starts with “>”, that is the beginning of a new block of information.

I have another tab-delimited file:

Unc14086  InformationalTextExample

Unc35443  InformationalTextExampleII

My goal is to parse the second file with information found in lines starting with “>” in the first file. Whenever a matching pair occurs, I want to write “InformationalTextExample” in that line, possibly separated by “_”:

>Unc14086_InformationalTextExample

AGAGUUUGAU

>Unc35443_InformationalTextExampleII

GCACGAGAAA

How would that be possible?

Thank you!

【Answer】

A Perl solution is clear but long. esProc SPL’s loop functions will give you a concise solution. Here’s the SPL script:

See SQL Headaches Therapies - For Loop Operations to learn more use cases of esProc loop functions.