Skip to Content
0

Isolating values from a string

Feb 09, 2017 at 09:43 AM

22

avatar image

Hi Experts,

I am using Webi in SAP BusinessObjects Business Intelligence 4.1 SP 7.

I am faced with the following challenge.
In one of the fields is a combination of the following values:

1234567
INM87654321

or

INM87654321
1234567

or

INM87654321

I am just interested in displaying the value beginning with INM.
How can I isolate this value and display just this value?

TIA,
Henning

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

AMIT KUMAR
Feb 09, 2017 at 10:29 AM
0

try this formula.

=If(Match([String];"INM*")) Then [String]

Show 3 Share
10 |10000 characters needed characters left characters exceeded

Hi Amit,

this formula filters for all fields, that contain INM - this works perfectly, but still returns the values, that I do not need - e.g. 1234567.

The single values in each field are seperated by a newline.As I do just need the value starting with INM, I need to get rid of the other one.
Are there regular expressions available within Webi, that I can use?

0

share sample values format? 1234567 INM87654321 or 1234567INM87654321

How exactly values are?

0

1234567
INM87654321

OR

INM87654321
1234567

0
AMIT KUMAR
Feb 09, 2017 at 01:31 PM
0

use this formula.

=If(Left([String];1)="I") Then Substr([String];1;Pos([String];" ")-1) Else Substr([String];Pos([String];"INM");Length([String]))


untitled.png (13.0 kB)
Share
10 |10000 characters needed characters left characters exceeded