Substring, regex, etc

[AndhikaDwi (Dwi Andhika)]

Hello, i have variable:
Var1 = “axbxcxdxe 1x2x3x4 abcde CoreData.txt”
i want to get only CoreData.txt and remove the character behind Core words.
how the simply way to get it ?
iam already use right function to manipulate it but it seems not the proper way.
FYI the character behind CoreData it always changes.
thank you

[Anil_G (Anil Gorthi)]

@AndhikaDwi

Please try this

Say its stored in str variable

Str.Trim.Split({" "},StringSplitOptions.None)(Str.Split({" "},StringSplitOptions.None).Count-1)

This basically splits the data on space and then gets the last item from the output …same works for Last as well

Cheers

[Suraj_B_Shetty (Suraj)]

Hi @AndhikaDwi

Give a try to this.
Split(“axbxcxdxe 1x2x3x4 abcde CoreData.txt”," ").Last

Hope this might help you.

[Chirag_Shetty_Divakar (Chirag Shetty)]

Hey @AndhikaDwi

MatchRegexVariable is of type string

Regex Forumm.zip (68.4 KB)

Hope this will help
Cheers.

[Gvivek9889 (Vivek Gupta)]

Hi @AndhikaDwi ,

You can use Regex for this “(?<=\s)\w+.\w+$”

Hope this will help

[AndhikaDwi (Dwi Andhika)]

All of your suggest is solution thank you guys