Power Query Replace

[JB2020]

Hi

Is there a way to modify the Text.Replace function (or a different function altogether) to only replace text where the entire string = x. For example, if I have 2 rows containing "a" and "ab" and I replace "a" with "z", I will get "z" and "zb". Whereas I would like to just replace any rows where the text = "a", rather than contains "a", therefore returning "z" and "ab". I would like to avoid adding in a lookup or a custom column if possible, which is why I am asking specifically about the Replace function.

 

[Norie]

Can you post some sample data?

 

[sandy666]

representative example is welcome

 

[JB2020]

Can you post some sample data?

Apologies I meant Table.ReplaceValues not Text.Replace:

#"Replaced Value" = Table.ReplaceValue(#"Changed Type","a","z",Replacer.ReplaceText,{"Column1"})

Column1

a

b

c

aa

ab

ac

 

[sandy666]

Column1		Column1
a		x
b		b
c		c
aa		aa
ab		ab
ac		ac

 

[JB2020]

Just seen the "Match entire cell contents" in the advanced options (doh). Thanks for your help.

 

[sandy666]

You are welcome
Have a nice day