Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
gino2780
Not applicable

keepchar and left load

Hello,

for my data load i need script commands that loads a field in a certain format.

E.g.: Field A has strings in the format shown below (A). I'd like to get rid of the strings like "-" & "/" and cut the data on 9 numeric digits (New A).

A

00-000-0000/1

11-111-1111/2

22-222-2222/3

New A

000000000

111111111

222222222

Thanks in advance.

Tags (2)
1 Solution

Accepted Solutions
sunny_talwar
Not applicable

Re: keepchar and left load

May be Like this:

LOAD A,

          Left(KeepChar(A, '0123456789'), 9) as [New A]

2 Replies
sunny_talwar
Not applicable

Re: keepchar and left load

May be Like this:

LOAD A,

          Left(KeepChar(A, '0123456789'), 9) as [New A]

gino2780
Not applicable

Re: keepchar and left load

That's it. Thanks again!