topic how to find position of character in a string in Product Forum

how to find position of character in a string

NakkalaBharath — Mon, 08 Aug 2022 08:10:00 GMT

How to find nth character in a string.

like find the 5th character in a "Blueprism".

------------------------------
Bharath Nakkala
------------------------------

RE: how to find position of character in a string

Tejaskumar_Darji — Mon, 08 Aug 2022 08:29:00 GMT

Hi you can use "Mid" function from the expressions editor of calc stage.

------------------------------
If I was of assistance, please vote for it to be the "Best Answer".

Thanks & Regards,
Tejaskumar Darji
Sr. Consultant-Technical Lead
------------------------------

RE: how to find position of character in a string

NakkalaBharath — Mon, 08 Aug 2022 08:57:00 GMT

Thank you for guiding me.

------------------------------
Bharath Nakkala
------------------------------

RE: how to find position of character in a string

NakkalaBharath — Mon, 08 Aug 2022 09:28:00 GMT

Hey can you help me with another doubt ,

take the decision in case your string contain alphabet "S"?

------------------------------
Bharath Nakkala
------------------------------

RE: how to find position of character in a string

PabloSarabia — Mon, 08 Aug 2022 09:51:00 GMT

Hi @NakkalaBharath

For this, you need to know the char index of the search character.

You need to use the VBO "Utility - Strings" with the Action "InStrRev". This actions gives you the position of the search text.

If the position is greater than 0, means that the search text was found in the original text.

The structure looks like this:

Hope this helps you!!

See you in the Community, bye 🙂

------------------------------
Pablo Sarabia
Solution Manager & Architect
Altamira Assets Management
Madrid
------------------------------