Can we split up the object by using '-' as delimiter in BO Universe?

[Former Member]

Hi All,

I want to split up the Object by using " - " as delimiter.

but the Object values will be differed.

ABCD-123G-dfge44-uhji78-9887776

ABCD-1K-gdfdo-ijul87-98764234

How to fetch the 2nd pieces for new object and 3rd pieces for another object.

Length of the particular object will be varying .

Regards,

Vicky

[former_member182521]

Hello Vignesh,

Below example could belp you.

--------------------------------------------------------------------------------------------------------------------------------

Postcode = AB12 3DE

Outbound Postcode: AB12
Inbound Postcode: 3DE

Syntax

Outbound Postcode:  SUBSTR(Postcode,1,INSTR(Postcode,' ',1,1)-1)

Inbound Postcode: SUBSTR(Postcode,INSTR(Postcode,' ',1,1)+1,LENGTH(Postcode)-INSTR(Postcode,' ',1,1))

-----------------------------------------------------------------

Use this and let me know how it goes

Regards,

Mani

[Former Member]

Thanks Mani.

I need some more information on this.

Actually i need to split up the words as separate object from the master object.

EXample ;

Master object : AAA1-BBB2-CCC3-DDD4-3445556

OR ABCF-AB-DBR-GHY-323232

So my out put for new objects will be

Object 1 = AAA1 and ABCF

Object 2 = BBB2 and AB

Object 3 = CCC3 and GHY

etc..

I need to have the values like this in my universe.

"-" is delimiter.

Please clarify me.

[Former Member]

Hi Vigneshwaran,

You cannot create objects automatically by just providing a master object and a delimiter.

You need to provide a name, select statement, where (if required) and need to assign a table to the object.

This could be possible at report level where we can create formula and split values; however, creating seperate objects dynamically and automatically is not possible.

Regards,

Yuvraj