xdo substr funtion with minus position

Question

Summary xdo substr funtion with minus position 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: Returns the entire string: PT507170490 Returns: 07170490 Any ideas why and if it's not supported, then do you know a possible workaround? Regards, Alex

Pavan kumar. · Answer

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 Output should be similar to the above

Brajesh Shukla-95078 · Answer

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