PowerBI: Using Python Regex to look for values in column

Thread Rating:

Thread Modes

PowerBI: Using Python Regex to look for values in column

ibreeden
Verb Conjugator

Posts: 584

Threads: 1

Joined: Aug 2019

Reputation: 56

Oct-14-2022, 01:03 PM

(Oct-14-2022, 10:24 AM)MarcusR44 Wrote: re.search("[SRO][AGX][0-9]"

I hope that you are aware also SG, SX, RA, RX, OA and OG will be selected. I think you would rather use:

re.search(r"(RG|OX|SA)[0-9]"

Messages In This Thread

RE: PowerBI: Using Python Regex to look for values in column - by ibreeden - Oct-14-2022, 01:03 PM

Possibly Related Threads…
Thread		Author	Replies	Views	Last Post
	Get an average of the unique values of a column with group by condition and assign it	klllmmm	0	466	Feb-17-2024, 05:53 PM Last Post: klllmmm
	Converting column of values into muliple columns of counts	highland44	0	318	Feb-01-2024, 12:48 AM Last Post: highland44
	Python Regex	quest	2	2,489	Sep-22-2022, 03:15 AM Last Post: quest
	How to combine multiple column values into 1?	cubangt	15	3,110	Aug-11-2022, 08:25 PM Last Post: cubangt
	Reshaping a single column in to multiple column using Python	sahar	7	2,163	Jun-20-2022, 12:35 PM Last Post: deanhystad
	Creating a numpy array from specific values of a spreadsheet column	JulianZ	0	1,214	Apr-19-2022, 07:36 AM Last Post: JulianZ
	How to split file by same values from column from imported CSV file?	Paqqno	5	2,917	Mar-24-2022, 05:25 PM Last Post: Paqqno
	Float Slider - Affecting Values in Column 'Pandas'	planckepoch86	0	1,459	Jan-22-2022, 02:18 PM Last Post: planckepoch86
	Pandas (Python) in powerBI loop	abderrazak_rouchad77	0	1,310	Nov-08-2021, 12:54 AM Last Post: abderrazak_rouchad77
	python regex: get rid of double dot	wardancer84	4	2,454	Sep-09-2021, 03:03 PM Last Post: wardancer84

Users browsing this thread: 1 Guest(s)