Split string by number and stored number in Excel ID Column

Help Studio
, ,
1

Hi I want to seperate Name&ID and have to stored ID no in ID Column excel

If string Nikita2233 it split to Nikita and 2233
How can I do it?

Thanks in advance.
I’m attaching Screenshot Also
image
Excel File
Test.xlsx (9.4 KB)
Output Should be(ID Number) stored in ID column

2

Hello @kaveri_satpute

You can check the below post.

1 Like
3

@kaveri_satpute
Welcome to the forum

we can use regex and referring to the groups
grafik

  • Excel Application Scope and read range - dtData

  • For each row Activity | row in dtData

  • Assign Activity:
    myMatch = System.Text.RegularExpressions.Regex.Match(row(0).toString, "(.*?)(\d+)")

  • Assign Activity: row(0) = myMatch.Groups(1).Value

  • Assign Activity: row(1) = myMatch.Groups(2).Value

And writing back dtData to Excel if it is needed

4

HI @kaveri_satpute

Welcome to forum community!!

You can try with regex expression

Name - System.Text.RegularExpressions.Regex.Match(StringVal,"(.*?)\d+").Groups(1).ToString

Number - System.Text.RegularExpressions.Regex.Match(StringVal,"\d+").ToString

image
image373×507 10.5 KB

Regards
Gokul

5

@kaveri_satpute

try this workflow->
Sequence.xaml (11.6 KB)

I hope it will help you.
1 Like
6

Hi Vaibhav,

Thank you so much
Can I know which package your working for Regex method

7

@kaveri_satpute

Its a vb expression .you can directly use it or you can also import this from import panel->
have a look on it.

image
image1366×768 78.2 KB