non capital

[ForSSound]

@DetlevD

Another proposal.

1. Filter: "$len($regexp(%COMMENT%,'[^\r\n]',))" GREATER 0 2. TEMP <== %COMMENT% 3. TEMP <== $regexp(%TEMP%,'([^,])$','$1,') From: "ETHNO POP - ETHNIC POP MID ,arabazing, lanscape, walk, sharing MEDIUM,arabisant, paysage, partage, marche, ... " To: "ETHNO POP - ETHNIC POP, MID ,arabazing, lanscape, walk, sharing, MEDIUM,arabisant, paysage, partage, marche, ... " 4. TEMP <== $regexp(%TEMP%,'^(.+?)\r?\n(.+?)\r?\n.*$','$1 $2') From: "ETHNO POP - ETHNIC POP, MID ,arabazing, lanscape, walk, sharing, MEDIUM,arabisant, paysage, partage, marche, ... ... " To: "ETHNO POP - ETHNIC POP, MID ,arabazing, lanscape, walk, sharing," 5. TEMP <== $regexp($trim(%TEMP%,','),'\s*,\s*',', ') TEMP = 'ETHNO POP - ETHNIC POP, MID, arabazing, lanscape, walk, sharing' ---------- ... or ... 5a. Tag-Feld aufteilen Split field by separator Field: Temp Separator: , (Note: one letter: comma) 5b. Doppelte Tag-Felder zusammenfassen Merge duplicate fields Field : Temp Separator: , (Note: two letters: comma space) TEMP = 'ETHNO POP - ETHNIC POP, MID, arabazing, lanscape, walk, sharing' ---------- 6. TEMP <== $regexp(%TEMP%,'\b[\u\s/-]+\b,\s',) TEMP = 'arabazing, lanscape, walk, sharing'

DD.20140718.1845.CEST

Hi Thank you very much for the propositions.
I already opened a new thread here /t/15916/1
I also put partial solutions in green

Kind Regards
Guy Forssman