Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
what are these lists? what challenges you have in ZH?
keepchar(Country,'abcdefghijklmnopqrstuvwxyz') as CorrectedCountry
This expression will remove all uppercase characters from the Country field!
then probably this
keepchar(lower(Country),'abcdefghijklmnopqrstuvwxyz') as CorrectedCountry
Hi Jean,
Do you want to remove the chines character or do you need to replace it with any other character set ??
PUGRE CHAR OR KEEP CHAR IS USEFUL TO YOU
If you have a list of countries to replace, you can use apply map method as mentioned by Avinash.
Dear Jean,
Kindly find attached app. I hope this is the simplest one solution.
Kind regards,
Ishfaque Ahmed
THanks for the question, i need to replace Germany - 德国 with Germany
But i need to do this for 10 different countries
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
sub works perfectly ....i did think about it thanks