Spreadsheet: 877850d1724795527-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 |  |  | CHUESMA;TEST | CHUESMA;TEST
100500 | FMEMMO | REMOVE |  |  |  |  |  | 100105 | Department 2 | ACCTG |  |  | [NAME] | [NAME]
100100 | TEST | ADD |  |  |  |  |  | 100200 | Department 3 | ACTUARY |  |  | [NAME] | [NAME]
100100 | ACTJB14 | REMOVE |  |  |  |  |  | 100210 | Department 4 | ACTUARY |  |  | [NAME] | [NAME]
100500 | RELOMAA | REMOVE |  |  |  |  |  | 100270 | Department 5 | MEDICAL |  |  | RKNEE;ATRXF21 | RKNEE;ATRXF21
100500 | TESTTT | ADD |  |  |  |  |  | 100300 | Department 6 | IT_OTH |  |  | CHUESMA;JFITTZ;KSTARBA | CHUESMA;JFITTZ;KSTARBA
100500 | TESTTT2 | ADD |  |  |  |  |  | 100345 | Department 7 | EIS |  |  | CHUESMA;JFITTZ;KSTARBA | CHUESMA;JFITTZ;KSTARBA
 |  |  |  |  |  |  |  | 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 |  |  | TESTTT;TESTTT2 | TESTTT;TESTTT2
Based on the action in column C, add or remove the string from the "After" table