Hi All,
My problem goes like in Abbreviation column there is unnecessary ',' at the end of records
buit we only need ',' in between which is also there so that is not a concern but only at the end it should not be there
so how to remove that from Abbreviation column?
No_1 | No_2 | UID | Abbreviation |
1133446 | 4441009 | HPUS | NL, |
1133446 | 4470405 | HPCA | ON, |
1133446 | 4470405 | HPEU | ON, |
1133446 | 4470405 | HPUS | ON, |
1180235 | HPCA | ON, | |
1212457 | 25752629 | HPUS | CA, ON |
1239338 | HPCA | CA, | |
1263933 | HPCA | AB, | |
1354502 | HPCA | CA,BC,ON,QC, |
Solved! Go to Solution.
Formula: IF Right([Abbreviation], 1)="," THEN [Abbreviation]-Right([Abbreviation, 1) ELSE [Abbreviation] ENDIF