Find All Email Address present in each line.

[#1]

Hi All

I want to find all the email address present in each and every single line.

This is what i need:

Is there any way around for such requirement.

I have tried Index(), Textbetween() and Findoneof() functions but no Luck.

I have attached the Sample Data Source.

Regards

Eric

[Gysbert_Wassenaar]

Yes, see attached example.

[Anil_Babu_Samineni]

Hello,

Try This:

Open the Excel sheet. PFA. You can get easily after that. Try your own self. Now, take fresh QVW and then load the excel and reload. Then take fields. Check the output image. You will get same output.

Cheers,

Anil.