Isolating values from a string

[former_member318041]

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

[amitrathi239]

use this formula.

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

[amitrathi239]

try this formula.

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

[former_member318041]

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?

[amitrathi239]

share sample values format? 1234567 INM87654321 or 1234567INM87654321

How exactly values are?

[former_member318041]

1234567
INM87654321

OR

INM87654321
1234567