want to extract the value from the last full stop

[Sshasnk]

Hi I have list of value where I fetch the value which is coming after the last full stop, below is the example.

Input

Values

item.0.Name

item.attribute.3.Lastname

item.8.File

item.0.exception.8.Phonenumber

item.6.excptiondetails.6.address

Output:

Input

Values

Name

Lastname

File

Phonenumber

address

[atcodedog05 · Accepted solution]

Hi @Sshasnk 

Here is one way of doing it

Here is a workflow for the task.

Output:

Workflow:

Hope this helps 🙂

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

[atcodedog05 · Accepted solution]

Hi @Sshasnk 

Here is another way of doing it more optimized

Here is a workflow for the task.

Workflow:

Regex tool config

Output:

Hope this helps 🙂

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

[atcodedog05]

Happy to help 🙂 @Sshasnk 

Cheers and Happy Analyzing 😀

[PhilipMannering]

@atcodedog05 

If you're looking to optimize, you really only need,

(\w+)$

[atcodedog05]

@PhilipMannering 

Tokenize config i assume.

[PhilipMannering]

Should work using parse.

I think it's just a regex match that has to match the string in its entirety.

[atcodedog05]

Hi @PhilipMannering 

You were right it worked on parse too.