Script for replace any substring in a text file accodring a csv data file

[Contro]

Script for replace any substring in a text file accodring a csv data file

Replace or add substring to a text file according a csv file.

Best Regards
 

[Target]

more detail needed, eg what criteria would you use to determine whether to add or replace

[Ath]

Despite its name, my tool Excel2Html can be used for this exercise, if the .csv file is converted (loaded) into a .xls or .xlsx file.
And a .html template is plain text, of course.

Relevant DC threads (original Coding snack request and support-thread) are available from the link.

[Contro]

more detail needed, eg what criteria would you use to determine whether to add or replace

-Target (April 30, 2015, 09:08 PM)

Two options then :
1. The first one where do you want to insert

2. The second option replace is more simple : I have to select or indicate the substring to be replaced in the original files.

The original files are always inside a folder.

[Contro]

Despite its name, my tool Excel2Html can be used for this exercise, if the .csv file is converted (loaded) into a .xls or .xlsx file.
And a .html template is plain text, of course.

Relevant DC threads (original Coding snack request and support-thread) are available from the link.

-Ath (May 01, 2015, 01:41 AM)

I'll take a look. But I think better a dedicated tool.

Best Regards Ath
 

[Contro]

I think a script of this must exist....

A good string to search in Saint google ?

 

[Contro]

In my case i think is simpler. I need only one parameter.
A good script for this ?

Loop, Read

FileAppend, % A_LoopReadLine, % SubStr("00" A_Index, -2) ".script.iim"

return

 

[kyrathaba]

Can you give me an example of two or three strings and then the contents of a CSV file and how you'd want to apply those contents toward extraction/replacement of substrings?

If you can give me some real world examples, I might be able to tackle this for you, OP.

[Target]

In my case i think is simpler. I need only one parameter.

-Contro (May 04, 2015, 08:28 AM)

simpler than that...

this is (untested) in AHK...

[Select]

inputbox, srch, Search String                      ; get a search string

inputbox, rep, Replacement string                  ;get a replacement string

fileselectfile, tmp_,,,Select a file, CSV(*.csv)   ; select a csv file

fileread, tmp_2, %tmp_%                            ; read in to a variable

stringreplace, %tmp_2%, tmp_2, %srch%, %rep%, all  ; replace all occurrences of the srch string with the rep string

fileappend, %tmp_2%, %tmp_%.csv                    ; write out to a new file

exitapp