Skip to content
View in the app

A better way to browse. Learn more.

Thailand News and Discussion Forum | ASEANNOW

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

Still Working On The Top 300/500/1000 Thai Words One Must Know...

Featured Replies

I've had a post in the wings for a long while and decided to finish it off within the next month (hopefully - it might be more than I'd bargained for).

To do that, I need the top 300 list (at least). And to do that, I need to get some questions answered.

So if any of you programming chaps or chapettes know the answers...

1) On and off I've been collecting Thai vocabulary lists from everywhere, in Thai script from Thai courses, existing lists, etc. They are in a spreadsheet individually as well as in one long list. In Excel, what is the macro for figuring out which words are repeated the most times?

2) I have the conversations, in Thai script, for both Pimsleurs and Assimil. Is there an easy way of extracting the vocabulary from each?

3) This one is still unsolved: Converting .pdb Files To Text, Thai vocabulary lists...

Ta in advance...

I see no quick replies, so I can comment of figuring out in Excel how to count the number of occurances.

I use something like the function (=countif)

See here for more details.

http://en.allexperts.com/q/Excel-1059/Count-duplicates.htm

  • Author

Thank you Artamus. I used excel macros years ago but too many to count.

I'll give that one a try.

1. You probably need VBA for this. Looping through each words in each sheet and creating a new list with with the number of appearance next to each word.

2. What format are they in?

  • Author

VBA? Pimsleurs and Assimil are both in Word docs. The list is excel. I'm now getting rid of duplicates from the same courses (some have words listed two and three times, but with similar meanings).

VBA? Pimsleurs and Assimil are both in Word docs. The list is excel. I'm now getting rid of duplicates from the same courses (some have words listed two and three times, but with similar meanings).

VBA = visual basic for application. Works on all office program.

Extracting Thai vocab from a word document is tricky because there are no space between words in Thai. The only way I can see is to use VBA but still tricky.

Getting rid of duplicates in Excel list can also be done by VBA.

  • Author

The duplicates in the excel list as via colour. Each of the different courses are separated out by colour because I didn't know what process I would need for this and thought better safe than sorry.

The duplicates in the excel list as via colour. Each of the different courses are separated out by colour because I didn't know what process I would need for this and thought better safe than sorry.

Nothing promised but if you can send me the list, I might be able to knock up a few lines of code to get it done.

  • Author

List sent. Ta :)

Create an account or sign in to comment

Recently Browsing 0

  • No registered users viewing this page.

Account

Navigation

Search

Search

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.