User talk:Kkroon

From ChoralWiki
Revision as of 02:19, 22 October 2006 by Kkroon (talk | contribs) (Clarified how concatenate works (requires that you specify additional text))
Jump to navigation Jump to search

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 function strings everything together with the pertinent wiki markup ([[ | ]]), 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