Delete recurring character from Matrix

aaronhokedoenges's icon

Hey this might be pretty simple but I can't seem to figure it out, I'm pretty new to this. I have a matrix of data imported from the web that looks something like this (only many times longer):

773 P
428 P
-121    P
-878    P
-946    P
-1220    P
-1430    P
-815    P
2320    P
7180    P
9280    P
10300    P
10800    P
11500    P

I need to remove the 'P' from every line and find the average of the numbers. I can't offset the matrix because the different lengths of the numbers. Any clues?

Thanks all!
Aaron

LSka's icon
Max Patch
Copy patch and select New From Clipboard in Max.

Something like this should do the job..

aaronhokedoenges's icon

Thanks LSKA, that didn't quite get it. I think it's because of the way the data is imported. It seems that each digit/character is housed as a cell in the matrix individually rather than the whole integer. I'm trying to pull in the numbers in the next to last column here:

I can extract a single row of the number and use that, but not the column. When I offset the matrix to narrow down the options the offset is based on each character not each column as seen on the web.

MIB's icon
Max Patch
Copy patch and select New From Clipboard in Max.

maybe this?