Extracting word from a doc file, and turn it into multiple records
Hi guys I am currently stuck on a script that I would like to create for my task organizing database. and here is what I want to acheive:
Input: A word document containing multiple objects, with a comma seperating them.
Burger, fries, apple, orange juice, coke
Output: I would like to create a script that can detect when a comma appears and create a new record with the word after that comma.
Record 1: Burger
Record 2: Fries
Record 3: Apple
Record 4: Orange juice
Record 5: Coke
The problem is that I don't know what keyword should I search in the net to find the correct tutorial to solve this problem. I tried "extracting" "parsing" and something to do with leftWord and rightWord and still no result. Any help will be greatly appreciated.
Thank you in advance for helping.