Spreadsheet: 877843d1724789387-add-remove-substring-from-a-string-sample-file_082724
Sheet: Sheet1

Before |  |  |  |  |  |  |  | After
COSTCENTER ID | COSTCENTER DESCRIPTION | PARENT NODE | Column1 | Column2 | READ | WRITE |  | COSTCENTER ID | COSTCENTER DESCRIPTION | PARENT NODE | Column1 | Column2 | READ | WRITE
100100 | Department 1 | ACCTG |  |  | ACTJB14 | ACTJB14 |  | 100100 | Department 1 | ACCTG |  |  | ACTJB14;CHUESMA | ACTJB14;CHUESMA
100105 | Department 2 | ACCTG |  |  | [NAME] | [NAME] |  | 100105 | Department 2 | ACCTG |  |  | [NAME] | [NAME]
100200 | Department 3 | ACTUARY |  |  | [NAME] | [NAME] |  | 100200 | Department 3 | ACTUARY |  |  | [NAME] | [NAME]
100210 | Department 4 | ACTUARY |  |  | [NAME] | [NAME] |  | 100210 | Department 4 | ACTUARY |  |  | [NAME] | [NAME]
100270 | Department 5 | MEDICAL |  |  | RKNEE;ATRXF21 | RKNEE;ATRXF21 |  | 100270 | Department 5 | MEDICAL |  |  | RKNEE;ATRXF21 | RKNEE;ATRXF21
100300 | Department 6 | IT_OTH |  |  | CHUESMA;JFITTZ;KSTARBA | CHUESMA;JFITTZ;KSTARBA |  | 100300 | Department 6 | IT_OTH |  |  | CHUESMA;JFITTZ;KSTARBA | CHUESMA;JFITTZ;KSTARBA
100345 | Department 7 | EIS |  |  | CHUESMA;JFITTZ;KSTARBA | CHUESMA;JFITTZ;KSTARBA |  | 100345 | Department 7 | EIS |  |  | CHUESMA;JFITTZ;KSTARBA | CHUESMA;JFITTZ;KSTARBA
100350 | Department 8 | DIG_TRANSF |  |  | RTULENF | RTULENF |  | 100350 | Department 8 | DIG_TRANSF |  |  | RTULENF | RTULENF
100410 | Department 9 | ESD |  |  | CHUESMA;JFITTZ;KSTARBA | CHUESMA;JFITTZ;KSTARBA |  | 100410 | Department 9 | ESD |  |  | CHUESMA;JFITTZ;KSTARBA | CHUESMA;JFITTZ;KSTARBA
100420 | Department 10 | ESD |  |  | CHUESMA;JFITTZ;KSTARBA | CHUESMA;JFITTZ;KSTARBA |  | 100420 | Department 10 | ESD |  |  | CHUESMA;JFITTZ;KSTARBA | CHUESMA;JFITTZ;KSTARBA
100425 | Department 11 | EB_IM |  |  | CHUESMA;KWIENER;KSTARBA;JFITTZ | CHUESMA;KWIENER;KSTARBA;JFITTZ |  | 100425 | Department 11 | EB_IM |  |  | CHUESMA;KSTARBA;JFITTZ | CHUESMA;KSTARBA;JFITTZ
100500 | Department 12 | DA_COE |  |  | RELOMAA;FMEMMO | RELOMAA;FMEMMO |  | 100500 | Department 12 | DA_COE |  |  | RELOMAA | RELOMAA
Changes
COSTCENTER ID | READ | WRITE
100100 | CHUESMA | ADD |  |  |  |  |  | COSTCENTER ID | COSTCENTER DESCRIPTION | PARENT NODE | Column1 | Column2 | Read | Write
100425 | KWIENER | REMOVE |  |  |  |  |  | 100100 | Department 1 | ACCTG |  |  | ACTJB14;CHUESMA | ACTJB14;CHUESMA
100500 | FMEMMO | REMOVE |  |  |  |  |  | 100105 | Department 2 | ACCTG |  |  | [NAME] | [NAME]
 |  |  |  |  |  |  |  | 100200 | Department 3 | ACTUARY |  |  | [NAME] | [NAME]
 |  |  |  |  |  |  |  | 100210 | Department 4 | ACTUARY |  |  | [NAME] | [NAME]
 |  |  |  |  |  |  |  | 100270 | Department 5 | MEDICAL |  |  | RKNEE;ATRXF21 | RKNEE;ATRXF21
 |  |  |  |  |  |  |  | 100300 | Department 6 | IT_OTH |  |  | CHUESMA;JFITTZ;KSTARBA | CHUESMA;JFITTZ;KSTARBA
 |  |  |  |  |  |  |  | 100345 | Department 7 | EIS |  |  | CHUESMA;JFITTZ;KSTARBA | CHUESMA;JFITTZ;KSTARBA
Based on the action in column C, add or remove the string from the "After" table |  |  |  |  |  |  |  | 100350 | Department 8 | DIG_TRANSF |  |  | RTULENF | RTULENF
 |  |  |  |  |  |  |  | 100410 | Department 9 | ESD |  |  | CHUESMA;JFITTZ;KSTARBA | CHUESMA;JFITTZ;KSTARBA
 |  |  |  |  |  |  |  | 100420 | Department 10 | ESD |  |  | CHUESMA;JFITTZ;KSTARBA | CHUESMA;JFITTZ;KSTARBA
 |  |  |  |  |  |  |  | 100425 | Department 11 | EB_IM |  |  | CHUESMA;KSTARBA;JFITTZ | CHUESMA;KSTARBA;JFITTZ
 |  |  |  |  |  |  |  | 100500 | Department 12 | DA_COE |  |  | RELOMAA | RELOMAA