Remove trailing characters in a String field on table records

[Vivin Viswanath]

Hi folks, 

Looking to remove ".0" off of String fields that have accumulated over the years. 

Here's what I'm trying to execute. Alternatively, I tried using .slice as well. I can't shake the feeling it's something basic and I should probably stop working at 3am. 

var trailingZero = new GlideRecord("task");
trailingZero.addEncodedQuery('fieldLIKE.0');

while(trailingZero.next()) {
	var trailingGone = trailingZero.field.replace(/.0/,'');
	trailingZero.setValue('field,trailingGone);
	trailingZero.update();
}

[Community Alums · Accepted solution]

Hi @Vivin Viswanath ,

I fixed your script in my PDI there are some error in that. Please refer below code 

var trailingZero = new GlideRecord("task");
trailingZero.addEncodedQuery('fieldLIKE.0');
trailingZero.query();
while(trailingZero.next()) {
	var field = trailingZero.getValue("field");
	var trailingGone = field.replace(".0",'');
	trailingZero.setValue('field',trailingGone);
	trailingZero.update();
}

Please mark my answer correct and helpful if this works for you

Thanks and Regards 

Sarthak

[Vivin Viswanath]

Thanks, Vishal! I'll give this a try as well as Sartha's and see what we get. 

[Vivin Viswanath]

Both yours and Sarthak's solutions worked. I marked them both as acceptable.