Remove extra spaces from Arabic field

Question

How do I remove trailing, leading and multiple spaces between the Arabic words. The spaces in Arabic fields are not like the space which we have in English language. In Arabic spaces will be some elongated characters different from the blank space characters that we use in English. Please suggest me a way to validate the Arabic fields and remove extra spaces form the fields in Informatica Developer perspective.

Thanks Shaikh

if one of the answers below are sufficient in solving your problem please accept it — CyberStems, Nov 22 '19 at 17:52

score 0 · Answer 1 · answered Nov 22 '19 at 15:08

Use a java transformation and split your string containing the arabic spacing on said arabic spaces:

String[] myArray = myString.split(" ");//in between quotes replace the space with Arabic space

Then iterate over the array concatenating all of the strings in the array

String cleanString = new String;
cleanString = ""; //create an empty string
for(String str : myArray){
    if(str.equals(" ")) //again replace the space with whatever 
        continue; //skip it if it's a space

    cleanString += str;//concatonate any string that isnt a space
}

score 0 · Answer 2 · answered Nov 26 '19 at 14:02

0

Check the character code and use REPLACECHR with a CHR function, like

REPLACECHR(0, input_Port_Name, CHR(<the_space_character_code>), '')

answered Nov 26 '19 at 14:02

Maciejg

3,088
1
17
30

Remove extra spaces from Arabic field

2 Answers2