Trim error

knozawa

My data was not trimmed appropriately.

Formula: trimleft([JSON_Name],"data.")

Result:

Before Trim	After Trim
data.term	erm
data.thank	hank
data.therapies	herapies
data.work	work
data.world	world
data.women	women

Does anyone know how to fix this?

Thank you,

Kazumi

RodL

Per Help on Functions, TrimLeft will remove any characters specified in "y", from "x".

TRIMLEFT(x, y) Remove character in the string y from the beginning of the string x.

Since "t" is in your "y" set of data, it is trimming the "t" after the period as well.

Based on your small sample set of data, I would suggest

--REPLACING "data." with "" (in other words, replace "data." with an empty value)

--or using RegEx to keep anything after the period

--or a SUBSTRING function that starts at the 6th character

Depending on what your full set of data looks like, one of these should work.