How to remove un-wanted text from notepad files?

• Jobs90312

  Mr or Mrs. 500

  Points: 533

  More actions

  July 20, 2022 at 5:17 am

  #4065694

  Hi everyone,

  So I have a folder which contains 23 files which were generated from a SSIS package (SQL data converted to XML files).

  These files are .xml extension and named like Individual_1.xml, Individual_2.xml, Individual_3.xml, Individual_4.xml and so on....

  Each file is around 500-800 mbs.

  In these files there is some un-wanted text that I want to replace.

  Originally I did this using a powershell query with in the SSIS package but for some reason its not working anymore.

  Can anyone suggest any other way I can achieve this?

  What I want is that when I run the ssis package and files are generated, in the last step all files are edited one by one and remove/replace the text and save the file....

• Phil Parkin

  SSC Guru

  Points: 246993

  More actions

  July 20, 2022 at 7:42 am

  #4065766

  Fixing your PoSh script is probably a good way to proceed.

  The absence of evidence is not evidence of absence.
  Martin Rees

  You can lead a horse to water, but a pencil must be lead.
  Stan Laurel