Hi All,
I use SQL to export oracle transactions to a text file which are separated by the "~" tilde delimiter. Come to find out folks use the tilde in the journal descriptions, which, of course, means I would have faulty data upon importing those text files to another db.
I have since updated my oracle queries strip out the tilde on future exports...
My question: since I created 15 huge text files (700meg-1.1G), it will take a while to delete/recreate those text files... I was thinking that since I have NotePad++ and TextPad, I'd like to use a regular expression in order to identify the lines that have 'more than' 24 tildes. From there I can go to the description area and delete the extra(s) tilde then save file.
Hope that makes sense.
Thanks,
Drew
I use SQL to export oracle transactions to a text file which are separated by the "~" tilde delimiter. Come to find out folks use the tilde in the journal descriptions, which, of course, means I would have faulty data upon importing those text files to another db.
I have since updated my oracle queries strip out the tilde on future exports...
My question: since I created 15 huge text files (700meg-1.1G), it will take a while to delete/recreate those text files... I was thinking that since I have NotePad++ and TextPad, I'd like to use a regular expression in order to identify the lines that have 'more than' 24 tildes. From there I can go to the description area and delete the extra(s) tilde then save file.
Hope that makes sense.
Thanks,
Drew
