Jump to content
Sign in to follow this  
cbflynn

Reformatting copied text

Recommended Posts

I have a problem with the format of text that is copied from the internet and pasted into a field.

In the table, I have the field set to a particular font and font size. When I manually type in the data the format is fine. However, I get a lot of the information I need from the internet. When I copy and paste the text from the internet into the field the formatting from the internet overrides the settings on the field.

Is there a way to force the field to change the formatting to specific settings after pasting the data in?

Thanks for any help you can provide.

Share this post


Link to post
Share on other sites

Hi cbflynn,

You can handle this problem in a couple of ways.

When you paste the data in, you can use the option key combined with command and v ( Cmd + Op + v) and it will past without the Clipboard style.

You can use the Auto Enter option for the Field, and use the TextFormatRemove ( text ) Function as your calculation. Be sure to deselect the option of "Do not replace existing values in the field (if any)"

HTH

Lee

Edited by Guest

Share this post


Link to post
Share on other sites

Thank you, Lee, for the info. The Cmd + Op + V option did not appear to work. However, the Auto-enter settings you suggested did work. Thank you.

Share this post


Link to post
Share on other sites

If you use custom menus, or want to start, you can duplicate the edit submenu and replace the paste command with a script step, "paste [no style]." This will change the command v to paste without style throughout the entire file.

Share this post


Link to post
Share on other sites

I forgot to tell you that to change the existing data, you would need to use the Replace function. This topic has been covered in the past too, but If you need help on how to do this, just post back and I explain further.

HTH

Lee

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  

×

Important Information

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