RossWindows
Que?
- Local time
- Today, 03:25
- Joined
- Feb 25, 2008
- Messages
- 410
I have a database that I do not own, but I need to run a report on.
One of the columns is called TransactionNote and contains text like this;
"Order XXX released from PAY TYPE" and
"Order XXXXX released from PRODUCT INFORMAT"
What I need to do is split out the text in caps.
Then we would have;
"PAY TYPE"
"PRODUCT INFORMAT"
Unfortunately, these values are of variable length so I'm at a loss.
Oh, and I need this done within a query if possible.
Trust me, if this was my database I would have kept these split out in the first place.
Any ideas?
Maybe, is there a way to say "take everything after the fourth space"?
One of the columns is called TransactionNote and contains text like this;
"Order XXX released from PAY TYPE" and
"Order XXXXX released from PRODUCT INFORMAT"
What I need to do is split out the text in caps.
Then we would have;
"PAY TYPE"
"PRODUCT INFORMAT"
Unfortunately, these values are of variable length so I'm at a loss.
Oh, and I need this done within a query if possible.
Trust me, if this was my database I would have kept these split out in the first place.
Any ideas?
Maybe, is there a way to say "take everything after the fourth space"?
Last edited: