Exporting a portion of data for each line in a Keyword Group and moving that data to another Keyword in the same Group.

[David_Ventura]

We have a Keyword Group that has three keywords. The First Keywork in the MIKG is 11 characters. The first two characters and the second two character represent divison and branch. 

We have a keyword in the group for Division and Branch.

We want to look at each line in the MIKG and copy the 1st two characters to the Division KW and the 3rd and 4th characters tot he Branch Keyword. 

Example of the data, we are trying to fill out the Division and Branch fields.

GL Code	Division	Branch
14214567800	14	21
34122345600
96213123400
45122987600

Appreciate anyone's help.

[James_Perry]

I would do this with an autofill keyword set. I would export the full list to a csv, create a powershell script to parse the csv, grab the first two characters into column 2, and grab the next two into column 3. Then I would configure the afks importer to update all records.