Cleaning Up Catch from OutWit

Export the Catch of Table of Exploded Queries

Search and Replace within Excel to clean up the  s etc

Copy the column containing the javascript corresponding to new nodes into Notepad++

Search and replace to clean up javascript – need to shorten the script before trying to import back into excel

within Notepad plain – need to replace any commas with a period – since we’re going to save file with .csv extension

Open the .csv file within Notepad and save as textfile with .csv file – this file (and for some reason not the Notepadd++ file can be imported into a  new excel worksheet,  and we then copy that column into the original excel file

The following two tabs change content below.


Latest posts by allenpg (see all)

Leave a Reply