topic RE: How to check wether it text /alphabets or not in Product Forum

How to check wether it text /alphabets or not

ChetanNinghot — Sat, 01 Oct 2022 17:26:00 GMT

Hi
I have small daut
I have input like ABQ1268899
I want check total character and first 3 are alphabet and remaining 7 are number I know how to check wether number and length but i have some dout about how to check alphabetes

------------------------------
Chetan Ninghot
------------------------------

RE: How to check wether it text /alphabets or not

PvD_SE — Mon, 03 Oct 2022 05:27:00 GMT

Hi C,

Unfortunately, there's no IsAlfa() function in BP, like there is a IsNumeric() function. In this case, I'd suggest using regex, an object to work with regex should already be available in you BP installation.

It would be easiest if you split the string in the first 3 and the last 7 chars. The first 3 chars you can check using Regex. If you google 'regex check alphanumeric' or similar, you'll get many pages describing what you want to know.

If you want to know more about regex, I'd suggest this page, or perhaps this one.

------------------------------
Happy coding!
---------------
Paul
Sweden
------------------------------

RE: How to check wether it text /alphabets or not

ChetanNinghot — Mon, 03 Oct 2022 06:05:00 GMT

Hi
Paul
Thank a lot for your valuable response
I am trying to used given link page

------------------------------
Chetan Ninghot
------------------------------

RE: How to check wether it text /alphabets or not

MichealCharron — Mon, 03 Oct 2022 13:11:00 GMT

@Chetan Ninghot

Further to what @PvD_SE had said about using Regex, you can use the "Test Regex Match" action in BP's "Utility - Strings" VBO. You can use a regex pattern of:

"^[a-zA-Z]{3}[0-9]{7}$"

This will take care of both your length testing and character matching. The breakdown of the pattern is:

^ - start of the line
[a-zA-Z] - match any letter
{3} - match three of the previous specified characters
[0-9] - match any numbers (before anybody says anything, no, "\d" does not always mean the same as "[0-9]" in .Net)
{7} - match seven of the previous specified characters
$ - end of line

------------------------------

Micheal Charron
Senior Manager
RBC
America/Toronto
------------------------------

RE: How to check wether it text /alphabets or not

ChetanNinghot — Mon, 03 Oct 2022 15:10:00 GMT

Hii
Micheal
Thank you for response

Your expression will directly helpful
For my input ABQ8769876
I will check it

------------------------------
Chetan Ninghot
------------------------------

RE: How to check wether it text /alphabets or not

ritansh.jatwani — Mon, 03 Oct 2022 21:35:00 GMT

Thanks for sharing the solution @MichealCharron

------------------------------
Ritansh Jatwani
Manager
Deloitte
Gurgaon
*If you find this post helpful mark it as best answer
------------------------------