Extracting the numeric part from a cell

Hi everyone,

I have a column string in this format

"injection-0:94577)"
"injection-0:94578)"
"injection-0:94579)"
"injection-0:94580)"
"injection-0:94581)"
"injection-0:94582)"
"injection-0:94583)"

I want to extract the numeric part that starts with 9 like 94577 from roow one for instance. Can anyone help please? Thank you.

Answer 1

[Paul]

str = ["injection-0:94577)"
"injection-0:94578)"
"injection-0:94579)"
"injection-0:94580)"
"injection-0:94581)"
"injection-0:94582)"
"injection-0:94583)"]

str = 7×1 string array
    "injection-0:94577)"
    "injection-0:94578)"
    "injection-0:94579)"
    "injection-0:94580)"
    "injection-0:94581)"
    "injection-0:94582)"
    "injection-0:94583)"

newstr = extractBefore(extractAfter(str,":"),")")

newstr = 7×1 string array
    "94577"
    "94578"
    "94579"
    "94580"
    "94581"
    "94582"
    "94583"

[Mahdi Khademishamami]

Thank you! What about converting the newstr to an array? Should I use str2num?

[Paul]

I would just use double()

str = ["injection-0:94577)"
"injection-0:94578)"
"injection-0:94579)"
"injection-0:94580)"
"injection-0:94581)"
"injection-0:94582)"
"injection-0:94583)"];

newstr = extractBefore(extractAfter(str,":"),")");

d = double(newstr)

d = 7×1

94577 94578 94579 94580 94581 94582 94583

[Mahdi Khademishamami]

Thanks again!

Answer 2

[per isakson]

Try

>> extractBetween( "injection-0:94582)", ":", ")" )
ans = 
"94582"

[Mahdi Khademishamami]

Thank you so much!