Need to extract data from email, which is unstructured data

Help
1

Hello every one

i need laptop\desktop count in email which is unstructured data.
can anybody help on this… PFB screen shots. I need count after* sign… like 1 2 4

Capture

Capture1
Capture1818×137 5.24 KB
Capture2
Capture3
Capture3816×194 6.87 KB

2

You get the entire text and then play with string manipulation with regex

  • extract the lines containing x
  • split the string on this and you get string1 with description and string2 with quantity
  • string1 can be manipulated to extract only part of the description
3

If don’t mine could you please explain in brief …

4

Try this stringsplit.xaml (9.3 KB)

1 Like