Split number and text

RPA Discussions
1

hi i want to seprate the no and text from excel cell and shown in different cell

2

https://uipath-survey.secure.force.com/CaseView/articles/Knowledge/Basics-of-Regular-Expressions-RegEx-a-string-manipulation-technique

3

Hi @guptasweb

Please use

System.Text.RegularExpressions.Regex.Match(yourstring,“[.\d]+”).Value

This will provide the “Digits” in the String and the Rest will be the text.

Thanks.

1 Like
4

where to use sysytem.string

5

it throws an error value cannot be null

6

Please pass Your variable or the String you want the digits from in place of “yourstring”.

Thanks.

1 Like
7

it shows value cannot be null

8

Does the string you pass have value?

1 Like
9

no. i dont enter any value

10

your string which you passed should not be empty or else the regex cant find any matches

11

Hello @guptasweb ,

You can achieve this using Generate DataTable or Text to Columns activities
This will help to split using some delimiter and write to Excel file or to convert to a DataTable.

If still confused maybe you can watch the below video:

1 Like
12

I’ve tried this but it didnt work

13

If possible Plz share the data which you are trying to split .

14

AAM-5Ref-150-01-Equipment Sourcing.xlsx (21.0 KB)
i want to seprate the Column A Data into Column A& ColumnB

15

hiii @guptasweb,

i think you already created a separate post on this topic
you got the solution also

16

Hello @guptasweb , The excel document is not structured. Not all the columns are of same format. Do you just need to Split “1.8.1 Supplier Agreement. 12” these kind of cells alone?

If you can manually split and share a demo file, I can try this out. Because the file which you shared is not structured.

image
image1105Ă—293 15.7 KB

17

yes … i want to seprate 1.1.1.1 and The manual is made up of standards,forms,and checklists…

1 Like