topic Re: Loading Text/Data without specific characters in QlikView

Loading Text/Data without specific characters

Fri, 13 Jan 2012 10:04:58 GMT

Hi,

I've got a file with systems and their name.

Name System

--------------------------

Name1 - System1

Name2 - System2

Name3 - New_System3

New Systems are labled as New_System e.g. Name3 - New_System3

I want to load the data without the "New_". -> Name - System3

Can anyone help?

Sokkorn — Fri, 13 Jan 2012 10:22:58 GMT

Hi,

Try this

[Data]:

LOAD

REPLACE(System,'New_','') AS System;

...

Regards,

Sokkorn Cheav

Fri, 13 Jan 2012 10:27:38 GMT

Hi,

Thanks!

and what could I do if I just want to load the "old Systems" and no new Systems?

Sokkorn — Fri, 13 Jan 2012 10:34:15 GMT

Hi,

Let look around this data

What you want is load only record that have no New word in field System. Am I right?

If like this, then

[Data]:

LOAD

ID,

System

RESIDENT

WHERE NOT MATCH(System,'*New*');

Regards,

Sokkorn Cheav