This is a test version of Biostars. For the public version, visit https://www.biostars.org.
Text mining in Perl

Hi everyone,

I would like to know how can I take a line from an excel document and write into a different excel document by using Perl?

Thanks in advance :)

perl text mining

May be this question shouldn't be here. Even more There is no link between your Post and the tags.

What do you suggest, which tags should I put?

The easiest would be: don't use excel ever (for data analysis). You could save it as a tab delimited text file and use perl on that.

Thank you for your suggestion, I converted them. I want to select the line that has the typed word in it and take the whole line. After taking the line, I want to write it into a different text line. Is there a way to do it i Perl?

I have no perl experience, but this sounds like a quite common application :p (I guess you could also use the gnu tool grep)

I'll look at that, I know it is a bit common and easy, but I have no perl experience :) thank you

If you are trying to delete this thread, that's bad practice. It can stay like this (answered).

I'm trying to delete it because this question has no relation to bioinformatics. It also reads like a homework question "I want to do this task in perl but I have no experience in perl" - why perl if it's not homework?

I see. I'm not sure whether deleting is appropriate but understand your reasons.

Have a see on cpan for an excel parser; this probably isn't the venue for your request

I'll check that, thank you

0 answers

No answers yet.

Log in to answer this question.