We help IT Professionals succeed at work.

New podcast episode! Our very own Community Manager, Rob Jurd, gives his insight on the value of an online community. Listen Now!

x

Replacing an extra character into WordPad file

238 Views
Last Modified: 2013-12-26
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
Comment
Watch Question

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

Author

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

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

Author

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.

 

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

Author

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

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?"

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.

Author

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?
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.