One more help needed. In one column i have multiple email addresses of different length. For eg: amit.dhamija@rediffmail.com. How can i extract value after "@" and before "." which in this case is "rediffmail" ??
A | B | C | |
---|---|---|---|
1 | amit.dhamija@rediffmail.com | rediffmail.com | rediffmail |
2 | aa.bb.cc@inter.nl.net | inter.nl.net | inter |
3 | John.Smith@example.com | example.com | example |
4 | simple@example.com | example.com | example |
5 | very.common@example.example.com | example.example.com | example |
6 | disposable.style.email.with+symbol@example-example.com | example-example.com | example-example |
7 | other.email-with-hyphen@~example-test-example.com | ~example-test-example.com | ~example-test-example |
Sheet: Sheet1 |
let
Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
#"Split Column by Delimiter @" = Table.SplitColumn(Source, "Column1", Splitter.SplitTextByDelimiter("@", QuoteStyle.Csv), {"Column1.1", "Column1.2"}),
#"Split Column by Delimiter period" = Table.SplitColumn(#"Split Column by Delimiter @", "Column1.2", Splitter.SplitTextByDelimiter(".", QuoteStyle.Csv), {"Column1.2.1", "Column1.2.2"}),
#"Removed Unessary Columns" = Table.RemoveColumns(#"Split Column by Delimiter period",{"Column1.1", "Column1.2.2"})
in
#"Removed Unessary Columns"
RAW | RAW | |
amit.dhamija@rediffmail.com | rediffmail | |
aa.bb.cc@inter.nl.net | inter | |
John.Smith@example.com | example | |
simple@example.com | example | |
very.common@example.example.com | example | |
disposable.style.email.with+symbol@example-example.com | example-example | |
other.email-with-hyphen@~example-test-example.com | ~example-test-example |
[SIZE=1]// Table1
let
Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
Between = Table.TransformColumns(Source, {{"RAW", each Text.BetweenDelimiters(_, "@", "."), type text}})
in
Between[/SIZE]
Thanks but this gives an error somehow....Doesnt work
ohh ok. So how should i use it? I am unsure. Isnt there a formulae (like the one you gave before)? As its easy to implement.
Give this formula a try...Isnt there a formulae (like the one you gave before)? As its easy to implement.