How to get certain numbers from the pyID ?

Blueprint and App Design
, , ,
1

I want to get some certain numbers from the pyID to return column of the decision table how can I achieve that ?

Example -

pyID - M-22001 (I want to get the fist two numbers from the pyID to the return column of the decision table)

return column expression - “FC”+.ManufacturedYear+“-”+.pyID (I’m currently using this Expression but this expression gives me the whole pyID I only want the first two numbers of the pyID )

Normal return - FC2002-M-22001

Expecting return - FC2002-22

2

@AshinaS2

Can you do substring?

@substring(.pyID,2,4)

3

@AshinaS2

you can make use of whatComesAfterLast and substring function to get first 2 digit of Case ID and the append the return value with needed string to get the expected result.

If you are going for this approach advantage will be in future if you are changing the case id prefix from “M” to double digit values like “FM”, “GM”..etc. this code will work in expected way no need to have any code change.

Function = @substring(@String.whatComesAfterLast(Param.Case_ID,‘-’),“0”,“2”)

Param.Case_ID = This parameter should have case id value.

Attached Screen-Shot for reference.

Sub-String.png
Sub-String.png1474×887 15.9 KB

4

@JoeH9464 Thanks it works

@String.substring(.pyID,2,4)