How to extract specific word/numbers from a memo? - More comprehensive

[newDaniel]

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? Ideally I would want the 12345 and 0001 in one specific column like: "12345 0001" so only seperated with a space.

Really struggling and found different tutorials that didn't quite match what I needed..

Help would be greatly appreciated!

Kind greetings,

Daniel

 

[newDaniel]

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..

 

[kray4660]

WebI is not Crystal Reports. The equivalent MID function in WebI is substr. There are many experts that can help you on the BOB forum (

https://bobj-board.org/)

with WebI questions. And a function like that probably could be built into the universe depending on the data source.