Split numeric and alphabetic symbols

Help Studio
1

Dear community,

I am very new to UiPath and I am struggling with splitting a specific kind of string.
My question is: is it possible to split for example 1a into 1 a and looping through an entire column with many strings look similar to the one above.
I would really appreciate any help.

Kind regards

2

Hi @Bjorm_Block

Welcome to the UiPath Community!

Please provide more examples to work with.

image

3

Hey thank your for the quick response.

So I have to insert house numbers into a website and the house numbers are formatted in my datatable like this 1a , 23E, 21C and so on.
When I use the type into function it will insert the 1a or 23E into the website. But it doesn’t accept house numbers looking like 1a only if they are formatted like 1 a or 23 E or 21 C.

Does that make it understand a bit better I hope so.

4

I will try out our Tipp thank you so much :blush:

5

Is it also possible to insert a specific row.item into your function?

6

Hi @Bjorm_Block

Try this

System.Text.RegularExpressions.Regex.Replace(inputStr, "(\d+)", "$1 ")

The inputStr is a string variable. And yes you can replace inputStr with row.Item like

System.Text.RegularExpressions.Regex.Replace(row.Item("HouseNo").ToString, "(\d+)", "$1 ")

For your reference

image

1 Like
7

Thank you so much i will try it out really appreciate your effort. Have a great weekend.

8

@kumar.varun2 hey I hope you are doing well. You really helped me out a lot. I have another issue tho. I can split 23A and 100a but I struggle with splitting 3a is there anything I need to change to also change 1a or 2b? Would really appreciate your help

9

Hi @Bjorm_Block

It should work for 1a and 2b.

image

1 Like
10

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.