How to normalize Cyrillic look alike characters in file name and XML content

More
6 months 3 weeks ago - 6 months 3 weeks ago #26011 by admin
It should be a single line for both of them.
They should have the same length
It does replace characters not phrases

Search for: 

Abcdef

Replace with:

123456

Starting from the first

A character is replaced with 1
b character is replaced with 2
c character is replaced with 3
d character is replaced with 4
e character is replaced with 5
f character is replaced with 6

I hope it is clear now

Mike
ETL Architect
Last edit: 6 months 3 weeks ago by admin.

Please Log in or Create an account to join the conversation.

More
6 months 3 weeks ago #26012 by downing
Wouldn’t Replace be the better choice in this case?

Please Log in or Create an account to join the conversation.

More
6 months 3 weeks ago - 6 months 3 weeks ago #26013 by admin
Last edit: 6 months 3 weeks ago by admin.

Please Log in or Create an account to join the conversation.

More
6 months 3 weeks ago #26014 by admin
Here it is
Search for: are Cyrillic Characters
Replace With: are Latin Characters (English)



Starting from the first character:

Within the string Search for В Cyrillic Character if found replace it with B Latin Character (English)
Within the string Search for Т Cyrillic Character if found replace it with T Latin Character (English)
Within the string Search for О Cyrillic Character if found replace it with O Latin Character (English)
Within the string Search for в Cyrillic Character if found replace it with b Latin Character (English)
Within the string Search for т Cyrillic Character if found replace it with t Latin Character (English)
Within the string Search for о Cyrillic Character if found replace it with o Latin Character (English)

Mike
ETL Architect

Please Log in or Create an account to join the conversation.

More
6 months 3 weeks ago #26015 by downing
It works with the filename but doesnt work in the xml

 
   


sent you the files via a different channel

 
The following user(s) said Thank You: admin

Please Log in or Create an account to join the conversation.

More
6 months 3 weeks ago #26016 by admin
Most likely it has something to do with encoding. 
File reader loads entire file into memory in raw format if your file in UTF-8 some characters can be more than 2 bytes.

Anyway there are multiple ways of doing it we will have a look and get back to to you

Mike
ETL Architect

Please Log in or Create an account to join the conversation.

Cookies user preferences
We use cookies to ensure you to get the best experience on our website. If you decline the use of cookies, this website may not function as expected.
Accept all
Decline all
Read more
Marketing
Set of techniques which have for object the commercial strategy and in particular the market study.
Google
Accept
Decline
Analytics
Tools used to analyze the data to measure the effectiveness of a website and to understand how it works.
Google Analytics
Accept
Decline
Google Analytics
Accept
Decline
Functional
Tools used to give you more features when navigating on the website, this can include social sharing.
Advertisement
If you accept, the ads on the page will be adapted to your preferences.
Google Ad
Accept
Decline
Save