Need to extract data from email, which is unstructured data

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

Capture2

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

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

Try this stringsplit.xaml (9.3 KB)

1 Like