I have a text tile containing strings of text in the following format:
>ATIEA01TF
GTTCTTAATTACAACTGCCAAAAATA
GTTGACCGGA
GTTGTGTTCT
TTTTTTTTGT
CGAA
CCGGAGTTGTGTTCAATGTCAATATA
TGTGAACTGT
TGACAAAATT
AGCTTTTTCC
TTTT
>ATIEA04TF
TAAAAATGGTAGCTTCTCTTTCCTTT
CATTCCATCG
CCACCGTTAA
TCCAATCTTC
TCCG
GCGATGGTGGTCGTTCAATCTTCCGG
ACTAATCGCC
GATTCGAAGC
AACTGGAGTG
AGTT
TCACAGGTCAGTGTAAAATCATCCAA
TCTGAATTCT
GTTTCTTTTG
TCTAAATCGA
AATC
TCTGAGTTTTC
>ATIEA06TF
CTTGTTGATAAGTGTGTGAGCATTGG
ACCACAAAAA
GAGGCCTCCA
AGAGCGAGTA
TCGA
CTTAATGGATCGATTCAAGAAAATGC
AATTATGT
... and so on.
I need to import and add this to a table with >ATIEA01TF in one column and the GTTCTTAATTACAACTGCCA... string in another column. Thing it might be doable in VBA, but I am having some problems with figuring out how to work with that format. The length will be maximum 60 characters per line. I also have access to Perl so I have the option to use that too. Anyone know how to do that in VBA or Perl?
Start Free Trial