What Fonts Are Allowed in WEBI Variables?

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?


mcm1979 :us: (BOB member since 2014-11-19)

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++.


Mak 1 :uk: (BOB member since 2005-01-06)

Hi,

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.

Maybe it will work. Try and let us please know.


Marek Chladny :slovakia: (BOB member since 2003-11-27)

Hi Marek, thing is, copying and paste from word works fine for me. Even using the internally created font…


Mak 1 :uk: (BOB member since 2005-01-06)

OK, got it.

I have never copied formulas from Word to WebI, so I did not know it worked.


Marek Chladny :slovakia: (BOB member since 2003-11-27)

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.


mcm1979 :us: (BOB member since 2014-11-19)

Personally, I use (Windows) Notepad. I keep it pinned on my desktop for just such editing.


jwaterbury :us: (BOB member since 2007-09-21)

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.


Lugh (BOB member since 2009-07-16)

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.


mcm1979 :us: (BOB member since 2014-11-19)

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.


Lugh (BOB member since 2009-07-16)

Hi Lugh, good catch with regards to the quotes… :slight_smile: I had forgotton that those have caused issues for me in the past.

What I like about Notepad+ is you can colur the brackets and keywords etc. In fact I actually picked up a Webi XML add in for the wweb.


Mak 1 :uk: (BOB member since 2005-01-06)

UltraEdit :+1:

or, alternatively, Emacs.


joepeters :us: (BOB member since 2002-08-29)

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.


Bill K (BOB member since 2011-02-24)

That seems reasonable. I’ll give that a shot with my next edit. Thanks, Bill K.


mcm1979 :us: (BOB member since 2014-11-19)