Product Export to CSV has Funny Characters - C# Discussion Boards

Wrap Text of a Toolbar Button or Normal Button

9-Jul-07 4:14

You're welcome.

Luc Pattyn

try { [Search CP Articles] [Search CP Forums] [Forum Guidelines] [My Articles] }
catch { [Google] }

shubhabratam9-Jul-07 3:09

shubhabratam

9-Jul-07 3:09

How do I wrap the text of a Toolbar button or of a Normal Button?

Ravi Bhavnani9-Jul-07 3:25

Ravi Bhavnani

9-Jul-07 3:25

Try using the \n (newline) char in the button's caption.

/ravi

This is your brain on Celcius
Home | Music | Articles | Freeware | Trips
ravib(at)ravib(dot)com

Luc Pattyn9-Jul-07 3:32

9-Jul-07 3:32

Hi,

most controls that have a Text property will display the text in one or more
lines. They wrap automatically if AutoSize is false, Width is insufficient,
and Height is sufficient to accomodate several lines of text.

And you can force a line break by inserting a newline ('\n') character.

Smile | :)

Luc Pattyn

try { [Search CP Articles] [Search CP Forums] [Forum Guidelines] [My Articles] }
catch { [Google] }

Vasudevan Deepak Kumar9-Jul-07 3:47

Vasudevan Deepak Kumar

9-Jul-07 3:47

If it is a HTML page then \n need to be replaced with <BR> tag. Isn't it?

Vasudevan Deepak Kumar
Personal Homepage
Tech Gossips

Luc Pattyn9-Jul-07 3:50

Product Export to CSV has Funny Characters

9-Jul-07 3:50

I dont know, but that could be correct (unless inside a PRE block).

Luc Pattyn

try { [Search CP Articles] [Search CP Forums] [Forum Guidelines] [My Articles] }
catch { [Google] }

Brendan Vogt9-Jul-07 3:09

Brendan Vogt

9-Jul-07 3:09

Hi,

One of my clients has exported his product list to CSV, and there are funny characters in the long description, and it is giving me errors when I try doing an import. The long description cell has little white blocks at the end of the text, almost like a new line. How would I test for something like this, and remove it?

What is it?

Regards
ma se

Re: Product Export to CSV has Funny Characters

Paul Conrad13-Jul-07 13:14

Paul Conrad

13-Jul-07 13:14

Is it unicode by some chance?

"Any sort of work in VB6 is bound to provide several WTF moments." - Christian Graus

write bytes to a file

WhiteGirl239-Jul-07 2:46

9-Jul-07 2:46

Hi,

I worked on a project which writes 2 doc files, in memory stream.
From the memory stream I wrote all the bytes to a file
something like this:
File.WriteAllBytes(path,mybytes).

The problem is that I can't see all the information.
But if I look in my file with Windows Commander the information which I can't see is there.

Where should be the problem?

Thanks for your help.

originSH9-Jul-07 2:53

originSH

9-Jul-07 2:53

WhiteGirl23 wrote:
The problem is that I can't see all the information.

"See all the information"? You've gone bind and now can't use a monitor? Your trying to use photoshop to open the doc file but the pixels arn't in the right place? Your highly advanced brain interface isn't causing the right electrical impulses in the visual processing part of your brain?

You might want to explain yourself in explicit developer terms rather than clueless user terms. i.e. "I try to look at the value in the watch panel in visual studio" or "if I then open the file in notepad I can't see the byte's I have written".

The problem could be that whatever your using to look at the data isn't interpreting it correctly or that the data is being written incorrectly. It's pretty hard to tell without being psychic or being given some pretty basic information.

WhiteGirl239-Jul-07 3:04

9-Jul-07 3:04

my code is:

//write in memory the files

   MemoryStream mem = new MemoryStream();<br />
            BinaryWriter bin = new BinaryWriter(mem);<br />
            bin.Write(unicodebytes, 0, number);<br />
<br />
         <br />
             bin.Write(unicodebytes1, 0, number1);

//unicodebytes,unicodebytes1 are vectors where I keep the bytes from the files
//read the files

   BinaryReader binread = new BinaryReader(mem);<br />
            mem.Position = 0;<br />
