Replace based on input CSV file

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

@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.