[Isis-users] Global Change

[fred train]

Hello Piet
I do have about 1200 location codes.

After some more puzzling I found a solution that might work.
Step 1: extend all location code codes with a unique delimiter (e.g. a 
minus sign). This is 1200 global changes on the original keywords field.
Step 2: Select all records with the delimiter, and Split the field 
"before" the delimiter and "Move" to the target field. This is one 
global change and moves all location codes, without the delimiter, to 
the target field. The original entries in the old field are gone.
Step 3:1200 global changes to transform the abbreviations into readable 
strings in the location field.

Labor intensive, but perhaps possible to automate with a script.
Hints are welcome of course

Thanks & Regards
Fred


Op 5-12-2017 om 17:52 schreef Piet De Keyser:
> Fred,
>
> Do you have a limited number of location codes or is it rather unlimited?
>
> Piet de Keyser
>
> -----Oorspronkelijk bericht-----
> Van: isis-users [mailto:isis-users-bounces+piet.dekeyser=ucll.be at iccisis.org] Namens fred train
> Verzonden: dinsdag 5 december 2017 17:37
> Aan: Isis Comunidad <isis-users at iccisis.org>
> Onderwerp: [Isis-users] Global Change
>
> Hello guru's
>
> We have repeatable field called Keywords.
> This field contains for historical reasons also coded location information.
> A Keyword field could have entries like
> Colored; upside; metal; painted; GLD; LIM; NLD; sale The semicolons are added by the PFT. Each keyword has its own record.
>
> We have created a new repeatable field called Locations. And the location entries from the keywords should be moved to the new Locations field and also translated into more readable strings.
> The end-effect after the operation should look like:
>
> Keyword: Colored; upside; metal; painted; sale
> Locations: Gelderland(GLD); Limburg(LIM); Netherlands
>
> The idea was to apply a global change for each of the keywords GLD, LIM and NLD.
> I can modify the strings into their target strings (e.g. GLD becomes
> Gelderland) in the keywords.
> But the Move option in Global change moves all entries of Keyword to Locations.
>
> Is there a solution for my problem?
> In other words: Is it possible with Global Change or another option to move some entries from the source repeatable field to a target repeatable field?
> Regards
> Fred
>
> _______________________________________________
> isis-users mailing list
> isis-users at iccisis.org
> To manage your own subscription options go to: http://lists.iccisis.org/listinfo/isis-users
> Or contact Henk Rutten: hlrutten at xs4all.nl