Current Events > If any tech savvy CEmen can help me figure this out, I will Venmo you $100

(+) Yeah! (+)

I have a flash card program called Anki. The way each card is currently formatted, they actually have five different questions, with the five answers on the reverse.

Example:

"> Question 1
> Question 2
> Question 3
> Question 4
> Question 5

> Answer 1
> Answer 2
> Answer 3
> Answer 4
> Answer 5"

However, I don't want five per card. I want one question per card. And before you reply "Just copy and paste into separate cards or retype new ones," there are so many cards saved it will literally take me months to do this raw.

Now, Anki allows you to export and import files. So I can, for instance, export the entire deck into a program like Notepad.

In Notepad, a single line can be imported into Anki as a card. So from Notepad, "Question [tab] Answer" would automatically be converted into an index card when imported into Anki.

The problem is, when I export the Anki deck into Notepad, each line consists of five questions followed by the five related answers. I can't easily format it to be imported into Anki. I would have to manually separate the lines and append the answers, which as I said will literally take me months.

MY IDEA:

The only way I see this being feasible is to somehow separate the questions from the answers all in one go, have the questions as a separate text document, the answers as another, and then splice them together, where each individual answer line is appended to each individual question line, in order, at which point I can import to Anki and be done.

But I can't seem to figure out how to do this. I do have Notepad++ if it matters, and any suggestions besides what I've outlined will be most appreciated.

If anyone here can provide me with a solution, I promise I will Venmo you $100 because you will have saved me a TON of time.

Reboot it

---

Are the questions all separated by question marks?

If so, just pop it into excel and deliminate by question mark and that should work. Then pop it back into note if you can't immediately just go back into that program from excel

Edit: as I reread. Deliminate by tab should work better

---

Jiek_Fafn posted...

Are the questions all separated by question marks?

If so, just pop it into excel and deliminate by question mark and that should work. Then pop it back into note if you can't immediately just go back into that program from excel

Unfortunately, no question marks. I have them written out as statements like on Jeopardy.

When I export into Notepad, each individual question (even on the same card) is separated by "gt;"). I used Replace All to change those to a vertical bar symbol, then tried the delimit option on Excel but it didn't seem to work for some reason. It was removing some of the data.

If u send me the files (or an example of them) I can write a python script to process them for you

---

Write a program to read the questions and answers into arrays then write the right format to a new file
---

TeaMilk posted...

If u send me the files (or an example of them) I can write a python script to process them for you

Can you message me your email?

Josiah_Is_Back posted...

Unfortunately, no question marks. I have them written out as statements like on Jeopardy.

When I export into Notepad, each individual question (even on the same card) is separated by "gt;"). I used Replace All to change those to a vertical bar symbol, then tried the delimit option on Excel but it didn't seem to work for some reason. It was removing some of the data.

Bleh
You can probably write a formula to do it. Either way, I'd try excel or just let TeaMilk do it

---