Forum Discussion
FlyKick
Helper II
Helper IIExtract Text Between Two Delimiters Only If The Delimiter Exists
Gday All, I have a column with IP addresses in varying formats. Some are correct but some exist between two [ ] brackets. E.g. 111.111.111.111 1111:1111:1111:1111:1111:1111:1111:1111 [111.111...
Hi FlyKick
Please try the following formula as a custom column within Query Editor. You will need to change [IP] to your column name.
if Text.Contains([IP],"[") then Text.BetweenDelimiters([IP], "[", "]") as text else [IP]Please mark this as a solution if it provides the data you require.
Thanks,
George
judspud
Solution Supplier
Solution SupplierHi FlyKick
Please try the following formula as a custom column within Query Editor. You will need to change [IP] to your column name.
if Text.Contains([IP],"[") then Text.BetweenDelimiters([IP], "[", "]") as text else [IP]
Please mark this as a solution if it provides the data you require.
Thanks,
George
FlyKickHelper II
Helper IIHey George,
That has done the trick! Looks like I was barking up the wrong tree the whole time 😉 Truly appreciate your help and super bonus points for helping late on a Friday night! Thank You.....