Hi, Sure I'm missing something obvious, but:
Raw data has field "SourceName" which is looks like this: api.internal.local/XXXXXXXXX
where XXXXXXX is an API's name
I'm using:
eval API=ltrim(SourceName, "api.internal.local/")
and am getting odd results
some SourceName are behaving as I expect e.g. "api.internal.local/ServerStat" gives me "ServerStat"
but "api.internal.local/inform" gives me "nform"
The only thing I've spotted is the correctly returning values start with an upper-case "S" all others are lowercase
If I miss the slash of the end of the ltrim then all fields are evaluated to "/XXXXXXXX" as you might expect
Any suggestions as to cause, and advise on grabbing what I want would be very gratefully received?
... View more