Loading Text/Data without specific characters

[#1]

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 · Accepted solution]

Hi,

Try this

[Data]:

LOAD

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

...

Regards,

Sokkorn Cheav

[#3]

Hi,

Thanks!

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

[Sokkorn]

Hi,

Let look around this data

ID	System
1	Name1 - System1
2	Name2 - System2
3	Name3 - New_System3

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