• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 224
  • Last Modified:

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
0
pappasth
Asked:
pappasth
  • 4
  • 4
1 Solution
 
Glenn_MooreCommented:
How do you generate the wordpad file?  Can you filter out the " in the file generation process?
0
 
pappasthAuthor Commented:
I use a math formula in excel in order to create the numbers and then I convert the excel file to wordpad file.  
0
 
peetmCommented:
>>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.
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
pappasthAuthor Commented:
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.

 
0
 
peetmCommented:
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.
0
 
pappasthAuthor Commented:
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
0
 
peetmCommented:
"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.
0
 
pappasthAuthor Commented:
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?
0
 
peetmCommented:
Send it to peet.morris@comlab.ox.ac.uk

I still don't know what you mean by 'notepad format', i.e., is it tab-delimited text, unicode text, MS-DOS text ...

Those are more-or-less all the text versions available in Excel.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

  • 4
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now