ISD/Add Ins uploads and removing special characters - is there a specific tool Infor or the Communit

lisaklena

ISD/Add Ins uploads and removing special characters - is there a specific tool Infor or the Community recommends to clean the data of special characters before an upload? Is Albeits a tool anyone is using?

unknown

Hi Lisa K,

I use VBA code to make it easier to find and remove characters.  I can send you a copy of the spreadsheet with the vba code in it?  I've pasted it below but it might just be easier for me to e-mail you the spreadsheet.  

It basically creates a formula you can use called RemoveSpecial and you just drag the formula down your spreadsheet and then upload your ISD/Add Ins after you're done.

Below is the vba code you can insert into excel if you know where to do that in the Developer tab.  It also only looks for these special characters "#$%()^*&" but you can always add whatever special characters you want.  Just make sure they're entered between the " ".

Function RemoveSpecial(Str As String) As String
'updatebyExtendoffice 20160303
Dim xChars As String
Dim I As Long
xChars = "#$%()^*&"
For I = 1 To Len(xChars)
Str = Replace$(Str, Mid$(xChars, I, 1), "")
Next
RemoveSpecial = Str
End Function

Thanks,

Michelle 

Michelle.Hager@clearskyerp.com