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

Wrap it with a trim () then.

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

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

  • Who Viewed the Topic

    1 member has viewed this topic:
    Ron Cates 
×
×
  • Create New...

Important Information

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