GetValue function for non-carriage return key?
Hi, I am currently developing a task organizer that can help me turn my brainstorm work from another software called "workflowy" into actual list of delegatable task for my employees. Here is what I would like to do:
Field 1 - Description
Field 2 - Type
Field 3 - Employee
For the input I will be chunking a huge list of text into a field with each different item seperated by a carriage return.
There are 3 possibility with each item in the input text.
1. brainstorm content #issue
(that means this content is classified as an issue)
2. brainstorm content #task
(that means this content is classified as a task)
3. brainstorm content #task @employee
(that means this content is classified as a task, and it assigned to a specific employee)
What i would like to do is to make a script that can generate a record with description as brainstorm content, then detect the word after # and set it as type, then finally detect the word @ and set the word after it as employee.
The current problem I am facing is that I tried to use GetValue to detect it, but GetValue only detect carriage return so I am having a hard time trying to figure out how to detect the other symbol.
I am guessing this topic is somewhat related to text extraction but I am not sure where to begin, are there any function out there that I could use to detect # and @? or maybe some work around that can do the intended function?
Thanks in advance