Extract data after a "."

[Anonymous]

I have information as follows:

12.1234

12.1111

12.33445

12.13344

I need to get the numbers after the dots in each transaction. How can I do that in the load script?

Please help.

Thanks,
Amit

[its_anandrjs · Accepted solution]

In Load string try with

Load

Trim(SubField(StrCol,'.',-1)) as NewStringColumn

From Source......

[Anonymous]

Thanks man!