Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I hope somebody can help me quickly,
I have eMail data coming into Excel via Power Automate and I need to extract a reference number from either the Subject Or Body of the eMail.
Most of the references are preceded by certain words such as Reference or Number.
The solution I have come up with is to use Split Column By Delimiter - how do I search for multiple delimiters if the last one wasn't present?
Is this correct? This is the base
= Table.SplitColumn(Table.TransformColumnTypes(#"Changed Type", {{"Subject", type text}}, "en-GB"), "Subject", Splitter.SplitTextByAnyDelimiter({"Number"}, QuoteStyle.Csv, true), {"Subject.1", "Subject.2"})
If I modify it like this with multiple conditions it still seems to miss some.
= Table.SplitColumn(Table.TransformColumnTypes(#"Changed Type", {{"Subject", type text}}, "en-GB"), "Subject", Splitter.SplitTextByAnyDelimiter({"Number", "Reference", "no."}, QuoteStyle.Csv, true), {"Subject.1", "Subject.2"})
Solved! Go to Solution.
I've noticed I've put this in the wrong area, it should be in Power Queries.
Moving & Reposting now.
I've noticed I've put this in the wrong area, it should be in Power Queries.
Moving & Reposting now.
@RhysWhite ,
Can you please share sample data and sample output in table format?
I think you need to do two or more splits OR use Text.Contains and then do it
@amitchandak Thanks - I can't share data - our policies make it very difficult to share anything externally.
Thanks Anyway
User | Count |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
67 |