elimenate first character for data

[gidon500]

Hi I have a filed which includes serial no of computers in order to make my reprot i need to get the serial number without the first charater for exp.  SENNO.  SCHC900  should be CHC900   or SZ100 should be Z100

thanks for your help

gidon

[Miguel_Angel_Baeyens · Accepted solution]

Hi Gidon,

Use Left() and Len() functions to get it:

Right([Serial Number], Len([Serial Number]) -1) AS SerialWithoutFirstChar

Hope that helps.

Miguel

[m_woolf]

If you want to change the serialNo in script:

mid(SerialNo,2,len(SerialNo)-1) as SerialNo

In a chart expression:

mid(SerialNo,2,len(SerialNo)-1)

[gidon500]

Hi miguel thaks for your fast response  it works great thanks gidon

[magavi_framsteg]

Hi Gidon.

It would be sufficient to use the mid function with two parameters, like below:

mid([Serial Number], 2) as [Serial Number]

Kind regards

Magnus Åvitsland

BI Consultant

Framsteg Business Intelligence Corp.

[Miguel_Angel_Baeyens]

Magnus,

I agree: easier, cleaner and simpler.

Miguel