Hello,
I have a database with the following structure:
Headword in a foreign language followed by frequency (delimited with comma) and eventually followed by a list of glosses in English, each gloss delimited with a comma. A small sample is given below
The macro takes ages , since the glosses for a single headword are considerable and also because there are a large number of headwords.
Any way of speeding the process up would be gratefully acknowledged.
Many thanks
I have a database with the following structure:
Headword in a foreign language followed by frequency (delimited with comma) and eventually followed by a list of glosses in English, each gloss delimited with a comma. A small sample is given below
I need a script or a macro to convert these into the following format. The first item from the example is given as a converted item.कुर्यवंशी,4,kuryanshi,kuryavanashi,kuryawanshi,kurywanshi
कुर्रे,2,kurray,kurre
कुलदिपकर,2,kuladipakar,kuladipkar
कुलदीपसिंग,4,kuldeepsing,kuldeepsingh,kuldipsing,kuldipsingh
कुलभूषण,2,kulbhooshan,kulbhushan
कुवरसिंग,4,kuvarsing,kuvarsingh,kuwarsing,kuwarsingh
कुशवाह,3,kushavan,kushawah,kushawaha
कुशवाहा,2,kushavah,kushavaha
कुशाबराव,2,kushabrao,kushabrav
कुशेश्वर,2,kusheshvar,kusheshwar
The macro I have written is too slow and takes a large amount of time. Basically the macro selects the headword. Pastes it onto a next line, chooses the first gloss (deletes it), pastes it onto the headword on line 2, preceded by an equal to sign and carries on till all the glosses on a line are exhausted. The process is repeated till all the headwords are exhausted.कुर्यवंशी,4,
कुर्यवंशी=kuryanshi
कुर्यवंशी=kuryavanashi
कुर्यवंशी=kuryawanshi
कुर्यवंशी=kurywanshi
The macro takes ages , since the glosses for a single headword are considerable and also because there are a large number of headwords.
Any way of speeding the process up would be gratefully acknowledged.
Many thanks