How to extract a specific numbering in the middle of text on a line in excel?

Help
, , , , , ,
1

Hey,

I’m trying to extract a numbering sequence in an excel spreadsheet, but I don’t know how to do that. This specific numbering is in the middle of other words and other numbers that will not be used.

I want to extract all the numbers starting with 531 or 553. The numbering that starts with 531 has 10 more numbers totaling 13 numbers. The numbering starting with 553 has 11 more numbers totaling 14 numbers.

These numbers are in each row of a column in excel. The problem is that, often, these numbers are accompanied by other texts or other numbers such as date of birth, license plate, date of sending file, document numbering, etc. There is no pattern.

These numbers can also be separated with blanks or periods and dashes.

Can someone help me?

Thank you

2

Let me give a try… Please provide a sample excel…

1 Like
3

The numbers are in the column “Assunto do E-mail:”

Busca_Excel.xlsx (11.9 KB)

4

@vinicius.botelho Can you tell us what is the output that you expect and in which format?

5

Yes

I will structure these numbers in another spreadsheet.

The result of this extraction will be the numbers in this format: 5312020181546
55320205189101

6

@vinicius.botelho Do you want these numbers in another Sheet of the Excel ?

7

In fact, I want these numbers in another spreadsheet and that will also have other information. My problem at this point is only in extracting these numbers.

8

@vinicius.botelho The above Scenarios are not present in the Excel. So if you can provide those kind of Scenarios, I mean the numbers being in that format, we can make sure we are covering all scenarios and giving you the right output.

9

There is no standard, the only certainty will be those numbers that start with 531 or 553.

There may be cases where these numbers will not be present. Where the field will be blank or will have other information but will not have that number.

10

@vinicius.botelho Check this Workflow :
I was not sure how to present the Extracted data, Hence I just used a Message Box :sweat_smile: . Check if that’s what you needed. If not, please explain in detail.
Data Extraction.zip (11.0 KB)

1 Like
11

Hi @vinicius.botelho,
Get the value from excel and then use that variable in if condition like this
If Variable.StartsWith(“531”) or Variable.StartsWith(“553”) in then By using regex you are able to get how many numbers you want there.
Happy Automation!

12

i need help on this. In my example, the lines can change, what should I do?

example: 2.5 details
3 details

i just need numbers

13

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