Power Query: make new column by extracting a word from a cell that contains a $ sign.

[omairhe]

Hello all,
How do I extract from my column A a word that contains in it a $ sign.
For instance the data in column A would look something like

A1 = 5465 Apples$50 Twenty
A2 = 5687 Grapes$597 Three

answer:
B1 = Apple$50
B2 = Grapes$597

Apple$50 and Grapes$597 needs to be extracted to a new column of the same row.

Will appreciate a lot.

 

[brawnystaff]

Hello all,
How do I extract from my column A a word that contains in it a $ sign.
For instance the data in column A would look something like

A1 = 5465 Apples$50 Twenty
A2 = 5687 Grapes$597 Three

answer:
B1 = Apple$50
B2 = Grapes$597

Apple$50 and Grapes$597 needs to be extracted to a new column of the same row.

Will appreciate a l

Assuming table is called Name, try the following:

let splitName = Splitter.SplitTextByDelimiter("$", QuoteStyle.None)([Name]), splitsplitName0 = List.Reverse(Splitter.SplitTextByDelimiter(" ", QuoteStyle.None)(splitName{0}?)), splitsplitName1 = Splitter.SplitTextByDelimiter(" ", QuoteStyle.None)(splitName{1}?) in Text.Combine({Text.Start(splitsplitName0{0}?, 5), "$", splitsplitName1{0}?})

 

[omairhe]

Assuming table is called Name, try the following:

let splitName = Splitter.SplitTextByDelimiter("$", QuoteStyle.None)([Name]), splitsplitName0 = List.Reverse(Splitter.SplitTextByDelimiter(" ", QuoteStyle.None)(splitName{0}?)), splitsplitName1 = Splitter.SplitTextByDelimiter(" ", QuoteStyle.None)(splitName{1}?) in Text.Combine({Text.Start(splitsplitName0{0}?, 5), "$", splitsplitName1{0}?})

Thanks.