User talk:Kkroon

Verified Editions

That sounds good Kkroon. What is this feature on your spreadsheet program - concaterate? - what does it mean and what does it do? Bobnotts 04:41, 4 October 2006 (PDT)

Kurtis replies: CONCATENATE takes all its parameters and chains them together in the order given. The word comes from (Vulgar?) Latin concatenare: con "together" + catena "chain" + verbal ending. So, "to chain together".

Here's how I use it: in my spreadsheet program, I list page titles in column A, and CPDL IDs in column B. In column C, I type:

=CONCATENATE("[[",A2,"|",B2,"]]<br>")

For a more concrete example, say cell A2 contains the text "Margot labourez les vignes (Jacob Arcadelt)", and cell B2 contains "687". The concatenate will string everything together, and writes [[Margot labourez les vignes (Jacob Arcadelt)|687]]<br> in cell C2. I copy this from my spreadsheet and paste it into the page I'm editing, and the Wiki does the rest.

I don't actually retype the function each time: instead, I use my spreadsheet's fill function (Edit > Fill ... > Down).

I hope this explanation helps ... and I can send you my spreadsheet if you want.

Kkroon, 2006-10-21

Verified Editions

Oh and by the way, at least some of the editions that you said you couldn't find are on CPDL. Try typing #602 into the search box. Bobnotts 05:12, 4 October 2006 (PDT)

I didn't say that this method was flawless. I should have said "it's better than stabbing blindly in the dark". Kkroon 21 October