Data Spillovers

[Anonymous]

Hi,

I am importing a large dataset that has spillover issues, e.g. the field CITY has some numerical values, garbage values etc. Now is there way I can keep these CITY values as blanks? I don't want to skip all the fields, just to make the CITY as blanks where it finds numbers or special characters like #, &*

Thanks

[sujeetsingh]

Wildmatch can help you.

[sunilkumarqv]

try like this

Data:

LOAD PurgeChar(City,'@*#') as City;

LOAD * Inline

[

City

Chennai

Chennai#

Hyd@

Bangalore*

];

[Ralf-Narfeldt · Accepted solution]

This will replace bad values in CITY, the ones containing a character listed in the FindOneOf second argument, with an empty string to a field called CleanCity.

LOAD If(FindOneOf(City,'0123456789*!"#¤%&/'),City, '') As CleanCity;

You can of course add more characters to screen for.

[Anonymous]

Thanks guys, appreciate the help

[Ralf-Narfeldt]

Great! Please mark answers as Helpful or Answered!