Email Body Manipulation

hello guys!

I have to retrive the Item name from an email text with this layout (the item’s number can vary! so it could be more than 3 as it could be less)

Item1: pendrive
Item2: lavatrice
Item3: speaker

I need to get the item name 1 by 1 and for each of them do a reasearch on Ebay where then I need to check the first 10 elements and get the 5 that are cheaper.
After that I need to write those in a Database Access with Description and Price as columns. It is suggested to use the OLEDB provider.
After that I need to create an excel report as well with the items in Alphabetical order.

it says I need to use a Dispatcher and a Performer. Now, I don’t know if this means that I need to use a queue or I can just use an excel file for storing the Items name and then search them on Ebay.

I am stuck in the process of getting the Items name from the Email body.

anyone can help? thnx

Hi @williamcordella

Use the regex pattern for extraction of item names from email body and iterate through each one

Hope it helps

Regards,

Nived N :robot:

Happy Automation :slight_smile::slight_smile:

Hello @williamcordella - welcome back to forums

Further to @NIVED_NAMBIAR’s post.

Try this Regex Pattern in a Matches Activity:
(?<=Item\d+:\s).*

image

If you want to learn more about Regex and how to use the results I have created a new user Regex MegaPost with a UiPath Regex workflow demo.

Hopefully this can help :slight_smile:

Cheers

Steve

1 Like

Hi Steven could you help me with this one? I am trying to write those items name to an excel file but it doesnt seems to work, the counter doesnt increments even tho the other activieties seem to be iterated

Hello

You are going to need write the results into a datatable.
You will need to use a:
Build DataTable
Add data row
Then write range.

Definitely check out Anders Jensen’s YouTube channel for the best tutorials on how to do this.

Start with this video: https://youtu.be/DTKyWrgDDDg

Hopefully this helps you :slight_smile:

Cheers Steve

hi Steven I tryied before but the issue I am facing is the conversion from string to data row/ Array row. I searched on the forum how to do that but I couldnt find a proper answer

Hello

When you are adding results into the ‘ArrayRow’ property they need to be captured with curly brackets “{” and “}”
They also need to be separated using a “,”

Try this video from Anders Jensen - https://www.youtube.com/watch?v=-ZfRvKtPxdw&t=611s

Particularly watch at 8:50.

Hopefully this helps :slight_smile:

Cheers

Steve

it worked just by writing the counter as well otherwise it woudnt take it as an array… the problem is that idk why but it doesnt increment the counter even if it does everything before and after that.

Cattura6

1 Like

i did solve it! I had to create an assign activity before the loop to give the counter var the value of 1 instead of give it a default value of 1 in the var panel

1 Like

Good work :smile:

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