Can Transform convert special character (UTF8) to normal character

Hi Experts,

I am trying to use the decomposeDiacriticalMarks tranform to convert frstname with special character like “ñ” to n. However it is not working.
image

I created tranform referencing in this link

and here is my transform.

{
    "name": "Decompose Diacritical Marks Transform",
    "type": "decomposeDiacriticalMarks",
    "attributes": {
        "input": {
            "attributes": {
                "name": "firstname"
            },
            "type": "identityAttribute"
        }
    },
    "internal": false
}

Has anyone successfully used this transform?

Thanks a lot in advance.

Hi @Rpalos ,
Greetings of the Day!

please use ReplaceAll Transform please check the below screenshot hope it is helpful for you.

Thank You

Hello @Rpalos

Good day!

Please check below transform, it is worked for me, can you try once.

{
    "attributes": {
        "input": {
            "attributes": {
                "name": "firstname"
            },
            "type": "identityAttribute"
        }
    },
    "type": "decomposeDiacriticalMarks",
    "name": "Decompose Diacritical Marks Transform1"
}

Thank you

1 Like

Hi @vijayasaikoppineni

This transform works with you? may I know what value of your firstname?

I Use this transform but still it’s returning
image
image

This is what I set in the csv for the firstname: Test642Lñ

And I find it weird, why the replace and decomposeDiacriticalMarks not working on my end

Hi @Rpalos,
Good Day!
Can you use the ReplaceAll transform and let us know the output. As suggested by the @Mahesh_Mukku.

Thank you!

Hi @Mahesh_Mukku

I also tried this one, if normal character “Abc”, this transform works. but If I tried using it with ñ it’s returning
image

Transform:

{
        "name": "Replace All Special Character Transform",
        "type": "replaceAll",
        "attributes": {
            "input": {
                "attributes": {
                    "sourceName": "TEST_SAP HCM",
                    "attributeName": "familyName"
                },
                "type": "accountAttribute"
            },
            "table": {
                "ñ": "n",
                "Ñ": "N",
                "e": "a"
            }
        },
        "internal": false
    }

Hi @Rpalos ,
Good Day!

I have tired Replace All Transform and decomposeDiacriticalMarks its an intermediate issue , please raise this to SailPoint team .

Thank You

1 Like

I don’t think the transforms are the problem here.

Can you make an API call to SailPoint to see what it returns as the value for that account’s firstname attribute? I think you’ll find that the stored value doesn’t actually contain the ñ you’re expecting, likely because of an encoding issue.

1 Like

Hi @Rpalos,

Try below transform, it should work for you:

{
    "name": "TRN FirstName",
    "type": "replace",
    "attributes": {
        "input": {
            "attributes": {
                "input": {
                    "attributes": {
                        "input": {
                            "attributes": {
                                "name": "firstname"
                            },
                            "type": "identityAttribute"
                        },
                        "regex": "[´]",
                        "replacement": "'"
                    },
                    "type": "replace"
                }
            },
            "type": "decomposeDiacriticalMarks"
        },
        "regex": "[^a-zA-Z0-9-'´`’‘ ]",
        "replacement": ""
    },
    "internal": false
}
1 Like