I like to copy my variables from their locations in WEBI and paste them into MS Word to do modifications. I’ve noticed that if I begin to type using any common font in Word and copy-and-paste it back into WEBI, it will return an error for not recognizing the character due to its font. What fonts may I use in Word to keep this from happening?
Haven’t faced that issue, myself, likely to be some regional or unicode setting.
If you want a good txt editor for Webi, SQL etc I really recommend NotePad++.
What if you copied a formula from Word first to Notepad and then from Notepad to WebI? Will it work?
Taking a text from Word to clipboard takes not only the actual text but also some tags (or whatever Word adds there). So copying a text from Word to Notepad strips out everything but the actual pure text.
Thanks for the advice. I couldn’t find anywhere to make useful regional setting adjustments. I’ll ask about Notepad++, but I suspect they will not allow an installation of that on my work terminal.
The most likely culprits are curly quotes and em-dashes. Word likes to replace these things. Pretty much no other program likes to read them.
If you want to continue using Word, check in the spelling options for auto-replace. You ought to be able to find something about the various symbols. The exact location varies depending on your version.
Notepad is generally my go-to for quick coding. It is pretty minimally invasive.
You’re right, Lugh. It’s the quotes that are getting me. I have a lot of variables to rename things to group them afterwards. This requires quotation marks all over the place.
I’ll give the Notepad program a try next time, although I’m not as much of a fan.
Well, there are PLENTY of alternative text editors. Notepad++ is popular. I’ve been trying out one called JovialNotepad that supports RTF format. You could always break out vi or emacs.
Notepad just has the convenience of being the default Windows choice.
If you want to continue to use Word to do your editing, still keep Notepad open. When you want to copy the formula to WebI, paste it into Notepad first, pick it back up from Notepad and paste it into your variable. That strips off the non-standard characters.