Remove unnecessary characters from record

[kushalb]

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,

[binuacs · Accepted solution]

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

[Sebastiaandb]

Hi @kushalb ,

Try this one :-) 

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

Greetings,

Sebastiaan!

[bkurt]

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