AnsweredAssumed Answered

Extracting word from a doc file, and turn it into multiple records

Question asked by SunnyChu on Sep 25, 2014
Latest reply on Sep 29, 2014 by SunnyChu

Title

Extracting word from a doc file, and turn it into multiple records

Post

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.

 

Example input:

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.

 

Example output:

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.

Sunny

Outcomes