Notepad replace all

Hello,

I am have a large (very large, 138k rows) spreadsheet that a coworker needs in a an .xls format for the backend of an application. I understand that this wont work, due to .xls row limits so, we decided on a delimited file. Whatever wizard she is using (i am unfamiliar with) to import the data into her application gives her the option for a | (pipeline) delimited file.

I saved the report as a tab delimited file with the intention to do a replace all from tab character to |. I am currently using this routine but....

Please Login or Register  to view this content.

Notepad doesn't seem to recognize the Tab string.

This is driving me nuts.

Hello MMaher,

Change the FileName and FilePath variables to what you need. This works with Excel 2000 and up.

Please Login or Register  to view this content.