So the 4 digits in code is easy, using the right function. The receiver code is harder however, since it's in between multiple characters. I used the MID function in Excel but that doesn't work in Business Objects Web Intelligence sadly..
Hi there, I'm very new to Business Objects Web Intelligence and I have the following question, that wasn't specifically answered in other questions:
I have a memo field that looks like : "####: ### Receiver: 12345 Code: 0001"
My question is, how do I extract 12345 and 0001 out of the memo...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.