Skip to main content
Announcements
See why Qlik was named a Leader in the 2024 Gartner® Magic Quadrant™ for Data Integration Tools for the ninth year in a row: Get the report
cancel
Showing results for 
Search instead for 
Did you mean: 
gidon500
Creator II
Creator II

elimenate first character for data

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

1 Solution

Accepted Solutions
Miguel_Angel_Baeyens

Hi Gidon,

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

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

Hope that helps.

Miguel

View solution in original post

5 Replies
Miguel_Angel_Baeyens

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
Master II
Master II

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
Creator II
Creator II
Author

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

magavi_framsteg
Partner - Creator III
Partner - Creator III

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