Jump to content
Macro Express Forums

Copying Underlined Decimal Data To D1


Macronovice
 Share

Recommended Posts

If I copy decimal data that has a line underneath from a website to D1 it doesn't copy the data, I assume it’s the underline that's causing a problem.Any ideas on how I can copy the data to D1 without the underline?

 

Don’t know if this will help but the decimal data could be copied to any of the variables; it doesn't have to be D1.

 

Thanks lemming. Got it working after a bit of messing about ;)

 

macronovice.

Link to comment
Share on other sites

You probably need to clean up your copied data before sticking it into a decimal variable. Anything that is not a number or period will make it invalid, i.e. set to zero.

 

I'd suggest copying the data to a String variable first, then using Modify String Variable to Trim spaces and Strip CR/LF.

 

Underlining is not copied into a String variable so you shouldn't need to worry about that. But look out for other non-numeric chars like underscores or tabs. You can get rid of those by using the Replace Substring option.

 

And finally, you will need to do a String to Decimal conversion using the Modify String Variable command again, this time with the Convert To Decimal option.

Link to comment
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.

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.

Loading...
 Share

×
×
  • Create New...