cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Regex help - show only numbers when there's a period in the data pulled

RobK
Participant

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?

1 REPLY 1

ChadTurner
DynaMight Legend
DynaMight Legend

Great question, I've given it a shot and I cant get it to formulate the way you have requested 😞 

-Chad

Featured Posts