Rpalos
(Rainiel Anne Palos)
September 20, 2024, 5:21am
1
Hi Experts,
I am trying to use the decomposeDiacriticalMarks tranform to convert frstname with special character like “ñ” to n. However it is not working.
I created tranform referencing in this link
{attributes=com.sailpoint.seaspray.transform.ConcatTransform@1e55313f}
That is my output when I try to use the in built transform: See below.
Any idea why this is going wrong? I’ve tried wrapping the concat in a static field but no change
"name": "TEST",
"type": "decomposeDiacriticalMarks",
"attributes": {
"input": {
"attributes": {
"type": "concat",
"attributes": {
"values": [
{
…
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
Rpalos
(Rainiel Anne Palos)
September 20, 2024, 8:03am
4
Hi @vijayasaikoppineni
This transform works with you? may I know what value of your firstname?
I Use this transform but still it’s returning
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!
Rpalos
(Rainiel Anne Palos)
September 20, 2024, 8:16am
6
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
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
sup3rmark
(Mark Corsillo)
September 20, 2024, 1:22pm
8
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