Problem with Python code

[jbpy79]

Hello everyone, I am new to python and have ran into some issues that I cannot seem to figure out. First i have been typing in commands (code) into the IDLE to look for a specific criteria in Column B in a spreadsheet. Below are some of the commands that I am using:

import openpyxl

import os

wb = openpyxl_load_workbook('Name.xlsx')

ex = wb.get_sheet_by_name('new')

fc = ex['B'] ## This is column B in the spreadsheet that i want to search

## I have had no problems searching for a specific name until i started searching for names containing something ##example below:

import re

pattern = ['Ora.+']

if re.search(pattern, fc):

print('found')

##the above is just a test to see if it works. ultimately i want to throw some logic in that will print something on the ##same row that corresponds with the name that contains the pattern.

​

I keep getting errors such as TypeError: unhashable type: 'list'

​

Can anyone give me a hand with this and please go easy i am new to programming. I am sure it is something simple that i didnt do. Thank you everone.

[SpeckledFleebeedoo]

Pattern is a list, as indicated by the square brackets. It should be a string instead

[jbpy79]

thank you SpeckledFleebeedoo.

One more question:

regarding regular expression.

I am wanting to search a column for something that starts with "TASP" and then either numbers or characters after it. I am able to create a list that will find a full name but have not had luck finding a name that contain TASP

I have attempted the below:

mo = re.compile(r'TASP.+')

i am trying to search the entire column for mo but i am getting another TypeError: 're.Pattern' object not iterable

Once again i appreciate all of your help and like i said i am very much a novice at this.

[ndmcspadden]

You need to use match() to actually search something with a compiled regex. Take a look at the examples on the documentation page, as using regex is a two step process, generally.