asked on

Replacing an extra character into WordPad file

I have three WordPad files which contain my daily data in correct format. The problem is that this format contains an extra character ( a speech mark " ) which I need to delete it every day. I have tried to write a VBA doing that "easy" job but when I save the files and open them again, they have more extra characters ( " ).
What I do manually is to open these files then ctr+H ----> find what: the extra character which is a speech mark " and replace it with nothing.
Any help?

Thank you in advance,

Theo

Glenn_Moore

How do you generate the wordpad file? Can you filter out the " in the file generation process?

pappasth

ASKER

I use a math formula in excel in order to create the numbers and then I convert the excel file to wordpad file.

peetm

>>I use a math formula in excel in order to create the numbers and then I convert the excel file to wordpad file.

How do you do the last bit, the conversion?

Why WordPad, i.e., what's special about WordPad here [if anything].

== From a previous answered similar Q on EE ==

Another alternative is to paste-special the formula results into WordPad or Word as RTF format. This produces the expected output and the same results shown in the cell formula (ie: no leading or trailing "s or embedded double ""s.) Pasting into these applications as Text will produce the same results as Notepad.

pappasth

ASKER

I save the excel file as notepad (or wordpad) format and when I open this file in notepad format, each row contains the same extra character ("). How can I save an excel file in wordpad or notepad format without adding an extra character?

I need to use wordpad or notepad format because I feed a system with these files.

peetm

I've tried saving a dummy spreadsheet as .txt, and cannot replicate the problem.

What format are you saving in from Excel, and what are you saving [sample?] - if I can duplicate the output I can better help perhaps.

pappasth

ASKER

I save it in nam format. I am saving the following sample. I need to save it as wordpad (or notepad) since the data should line up in order the system to accept the file. For that reason, I can not use Word format. Any idea?

F,Default08Oct2007,*UPDATE,2
M,RI,ATH,MDBK,678,789,WQ-ASNE,MWQ,GWQ,,Yeq Matrix,ABSOLUTE,ABSOLUTE,RELATIVE,0.00000000,0.00000000,GBP,0.00000000,0.00000000
P,,0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,0.00000000
P,0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,0.00000000
P,0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,0.00000000
P,0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,0.00000000
P,0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,0.00000000
P,0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,0.00000000
P,0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,0.00000000
M,FX,LOH,MDBK,610,558,FX-ASNE,USD,GBP,,FX Adj Matrix,ABSOLUTE,ABSOLUTE,RELATIVE,0.00000000,0.00000000,GBP,0.00000000,0.00000000
P,,0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,0.00000000
P,0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,0.00000000
P,0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,0.00000000
P,0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,0.00000000
P,0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,0.00000000
P,0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,0.00000000
P,0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,0.00000000,0.00000000

peetm

"I save it in nam format. I am saving the following sample. I need to save it as wordpad (or notepad) since the data should line up in order the system to accept the file. For that reason, I can not use Word format. Any idea?"

I have no idea what 'nam' format is - it doesn't appear as a format under 'Save As...' in Excel.

Can you email me a sample spreadsheet - so that I can save it? And, please specify the format used again - unless 'nam' is correct - in which case I can't duplicate it.

pappasth

ASKER

Sorry the name of my file is sth.nam. I save this file in notepad format. How can I email you a sample spreadsheet? How can I attach it from here?

ASKER CERTIFIED SOLUTION

peetm

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial