Remarks field character size
I have been looking at changing the caracter size of the Remarks field on the
PO. I have been getting some feed back that I shouldn't do that because its
going to make the database unstable.
The current size of the Remarks field is set to 30 characters and it just
don't cut it for the PO. If we have to add a special instruction we can't.
Does any one know anything about the stability issue or how to increase the
Don't they explain this stuff when you become a "Microsoft Partner"?
"Yaniv Zahavi" &l...character replacement in attached XML
We use ascii 253 as a separator for some information contained in a long string that we include in an XML attachment.
For some reason there are a couple of computers using Outlook where that ascii character is getting replaced.
As far as I can tell it isn't replaced on the sending system (I can receive the email in my Outlook and the characters have not been replaced in the attached XML file). But there are two computers where this character is being changed somehow when they receive it in their Outlook.
Any ideas on how and why this would happen?? And how we can stop it?...Clipboard for Unicode and Non-Unicode
We have a progarm write with non-unicode. I found that in some
language, the character can not be pasted to CEdit correctly. For
example, if our application is running on Russian XP, the string copy
from IE can be pasted to CEdit properly. But if I pasted the same
string into Notepad, and then copy the string from notepad to our
CEdit, the string can not show corectly. Is it a coding problem? Is it
possible to make CEdit to accept the string from notepad?
If it is a question of pasting a UTF16 string into a single-byte edit
control, you could try it in two stages:
L...Removing/replace special character in a field
I have a table with a field for names. Some entries include the ampersand
(&); for example, John & Mary Smith. The database is also FTP to our web site
and a query, as a stored procedures, is used on an ASP to display
information. The name is selected via a drop-down combo list box on the page.
The problem is the & char drives the html validator crazy; 300+ errors, one
for each name that contains the &. I know in VBA you can use the replace
function to "strip" out a character or string. I've tried substitute and
replace in the query but they are not...Unicode CFileDialog in non-Unicode app how?
We have a non-Unicode app that in a few cases uses some Unicode features
(deliberately, for example by specifying CStringW).
The problem we're encountering, is that I would like to use the common "File
Save" dialog, but pass it an initial filename that is not necessarily in the
same language as the Windows install language.
The default GetSaveFileNameA() (which is what CFileDialog::DoModal() calls)
is unhappy when I do this, it fails and CommDlgExtendedError() returns
FNERR_INVALIDFILENAME which is not entirely unexpected.
It looks like MFC has a few Unicode features avai...Excel 2001 and characters limitation
In Excel 98, when you insert a lot of graph, you had memory problems 'out of
memory' box appear' already if you had a lot of memory reserved for Excel.
It's because of 255 characters limitation.
Excel 2001 had the same problems or not?
Thank to answer,
Service informatique / Informatic service's
I found the res^ponse: yes, excel 2001 had the same limitation !!!
Bad news !!!
Service informatique / Informatic service's
D.Chenu@sa...Unicode Sorting of Greek Words (Gentium Font)
Hi. I am using MS Excel 2007. Two columns contain unicode (Greek) text in
Gentium font. I need to sort these columns. How can this sorting be done in
Greek alphabetical order? Thanks.
...Convert UTF-16 Unicode to UTF-8 Unicode?
If I save an Excel file as "Unicode Text" (xlUnicodeText), I get a tab-
delimited UTF-16 (also known as UTF-7) unicode file.
How can I convert it to UTF-8?
I've been doing the conversion by automating Word from Excel:
Const WORD_TEXT_FORMAT As Long = 2 'FileFormat:=wdFormatText
Const WORD_UTF8_ENCODING As Long = 65001 'Encoding:=65001
Filename:="save as UTF-8.txt", _
However, now I need to convert from UTF-16 to UTF-8 on computers that
may not ha...Deleting Leading Characters
I just exported a file from monarch to excel. Unfortunately, some of th
columns have a leading (') in each of the cells. I tried using TRIM, bu
it did not work. How can I delete the leading character (')? I have 50
rows with multiple columns :
intheway's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=672
View this thread: http://www.excelforum.com/showthread.php?threadid=26923
try replacing ' with ""
----------------------------------------------...Which one of the below list is UNICODE charset?
Which one of the below list is UNICODE charset?
Specifies the character set. The following values are predefined.
Korean language edition of Windows:
Middle East language edition of Windows:
Thai language edition of Window...Outlook 2003 non-Unicode to Unicode
How can I change my mailbox mode from non-Unicode to
You can't; you'll need to create a new pst-file and import the old one.
Robert Sparnaaij [MVP-Outlook]
Tips of the month:
-Create an Office XP CD slipstreamed with Service Pack 3
"glenn" <email@example.com> wrote in message
> How can I change my mailbox mode from non-Unicode to
File, New, Outlook data store and add the default store type - then Tools,
Accounts to set it as def...How to distribute characters in a cell?
How can I distribute in a cell text characters with even spaces?
Select the cells and run this macro:
b = " "
For Each r In Selection
v = r.Value
l = Len(v)
t = ""
For i = 1 To l
t = t & Mid(v, i, 1) & b
r.Value = t
a b c 1 2 3
Gary''s Student - gsnu2007g
> How can I distribute in a cell text characters with even spaces?
Thank you for your response. I have never used macro so that this is a
good opportunity for m...Unicode support
I'm trying to send an excel sheet in Franch and German
threw a java application. However, special characters are
displayed incorrectly. Does excel support unicode, and
which type of it?
<firstname.lastname@example.org> wrote in news:email@example.com:
> I'm trying to send an excel sheet in Franch and German
> threw a java application. However, special characters are
> displayed incorrectly. Does excel support unicode, and
> which type of it?
A little bit. I believe it uses UTF-16 internally.
You may have to use an Asian version of E...Chinese characters in Mail
We are trying to get an Outlook e-mail to print Chinese characters instead
of the gobbledygook that is appearing now. We installed the Simplified
Chinese pack, but while we received new fonts, we were not able to read the
text in the e-mail. We even tried selecting the text and changing the font,
but this did not work. Help! we are having an issue in both Outlook 2000 and
...Why has my cell text been replaced by # characters?
I have an excel spreadsheet that contains text only and the text has been
replaced with # characters in two of the longest sentences. I have wrap
turned on for all cells and thought that the character limit for a cell was
on the order of thousands.
Try changing that cell's format from Text to General.
(Strings with lengths between 255 and 1024 can cause trouble.)
And you can put 32k worth of characters into a cell, but only about 1000 will
show up--unless you add some alt-enters (to force new lines within the cell).
I put alt-enters every 80-100 characters.
> ...Forcing String Literal as Wide Character Unicode
Hello, I am under the impression that using _T("...") will convert my
string literal to either a char or a wchar depending on what is
defined, but I would like to force my string literal to be a Unicode
String ( i.e wchar_t )
How would I do that?
Would it be something like:
wchar_t string = "hi";
something like that? Or is there a way to force my literal string to
"sleeper" <TheFakeJon@gmail.com> wrote in message
> Hello, I am under the impression that using _T("...&q...Finding Characters
Hi MVP's and other smart people,
I have a column of data (A1 thru A11500) with names or addresses etc. I would like to know if there is a way to display "Delete"
or similar in the adjacent cell in the same row but the next column (B1 thru B11500) where any particular cell in column 'A'
contains certain characters amongst the data within that cell.
I have done this many times using the 'IF' formula when it necessarily matched the entire cell contents but it's only 1 or 2
characters contained within the contents of each cell that I need to match this time.
I want to make an application for international use which should all
languages(which unicode support).
So i want to know how to change language?
or in ther words, how to change my Locale( at run time).
Just upgraded to 2003 are their any advantages? /disadvantages to using the
new pst format that I should be aware of
The new pst format cannot be read by earlier versions of Outlook. Outside
of that the advantages are...
1) Unicode support
2) Increased storage (20GB soft limit, but depending on format of drive your
mileage will vary)
"Blacklab" <firstname.lastname@example.org> wrote in message
> Just upgraded to 2003 are their any advantages? /disadvantages to using
> new pst format that I should be aware of
&g...How do I delete the last character in a field in Excell?
for some reason when i export my contacts to a csv the email addresses are
not separted by a comma but by a semicolon.
i used the formula that seperates first name and last name together into two
seperate columns searching for semicolon instead of space.
the result is that a proportion of the email addresses are suffixed by a
how do i delete the semicolon?
You could just use Find/Replace for this to keep life simple.
"andrewcodd" <email@example.com> wrote in message
news:C58BCDAC-C7BF-4340-9D64-E3F1880E6F36@microsoft....find characters in text string
In a spreadsheet, I have a text string with names (not fixed location).
I want to find the 3 characters of the name and if it matches show it
as the result in the column. For that I have added in 1 column a table
with the possible 3 characters of the name.
With the LEN, SEARCH and MID function I have been able to do this
partially. It only works when the 3 characters to search for is on the
Please help with a smart solution.
Can you give a specific example please?
"JAYB" <firstname.lastname@example.org> wrote in message
news:1125608922.812220.279900@g47g2000c...Need to find the maximum character count for Outlook Note
If anyone has information on the maximum character count
or kb size of an Outlook Note, I would greatly appreciate
having the information passed on.
I am trying to use character map to enter a certain symbol into a document.
I have the character code and font installed but am having difficulty
actually typing in the code. It is the code for a check mark in the Symbols
font. It says the code is 0xD6. I believe I am suppose to hold down the ALT
key and use the numberic keyboard, but there are no letters on the numberic
keyboard. Also I don't know what the "x" means. Does that mean push the "x".
I have tryed many different ways to enter this but it does not produce the
check mark. Please advise. Al...How do I create a Chart from character data?
Need to create a chart from character data. Do I use pivot table or bar/pie
chart and do I need to create a Macro?
Basically, how do I do this?
Is this a column of text, and you want a chart to show the frequency of
each item in the list?
If so, add a heading to the column, then create a pivot table to
summarize the data, and create a pie chart from the pivot table results.
In your pivot table, add the text field button to the row area, and
another copy of the same field button to the data area, where it will
become 'Count of text'.
There are instructions for pivot tables in...Good Books on MFC that covers Threads,Process,Unicode suitable for vista
I want to learn some advanced concepts in MFC like Threads,Process and
even developing 64Bit application for vista(if possible). Please
suggest me some books which are easy to read and understand.
I had a look at programming applications for microsoft windows by
jefrey richter but it is mostly on win32 so i didnt spent too much of
time reading it. Should i read that first before going for another book
Thanks in advance
> I want to learn some advanced concepts in MFC like Threads,Process and
>even developing 64Bit application for vista(if possible). Please
>suggest me ...