Truncate string to specific character BIP RTF file

Question

I would like to know if there is a way to insert condition into substring function in RTF template.

I have this string 18818T12, and would like to truncate it to the number after T

in other word is to print just (12)

I use desktop BI publisher add on words

any help appreciated.

Zee

Based · Accepted Answer · 2019-12-12 15:52:46Z

2

Print the substring of 2 characters, starting at the 7th position:

<?xdofx:substr('18818T12',7,2)?>

Determine the position of the 'T' character, -1 means starting from the back of the string. Add 1 because we want to start at the character following the 'T':

<?xdofx:instr('18818T12','T',-1)+1?>

To determine the length of what we want to print, we need the total length string and we subtract the length of the string up to and including our last 'T' character:

<?xdofx:length('18818T12')-Instr('18818T12','T',-1)?>

Putting all of this together:

<?xdofx:substr('18818T12', Instr('18818T12','T',-1) +1,length('18818T12')-Instr('18818T12','T',-1))?>

edited Dec 12, 2019 at 15:52

answered Dec 12, 2019 at 15:13

Based

9707 silver badges18 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Truncate string to specific character BIP RTF file

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related