By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,392 Members | 1,561 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,392 IT Pros & Developers. It's quick & easy.

Concerns about text and compatibility with Google

P: 99
Hi,

I have to create a database to manage Google Adword accounts. The client would like to be able to cut and paste text generated in Access into Google's Adword Editor.

One thing that concerns me is the way Access puts out text. Access text typically has End-Of-Line (EOL) and Carrage-Return (CR) characters at the end of a phrase of text. I use these characters in processing and I don't want to do away with them completely. I would just like to remove them from output so the text will be more compatible with Adword Editor.

Does anyone know how Access text should be modified so it will be more compatible with other programs like Adword Editor?

I've tried using the MID() function to crop the EOL and CR from the end of a string, but it doesn't seem to work.

Does anyone know if lines of text with EOL and CR will even be a problem for Google's Adword Editor?

Thanks for any help
Adam
Aug 21 '08 #1
Share this Question
Share on Google+
2 Replies


missinglinq
Expert 2.5K+
P: 3,532
Steve Miller has a neat little app called PureText that you can download for free from here:

http://www.stevemiller.net/

Once downloaded, youcan copy formatted text, click on the PureText icon in the tray at the bottom of Windows, and the content will be converted to straight text only. Then simply paste.

Welcome to Bytes!

Linq ;0)>
Aug 21 '08 #2

P: 99
Linq,

Thanks for the welcome!

I've downloaded the software you suggested and I'll check it out but I was hoping to clean up the text in Access and save my user the extra step. My user is the type that would forget to use the clean-up program and I'll find myself fixing their files. :)

Is there a way to clean up the formatted text in Access?

Thanks
Adam
Aug 21 '08 #3

Post your reply

Sign in to post your reply or Sign up for a free account.