<br />
           <br />
            byte[]  byteArray = new byte[mem.Length];<br />

 int count;<br />
            count = mem.Read(byteArray, 0,1);<br />
            while (count < mem.Length)<br />
            {<br />
                byteArray[count++] = Convert.ToByte(mem.ReadByte());<br />
<br />
                File.WriteAllBytes("C:\\text1.doc", byteArray);<br />

My problem is that I can see the first file in Word but I can't see the second file.

Le centriste9-Jul-07 3:25

Le centriste

9-Jul-07 3:25

flush the BinaryWriter before re-reading the data.

<br />
MemoryStream mem = new MemoryStream();<br />
BinaryWriter bin = new BinaryWriter(mem);<br />
bin.Write(unicodebytes, 0, number);<br />
<br />
<br />
bin.Write(unicodebytes1, 0, number1);<br />
<br />
bin.Flush(); // <<<----------------<br />
<br />

-----

If atheism is a religion, then not collecting stamps is a hobby. -- Unknown

WhiteGirl239-Jul-07 3:30

9-Jul-07 3:30

thank for your help but still doesn't work

Luc Pattyn9-Jul-07 3:29

9-Jul-07 3:29

try to explain the context : what are you trying to achieve ?
is it binary data ? text ? in ASCII ? in Unicode ?
are they both Word documents ?
where does the data originate ? show the declarations !

and specify the symptoms in detail: what does "can see" mean ?
is the first file OK, or just recognizable ?
and what about the second: nothing at all, some garbage,
some parts recognizable, what ?

if you are not explicit about these, you either will get no answers, or some
answer that is as mysterious as your questions are...

Smile | :)

Luc Pattyn

try { [Search CP Articles] [Search CP Forums] [Forum Guidelines] [My Articles] }
catch { [Google] }

WhiteGirl239-Jul-07 3:34

9-Jul-07 3:34

the first file is seen very good.
My files are document files.

But the second file is missing.
I turned my documents files in bytes and these files are written to the memory stream.

From the memory stream (where I have the 2 documents in bytes)I want to see the 2 files in one file.
Thanks.

Luc Pattyn9-Jul-07 3:44

9-Jul-07 3:44

Now who claims that appending two document files would result in one document file
with all the document content ?

You can use a hex dump utility (Visual Studio !), or maybe Wordpad, to check
your concatenation succeeded technically, Word has already proven it did not
succeed functionaly.

You can concatenate two text files, two C# source files (that will result in some
compile errors tho), maybe two mp3 files. But you cant get the result you're after
when you concatenate two JPEG files, two Visual Studio project files,
two MS Word files, etc.
You need something smarter and more difficult to achieve that.

Smile | :)

Luc Pattyn

try { [Search CP Articles] [Search CP Forums] [Forum Guidelines] [My Articles] }
catch { [Google] }

Le centriste9-Jul-07 3:36

Le centriste

9-Jul-07 3:36

There are a couple of things strange in your code.

1- You assign a BinaryReader but you do not use it.
2- You are writing a bunch of bytes to a MemoryStream. Are you just trying to copy the 2 byte arrays to a single file (if not, what your code is doing totally escapes me)? This is not really needed. Try this instead:

FileStream fs = File.Create(@"C:\text.doc");
fs.Write(unicodebytes, 0, unicodebytes.Length);
fs.Write(unicodebytes1, 0, unicodebytes1.Length);
fs.Flush();
fs.Close();

If this is not the case, please explain what you are trying to do.

-----

If atheism is a religion, then not collecting stamps is a hobby. -- Unknown

WhiteGirl239-Jul-07 3:43

9-Jul-07 3:43

thanks for your help but I have the same problem.
I can see the first file but I can't see the second.

I want to copy 2 documents files in one file.

Le centriste9-Jul-07 3:56

Le centriste

9-Jul-07 3:56

Did you try to run it through a debugger? is it possible that unicodebytes1 is empty?

Make sure your 2 byte arrays actually contain the bytes.

-----

If atheism is a religion, then not collecting stamps is a hobby. -- Unknown

WhiteGirl239-Jul-07 4:05

9-Jul-07 4:05

thanks for your help.

The size of my new created file is equal with the size of the first file + the size of the second file.

The unicodebytes1 is not null.

thanks again.

originSH9-Jul-07 4:24

originSH

9-Jul-07 4:24

Combining 2 word documents by appending one to the other will never work. Your barking up the wrong tree.

originSH9-Jul-07 4:04

originSH

9-Jul-07 4:04

If your trying to combine 2 wrod doc's it's not that simple.

Word docs use Structured Storage[^] (aka DocFile[^]) for pre 2007 files.

For 2007 there is a new XML format ... you can do your own google for that :P

Either way you cannot simply concatenate these documents.

WhiteGirl239-Jul-07 20:21