Delete recurring character from Matrix

Dec 31, 2013 at 8:14am

Delete recurring character from Matrix

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!

Dec 31, 2013 at 9:57am

Something like this should do the job..

– Pasted Max Patch, click to expand. –


Jan 7, 2014 at 10:52am

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:

using the patch that was pasted 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.

Jan 8, 2014 at 1:49pm

maybe this?


– Pasted Max Patch, click to expand. –



You must be logged in to reply to this topic.