Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
    Posts
  • #7524

    j796160836
    Participant

    Thanks to emeditor team for this userfriendly and powerful editor.
    Is that a Advenced Replacement Plugin that will bulk copy a template, replace some column which is already set and output.
    There is the expamle:

    File 1: Some data, separate by comma (First line is a column name)
    ———–
    store_name , Sales, Date
    Los Angeles, $1500, Jan-05-1999
    San Diego, $250, Jan-07-1999
    Los Angeles, $300, Jan-08-1999
    Boston, $700, Jan-08-1999
    ———–

    File 2: The template file
    ———–
    {$store_name} was sales {$Sales} at {$Date}.
    {nextrecord()}
    ———–

    The output will be:
    ———–
    Los Angeles was sales $1500 at Jan-05-1999.
    San Diego was sales $250 at Jan-07-1999.
    Los Angeles was sales $300 at Jan-08-1999.
    Boston was sales $700 at Jan-08-1999.
    ———–

    Thanks.

    #7525

    Yutaka Emura
    Keymaster

    j796160836 wrote:
    Thanks to emeditor team for this userfriendly and powerful editor.
    Is that a Advenced Replacement Plugin that will bulk copy a template, replace some column which is already set and output.
    There is the expamle:

    File 1: Some data, separate by comma (First line is a column name)
    ———–
    store_name , Sales, Date
    Los Angeles, $1500, Jan-05-1999
    San Diego, $250, Jan-07-1999
    Los Angeles, $300, Jan-08-1999
    Boston, $700, Jan-08-1999
    ———–

    File 2: The template file
    ———–
    {$store_name} was sales {$Sales} at {$Date}.
    {nextrecord()}
    ———–

    The output will be:
    ———–
    Los Angeles was sales $1500 at Jan-05-1999.
    San Diego was sales $250 at Jan-07-1999.
    Los Angeles was sales $300 at Jan-08-1999.
    Boston was sales $700 at Jan-08-1999.
    ———–

    Thanks.

    Yes, you can replace

    (.*?),(.*?),(.*?)

    with

    1 was sales 2 at 3

    using “Regular Expressions” on.

    In v9, the CSV (comma-separated) files are supported, and you can even more easily add text between columns!

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic.

Share with friends... Tweet about this on TwitterShare on FacebookShare on Google+Email this to someone