remove text calc up to a period but with numbers

[hartmut]

Hello I am trying to parce data from a web site.

There is always a number value immediately followed by a period. I am trying to delete that data and leave the rest.

ex.

[color:red]

12. the cardinal ( I need) the cardinal

[color:red]156. the baseball ( I need) the baseball

There is always at least 2 but up to 5 numbers followed by a period. I am just trying to find a calculation to get rid of the number value and the period but it is not always the same number of digits. I could use the help - Thanks

[mr_vodka]

You can use Right or Middle.

If there is only one period then you can try something like:

Right ( field; Length ( field ) - Position ( field; "." ; 1 ; 1 ) )

[hartmut]

thanks that seems to work but there is a space between the period and the following word which needs to go as well.

[mr_vodka]

Wrap it with a trim () then.

[comment]

If there's always a space following the period, you can use:

Right ( field ; Length ( field ) - Position ( field ; ". " ; 1 ; 1 ) - 1 )