Search specific structure but dynamic text in excel

[Ella]

Hello, I’m not familiar with notebook or excel but I need to search for text in my extracted google results I saved.

Mostly the text I need is formatted like:
text - text - text |
But it is not always at the same position between the other text.

For example:
Link to profile
View the profile of Christine baker - online since 2000 at fabook | to view other profiles click here…

So I’ve extracted the link, and the whole text in 3 columns

The part I need is:
Christine backer - online since 2000 at Facebook |

The problem is sometimes the text I need is in the link sometimes it’s in the text and the text is always different.

Is there a way to use the notebook text sheet for this? And how I need to use this correctly?

Thanks

[prasath17 (Guru)]

@Ella -we can do it do in Regex , if you can provide me couple of sample texts and the output you are looking for…I will try it …

Based on your post, i have extracted the below…

1. Use Matches Activity

2. Give the shatter as shown above
3. For the"Input" - If its dynamic , get the input from the variable and use the variable here…
4. On the Result - use Ctrl + K to give the output variable (My Vase IEnRegEx)
5. Write Line = IEnRegEx(0).value…

[prasath17 (Guru)]

@Ella - What ever you highlighted are the texts needs to be captured??

I don’t see any similarities between each highlighted…Regex will work only if pattern is similar…

[Ella]

Yes the problem is I often get different search results

[Ella]

I looked for a way to get the same pattern from my extraction results and I managed. Now the text I need is always following this pattern:

• christine backer -
  Can you teach me how to do this in studio X?
  thank you in advance

[prasath17 (Guru)]

Thanks…Whatever I posted before was the method we use in Studio, it was my bad I didn’t noticed that you are looking for in Studio X. But we can try.
If you give me one complete sample text, I will look into it.

[Ella]

This is an example:
Valent valerie de coster - werkt voor - Ik weet het | ja heb

The text in bold letters is the text I need

(I was wrong with the example from previous post)

Thank you very much for helping me!

[prasath17 (Guru)]

@Ella - Here you go…

Output

Note: Separator on the First Acvitity is “-”, on the second one it is " -".

So if your pattern is similar, you can pass your dynamic text as variable in the full text which gives you a output.

[Ella]

Thank you so much!!!