Manipulate string in a single variable

I’m looking for a way to manipulate a string similar to the following:

“File 32411341.UI House 4343243.xlsx”

Where I want to take the last numbers before the point, I was trying to trim it using the space before the number and the point after the number as a base but I can’t do this without having to use other variables.

There are a few ways to do this. Here is one.

Assign myStr = “File 32411341.UI House 4343243.xlsx"

myStr.Split(" “c)(3).Replace(”.xlsx","")

image

image

1 Like

@JavXult - Another solution…

image

1 Like

Thank you very much, it works in a simple way!

Thank you! It also works

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.