Forum Discussion

swright's avatar
swright
New Contributor III
5 years ago

How to search and replace in a csv file

I’m trying to design a pipeline that changes gets a zip file via sftp that contains a single csv file, then do a search and replace in the csv (in this case it is replacing all the values in a single...
del's avatar
del
Contributor III
5 years ago
Copy LinkReport

Check out the String functions replace and replaceAll

  • swright's avatar
    swright
    New Contributor III
    5 years ago
    Copy LinkReport

    Thanks Del, but I’m looking for something that will find and replace something in the entire file. If I can break the file into strings, do a replace, and then put the csv back together then I guess that could work but I’m not sure how to address all the rows and fields that I need in the csv. Maybe I’m misunderstanding your answer…

    Regards,

    Scott

    • alchemiz's avatar
      alchemiz
      Contributor III
      5 years ago
      Copy LinkReport

      Hi Scott,

      Good day, what I usually do is to use the replace function with regex args… for example I want to replace a group of characters within the boundaries of c-f and length is greater than 3 with <<SUCCESS>>

      in the mapper where you can access the whole content do the a string manipulation Base64.decode(Base64.encode($['content'])).replace(/([c-f]){3,}/gi,'<<SUCCESS>>')