rnk files receiving persistent error message

KJ

unread,

Jul 14, 2023, 2:49:54 PM7/14/23

to webgestalt

Exported my data from Excel in a .txt tab separated values file, then renamed in Notepad to remove the .txt and change it to .rnk. File appears fine and is recognized as an RNK file by my OS, but it's still being rejected with the error message "ERROR: The format of the uploaded ranked list is incorrect. Please make sure the file contains two column of gene IDs and scores."

Any idea why?

cxxxpxxxallrank.rnk

Yuxing Liao

unread,

Jul 14, 2023, 6:00:16 PM7/14/23

to KJ, webgestalt

Hi,

You have several values that are not converted correctly by Excel as "#NUM!". Deleting them from the file made it work.

Yuxing

On Fri, Jul 14, 2023 at 1:49 PM KJ <k.foster...@gmail.com> wrote:

Exported my data from Excel in a .txt tab separated values file, then renamed in Notepad to remove the .txt and change it to .rnk. File appears fine and is recognized as an RNK file by my OS, but it's still being rejected with the error message "ERROR: The format of the uploaded ranked list is incorrect. Please make sure the file contains two column of gene IDs and scores."

Any idea why?

--
You received this message because you are subscribed to the Google Groups "webgestalt" group.
To unsubscribe from this group and stop receiving emails from it, send an email to webgestalt+...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/webgestalt/3b01ca55-cfc7-4738-bb4f-d7a2680b12cfn%40googlegroups.com.

KJ

unread,

Jul 14, 2023, 6:50:15 PM7/14/23

to webgestalt

Thank you so much, Yuxing! I can't believe I missed them. Appreciate your help!

Reply all

Reply to author

Forward