transforming data

[#1]

Hello,

I am importing data from different sources and in one of my file i am getting "chinese" character for the country like this : Italy - 意大利

This is my script, how can i "insert" the search and replace fonction in my Scripting.

LOAD Nom,
Prénom,
[Adresse e-mail],
Status,
Langue,
[Champ libre 1],
[Champ libre 2],
Country,
Date(Floor([Date de création])) as Date,
year([Date de création]) as year,
month([Date de création]) as month,
day([Date de création]) as day,
hour([Date de création]) as hour,
Time(Frac([Date de création])) as Time

[Kushal_Chawda]

what are these lists? what challenges you have in ZH?

[Colin-Albert]

keepchar(Country,'abcdefghijklmnopqrstuvwxyz') as CorrectedCountry

This expression will remove all uppercase characters from the Country field!

[Kushal_Chawda]

then probably this

keepchar(lower(Country),'abcdefghijklmnopqrstuvwxyz') as CorrectedCountry

[avinashelite]

Hi Jean,

Do you want to remove the chines character or do you need to replace it with any other character set ??

[Anonymous]

PUGRE CHAR OR KEEP CHAR IS USEFUL TO YOU

[tamilarasu]

If you have a list of countries to replace, you can use apply map method as mentioned by Avinash.

[engishfaque]

Dear Jean,

Kindly find attached app. I hope this is the simplest one solution.

Kind regards,

Ishfaque Ahmed

[#9]

THanks for the question, i need to replace Germany - 德国  with Germany

But i need to do this for 10 different countries

[PrashantSangle]

Hi,

If pattern of your country name is always like

countryName - 德国

then you can use subfield() also

try like subfield(CountryName,'-')

For details always search in help menu. You will get better idea.

Kind Regards

[#11]

sub works perfectly ....i did think about it thanks