Question
Accenture
IN
Last activity: 31 Jan 2023 7:17 EST
Fetch the last 3 characters of a property value and pass as a parameter
Hi All,
I have a requirement to fetch last 3 characters of a property value and check if it matches in the current iteration of a Pagelist.
Ex: I have Param.LastThreeChar="ABC"
Param.ABCIndex=@IndexInPageList("Param.LastThreeChar",".AppNumber",.Countries)
But I want to pass the last three characters of .AppNumber property value into "Param.LastThreeChar" and then fetch its index.
How can pass a regular expression into Param.LasThreeChar? I tried holding Para,.LastThreeChar="^..*ABC$" but it is not working..
Is there any way to pass last 3 characters of a property value?
Thanks,
Sakhib Hussain
***Edited by Moderator Marije to add Capability tags***
Accepted Solution
Updated: 31 Jan 2023 7:17 EST
Accenture
IN
I got the solution for the above
1. Create a When rule "CheckABCTextAtLast"
2. Use the following expression @pxContainsViaRegex(.ApplicationNumber,"^.*(?i)ABC$",true)
This is a regular expression function which will ignore the case of ABC as well and return true if last letters are ABC/ABc/aBC etc.
3. To get the index of the page list which satisfies above use
@IndexInPageListWhen("CheckABCTextAtLast",.Countries)
Thanks,
Sakhib Hussain
Areteans
IN
You can try using substring function. Please find the syntax below.
Substring ( String, Length of the string - 3 )
Accenture
IN
Areteans
IN
Length of the string can be found using length function. please try using the below syntax.
Accenture
IN
Yes tried, but since I have used @IndexInPageList() and .countries as a Pagelist and .AppNumber is a property inside .countries Pagelist, it throws me an error.
Areteans
IN
Please provide the below details
1.what is the property for which you want u to fetch last 3 characters.
2.Can that property value have special characters as well in the end. If yes,do you want to fetch only non special characters?
3.And does the AppNumber property in countries pagelist have only 3 characters because indexinpagelist always does the exact match and returns the index
Accenture
IN
1. .AppNumber Ex: AppNumber="BDE123-ABC" So I want to fetch last 3 characters of this which is "ABC"
2. No. This property value does not have any special characters. Just want to fetch last 3 characters every time.
3. No. AppNumber has many characters in addition to 3 character which I am trying to fetch. Ex: AppNumber="BDE123-ABC" or AppNumber="ERT123-ACC" So here last 3 characters I am trying to fetch i.e. ABC or ACC
Accenture
IN
I have changed a logic a bit. I have included substring function below, .Countries loop. So this will going to fetch the last 3 letters in the .AppNumber which is inside the current .Countries loop itself.
Thanks a lot @HariPriyaY for your responses. I appreciate that.
Thank you.
Accepted Solution
Updated: 31 Jan 2023 7:17 EST
Accenture
IN
I got the solution for the above
1. Create a When rule "CheckABCTextAtLast"
2. Use the following expression @pxContainsViaRegex(.ApplicationNumber,"^.*(?i)ABC$",true)
This is a regular expression function which will ignore the case of ABC as well and return true if last letters are ABC/ABc/aBC etc.
3. To get the index of the page list which satisfies above use
@IndexInPageListWhen("CheckABCTextAtLast",.Countries)
Thanks,
Sakhib Hussain