Keep First 5 Characters

[morenasm]

Hi All

I am Rather new to Qlik,

I need help to remove unnecessary characters from some data,

This it what it looks like

Account Number

 H0020-01

B0017Teamc

Z1128Sample

B0017dbr

All i need is the First 5 Characters

It Must Looklike this

Account Number

 H0020

B0017

Z1128

B0017

Please can anybody Help

Apreciated

[Stoyan_Terziev · Accepted solution]

Hey,

Here you go:

YourTable:
LOAD
[Account Number],
Left([Account Number], 5) as ID
From YourSource.qvd (qvd);

[morenasm]

Awesome

Thanks this worked 100%

Appreciate the Help