Power Query: Only keep PO values

[sscornav]

This seems like it should be simple, but I am new to PQ and couldn't find it in the search.

I have a column with data like this:
PO123456
Accrual
Amortization for XYZ
PO234555
PO999999
Invoice 123

I would like to clear out all values that do not start with "PO". I don't want to filter the rows, I just want to clear the other values so I am left with PO number.

Thanks!
Steve

 

[RoryA]

I don't want to filter the rows, I just want to clear the other values so I am left with PO number

So you want to keep the other rows but replace them with what? Null?

 

[JGordon11]

let
    Source = Excel.CurrentWorkbook(){[Name="Table2"]}[Content],
    Result = Table.ReplaceValue(Source,"a","b",(x,y,z)=>if Text.Start(x,2)<> "PO" then null else x,{"Column1"})
in
    Result

Book2
	C	D	E	F
1	Table2		Query Output
2	Column1		Column1
3	PO123456		PO123456
4	Accrual
5	Amortization for XYZ
6	PO234555		PO234555
7	PO999999		PO999999
8	Invoice 123
9
Sheet1

 

[sscornav]

That looks like what I need, but it looks like you are creating a new table. I just want to get rid of the values in my existing table.

Is there a way to do that?

 

[JGordon11]

= Table.ReplaceValue(YourTableName,"a","b",(x,y,z)=>if Text.Start(x,2)<> "PO" then null else x,{"YourColumnName"})

 

[sscornav]

Thanks! It turns out you can do this with "Add Conditional Column" as well.

Solved.

 

[JEC]

This will do too. Gordon's version will come in handy when you want to replace values in multiple columns

= Table.ReplaceValue(Source,each [Column1], each if Text.Start([Column1],2) <>"PO" then "" else _ ,Replacer.ReplaceText,{"Column1"})

 

[smozgur]

The marked solution has been changed with the answer post (post #5) in this thread as it will also help future readers.