replace last part of string

[yeahILuvPP]

Hi 

I am trying to replace last part of the string, after the last "_"

My example

base text: test_test_test_1

new text should be: test_test_test_NewText

How can I accomplish this?

[eka24]

Assuming the test_test_test_1 is in TextInput4, in default of Textbox5:

Substitute(TextInput4.Text,"_1","_NewText")

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

[yeahILuvPP]

"_" is static. The "1" in my example is always a dynamic value.. it could be _test1, _test5, _testX

After the last "_" I want to replace the text with e.g. "Image".

[eka24 · Accepted solution]

There may be better way of doing this, but  came up with:

Concatenate(Left(TextInput4.Text,Find("#",Substitute(TextInput4.Text,"_","#",
Len(TextInput4.Text)-Len(Substitute(TextInput4.Text,"_",""))))-0),"Image")

or

Concatenate(Left(TextInput4.Text,Find("#",Substitute(TextInput4.Text,"_","#",
Len(TextInput4.Text)-Len(Substitute(TextInput4.Text,"_",""))))-0),TextInput6.Text)

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

[yeahILuvPP]

Thanks!!! It works like a charm!