How to manipulate this string?

Learning Hub Academy Feedback
1

Hello folks,

I need to use Data Scraping in a text that contains the address of a place. The string follows a structure:

“This is the example of text
Address Rue De la Maison 23 another text
text text abcdf”

What I want to get is “De la Maison” and “23”.

Rue is a word that is shown after “Address” but it can be another word (Street, for instance). So I want to delete this first word after “Address”.

Also, the number of the address is always located after the name of the Address.

Thanks a lot!

EDIT: To sum up, I want to remove the first word of a string that contains a lot of words, and then i want to capture the first number of the remaining string and the previous words located before the number.

2

HI @EngAnalyst,
1.You can first split the string till address like str.split(“address”) .
2.Now take the second part of the split and split it again using space and remove the first element.
3. Initialize a string variable as str1=“” and add the the strings present in the split array which is done by space splitting by looping through it until there is a number.
4.You can check for number by keeping the if condition to convert the string to int and check for the number.
Cheers
Vashisht.

3

You can use this Regex to select everything with Address

Address([\s\S]*?)\d+

After that you can just remove “Address” string and use your result

Or you can use this Regex

Address([\s\S]*?\d+)

And select Group 1 : OutputRegex(0).Groups(1).Value

4

Please, could you be a little more specific? Thanks a lot.

5

Sure, i will make a workflow for you to see

6

Thanks a lot. I got to convert the text below to:

"Rue De la Maison 23 another text text text abcdf”

So I just need to remove the first word (Rue, Street,…whatever) and then capture the words that are shown before the number (De la Maison, …) and the number.

Thanks a lot again.

7

Stringmanupulation.xaml (5.4 KB)

Try this friend

IF this helped. please mark it as an aswer so people with similar problem find it faster :slight_smile:

8

Thanks a lot srdjan.suc
It returns: Rue De la Maison 23
I need to remove the first word (Rue) and capture “De la Maison” and “23” in different strings.

Thank you very very much, we are very very close to the solution!

1 Like
9

Okay, let me work on this few minutes

10

Stringmanupulation.xaml (8.3 KB)

Finally haha

2 Likes
11

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