How can I programmitcally get the first word from a string if the format is the following?
Genesis: Chapter: 001
Exodus: Chapter: 001
I only need the first word, for example: Genesis or Exodus etc.
Node.Text is as follows: Genesis: Chapter: 001
Here is the code I'm using, it doesn't work and I've been working with this problem for hours.
a% = Len(Trim(Node.Text))
b% = 1
Do Until a% = 0
If Left$(Node.Text, b%) = ":" Then
Book_ID = Left$(Node.Text, b%)
a% = a% - 1
b% = b% + 1
Hint: I only need the string prior to the first colon.