xdo substr funtion with minus position

User_U66J8 · Jun 7, 2017 7:00AM

Summary

Content

Hi All,

In XML Publisher 4.5.0 is it possible to use substr function with a starting position -4 ?

I'm trying the below:

<?xdofx:substr(‘PT507170490’, -4)?>

Returns the entire string: PT507170490

<?xdofx:substr(‘PT507170490’, 4)?>

Returns: 07170490

Any ideas why and if it's not supported, then do you know a possible workaround?

Regards,

Alex

Pavan kumar. · Jun 7, 2017 7:00AM

Hi,

As xdofx is the extended SQL function the above syntax was true.So as of SQL script from dual it's giving proper result below

select substr('PT507170490',-9) from dual;

Output as: 507170490

<?xdofx:substr('PT507170490',-9)?>

Output should be similar to the above

 

Brajesh Shukla-95078 · Jun 7, 2017 7:00AM

Hi ,

In BI Publisher, substr function always start with 1, you cannot use -ve numbers (please refer the "Extended Function Support in RTF Templates" in BI publisher user guide)

For your requirement you can calculate the length of string and then you can use substr to get the last 9 characters. Please use the below

<?xdofx:substr('PT507170490',length('PT507170490')-8)?>

Regards,

Brajesh

Oracle Analytics Cloud and Server

Categories

xdo substr funtion with minus position

Summary

Content

Answers