Hi All,
Greetings for the day!
This is my first post on this community, I have been trying to build an email snapper using power automate, the objective is to store the price, index name and asof date as a row in excel. we receive 100s of emails from different banks having index prices with dates. can anyone pls tell me how to use the split function to parse the data from the below email type. i will use it for future references as well.
Hello,
Please find bellow the level of ABC Index as of 12-05-2022
BBG Level | |
2022-05-12 | 114.2854 |
Output :
ABC Index 114.2854 2022-05-12
WarrenBelz
146,651
Most Valuable Professional
RandyHayes
76,287
Super User 2024 Season 1
Pstork1
65,999
Most Valuable Professional