Skip to Content

Isolating values from a string

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Feb 09, 2017 at 10:29 AM

    try this formula.

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

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 09, 2017 at 01:31 PM

    use this formula.

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

    Add comment
    10|10000 characters needed characters exceeded