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_1No_2UIDAbbreviation11334464441009HPUSNL,11334464470405HPCAON,11334464470405HPEUON,11334464470405HPUSON,1180235 HPCAON,121245725752629HPUSCA, ON1239338 HPCACA,1263933 HPCAAB,1354502 HPCACA,BC,ON,QC,

Remove unnecessary characters from record

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?

Workflow

Datasets

Input

@kushalb One way of doing this with the TrimRight() formula

@kushalb One way of doing this with the TrimRight() formula

Try this one :-)

REGEX_Replace([Abbreviation],"(.*)(,$)","$1")

Greetings,

Sebastiaan!

Formula: IF Right([Abbreviation], 1)="," THEN [Abbreviation]-Right([Abbreviation, 1) ELSE [Abbreviation] ENDIF