Neues Thema starten

Delete special chart

Hello,


I need to delete special caracter from a field. #


Actually:


${manufacturerName!}_${manufacturerSKU!}


Actual Result:


HP_CH561EE#301


Result needed:


HP_CH561EE301


Other exemple:


Actual Result:


Cisco_AIR-CAB005LL-N=


Result needed:



Cisco_AIR-CAB005LL-N

Thank you in advance.
1 Kommentar

Hello,


you could you try this for a single character

 

${manufacturerName!}_${manufacturerSKU?replace("#","")}

 

If you want to remove multiple special characters you will probably have to use regex: 

${manufacturerName!}_${manufacturerSKU?replace("[\\.\\+\\\\#=\\?]","","r")}

This will remove the following characters: =

Sadly I'm not that proficient in regex so I don't know if there is a better way to resolve the issue.


Alternatively you can use the built in Synesty Function to replace each undesired character with nothing:

image



Kind Regards,

Stefan



1 Person gefällt dies
Anmelden um einen Kommentar zu veröffentlichen