Since Dynatrace regex doesn’t seem to follow most of the solutions we can Google, does anyone know the answer to show only numbers when there’s a period in the data pulled?

for example we need to turn values like this:

2.14567890E8 into 214567890

Getting the value before E is no problem, but no combination of regex solutions found on the internet could remove the period without cutting off the first number or the last 8 numbers.  Even our Dynatrace tech rep and his group gave it a try and suggested posting here since their team couldn’t figure out a way to do this either.

Anyone have a solution?

Since Dynatrace regex doesn’t seem to follow most of the solutions we can Google, does anyone know the answer to show only numbers when there’s a period in the data pulled?

for example we need to turn values like this:

2.14567890E8 into 214567890

Getting the value before E is no problem, but no combination of regex solutions found on the internet could remove the period without cutting off the first number or the last 8 numbers.  Even our Dynatrace tech rep and his group gave it a try and suggested posting here since their team couldn’t figure out a way to do this either.

Anyone have a solution?