Hi all,

I'm a fairly new beginner with shell programming and python programming. I have a mac (mountain lion OS 10.8.2) and use the terminal for programming. I'm trying to use the unix to easily organize some language data that I am working with. Basically I have to word lists, that I need to combine into one.

Word list 1 (Chinese):

Code:

你们
好
家明　
你
好　

Word List 2 (Chinese pinyin with numerical tone mark):

Code:

ni3men
hao3 
Jia1ming2 
ni3
hao3

My desired outcome would combing the numbers from the second wordlist with the characters in the first word list to look like this:

Code:

你,3,们,0
好,3 
家,1,明,2 
你,3
好,3

It is important that the format is "character," comma, "number"

So far I have done the following with wordlist two:

Code:

tr '[:alpha:]' ',' <WordList2.txt | tr -s ',' >WordList2B.txt 
paste WordList1.txt Wordlist2B.txt > CombinedWordList.txt
tr -d '\t' <CombinedWordList.txt | tr -s '[:space:]' >CombinedWordList2.txt

My current output document looks like this:

Code:

你们,3,
好,3
家明,1,2 
你,3
好,3

It is 'almost' there - but the first and third need to be further 'integrated' so the format is 'character' comma 'number 'character' comma 'number'. So every single Chinese symbol should be followed by a number. One additional problem, is that some words (such as the second character in the first example
(你们,3,) do not have a corresponding number - in this case I would like it to automatically insert a zero '0' - so the first word would appear "你,3,们,0". So specifically - I need help:
1) formatting the document to appear "character" comma "number", "character" comma "number instead of "character" "character" comma "number" comma "number"
2) Having a zero '0' inserted after the comma when there is not already a number.

Any help or suggestions would be greatly appreciated