How to extract text behind a particular text element

Help
1

hallo everyone,

I am trying to extract a text which is next to a particular known text.
following is an example scenario:

324234 name1
345232 name2
434343 name3

in this case i know the text of ‘name1’, ‘name2’, ‘name3’ . but i do not know the numbers.
i would like to get the number before the name.

I am using ‘find OCR text’ to find the name in the field. I do not understand how to extract the number before the name text.

do you have any solution for this kind of problem ?
Thank you

best regards,
Susheel

2

@susheel.chandra Use regular expression to extract only number

1 Like
3

@indra . yes that’s correct, i can use get text to extract the number. but i need to extract only the number before a particular name and the order of the names changes dynamically. do you have any other solution for this ?

4

use (\d.+)(?=\w{5,8}) for regex match.

Capture
Capture863×365 10.8 KB

2 Likes
5

@susheel.chandra Everytime number will be six digits or it changes

6

“(\d)+(?=.name)”
this will work irrespective of the length, for a particular name
regexName.xaml (6.1 KB)

3 Likes
7

@farhan94 Thank you Farhan. I am able to get the required results now.

1 Like
8

@Divyashreem Thank you for the information ! it helped me.

9

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