Jump to content
Sign in to follow this  
hartmut

remove text calc up to a period but with numbers

Recommended Posts

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

Share this post


Link to post
Share on other sites

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 ) )

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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

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

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

  • Who Viewed the Topic

    1 member has viewed this topic:
    Will Xu 
×

Important Information

By using this site, you agree to our Terms of Use.