Community

    • Login
    • Search
    • Recent
    • Tags
    • Popular
    • Users
    • Groups
    • Search

    Replace based on input CSV file

    Help wanted · · · – – – · · ·
    2
    2
    67
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • Willem Swanepoel
      Willem Swanepoel last edited by Willem Swanepoel

      I have a csv file that contains search strings/replace strings.

      Can I use it as input to search and replace strings in another file?

      CSV FIle looks like this:
      ? ALEF,א ALEF
      ? BET,ב BET
      ? GIMEL,ג GIMEL
      ? DALET,ד DALET
      ? HE,ה HE
      ? WAW,ו WAW
      ? ZAJIN,ז ZAJIN
      ? GET,ח GET
      ? TET,ט TET
      ? JOD,י JOD
      ? KAF,כ KAF
      ? LAMED,ל LAMED
      ? MEM,מ MEM
      ? NUN,נ NUN
      ? SAMEK,ס SAMEK
      ? AJIN,ע AJIN
      ? PE,פ PE
      ? TSADE,צ TSADE
      ? KOF,ק KOF
      ? RESJ,ר RESJ
      ? SJIN,שׁ SJIN
      ? SIN ? SJIN,שׂ SIN שׁ SJIN
      ? TAW,ת TAW

      So I want to search a file for all the strings on the left and replace y the string to the right of the comma.

      Alan Kilborn 1 Reply Last reply Reply Quote 0
      • Alan Kilborn
        Alan Kilborn @Willem Swanepoel last edited by Alan Kilborn

        @Willem-Swanepoel

        You would likely need to use a scripting plugin for such replacement. Maybe search this forum for “replace from list” or something similar.

        For example, THIS appears to be a script that solves a problem similar to your need, although not exactly.

        Sometimes a regular expression replacement operation can do it, by combining your data and your list together in a single file tab, but this method may not be reliable on larger data sets.

        1 Reply Last reply Reply Quote 1
        • First post
          Last post
        Copyright © 2014 NodeBB Forums | Contributors