This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

Not possible, you just need to sanitise your imports on excel etc

<@U29KC9VDF> Can you be more descriptive? Thanks! :slightly_smiling_face:

You'd have to replace the accented characters with their non-accented equivalents prior to import.

You can't block it in NetSuite, so you'd just have to do some kind of find and replace in excel files for foreign characters like *à è etc etc*

Haven't tested it, but doing something like this would help.

<https://howtouseexcel.net/excel-formula-to-change-foreign-accented-characters-to-regular-non-accented-characters>

<@U29KC9VDF> and <@UAPHBR6TS> you all rock! Thanks for the tips. We will try it out and if I have any other questions I will circle back. Thanks guys! :]

```Sub ReplaceAccentedChar()
Const sFm As String = "ŠŽšžŸÀÁÂÃÄÅÇÈÉÊËÌÍÎÏÐÑÒÓÔÕÖÙÚÛÜÝàáâãäåçèéêëìíîïðñòóôõöùúûüýÿ"
Const sTo As String = "SZszYAAAAAACEEEEIIIIDNOOOOOUUUUYaaaaaaceeeeiiiidnooooouuuuyy"
Dim i As Long, ws As Worksheet
For Each ws In ThisWorkbook.Worksheets
    For i = 1 To Len(sFm)
        ws.Cells.Replace Mid(sFm, i, 1), Mid(sTo, i, 1), LookAt:=xlPart, MatchCase:=True
    Next i
Next ws
End Sub```

This is the macro that I use for the same need. Doesn't seem to have the accented S that you mentioned, but you can edit the strings of characters to include additional accented and non-accented equivalent

May be faster than find + replace depending on the size of your data