Removing the characters before the period

[dunkindonut7777]

Hi I would like to ask if how can I remove the leading digits before the period character.

Code	Expected Output
12000.9849385-DC	9849385-DC
12.32434-FR	32434-FR
120.7685067	7685067

Can you help me with this one pls?

[JarekSkudrzyk]

@dunkindonut7777 

I think the same data and solutions are in this thread:
https://community.alteryx.com/t5/Alteryx-Designer-Discussions/REMOVING-THE-CHARACTERS-ON-THE-LEFT-SI...

[Kamran1991]

Hi @dunkindonut7777 , you can use this formula to extract the expected output.

Thanks,

Kamran

[Kamran1991]

This query can be solved by using the 'RegEx' tool also with attached configuration

[Kamran1991]

Hi @dunkindonut7777 ,

if my solutions  answer your query, please accept them as solution.