trimming data

[#1]

Hi everyone,

I have some data which I would like to 'trim' where anything after the 'full stop' is removed so bbc.co.uk would simple be bbc

I treid using the code below but that didn't seem to work.

left

(HostName, index(HostName, '.') -1) as HostNameShort

Any suggestions?

Thanks

[#2]

try this:

left(HostName,index(HostName,'.')-1) as HostNameShort

[#3]

Is that not the same as I wrote? I think you may have missed the 'left' at the top of my code 🙂

[#4]

you're right, I didn't see that left at the top o_O

then try with trim, I'm guessing you may have some spaces around the ends.

left(trim(HostName),index(trim(HostName),'.')-1) as HostNameShort