• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 220
  • 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
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
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

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

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