SBX - Search With Button

SBX - Forum Post Title

Find 0x1F char in string

Microsoft Dynamics AX Forum

Jacek Sydor asked a question on 15 Jun 2018 12:48 AM
My Badges

Question Status

Verified

hi,

  I have problem with export data to excel. After clicked ctrl + T I got error "0x1F is not correct sign". The Problem concerns the name of released products. How can I find bad record or remove sign ?

Reply
Crispin John Augustine responded on 15 Jun 2018 2:52 AM
My Badges

Are you getting this error message in AX infolog or in Excel? (I think, Excel should just treat it as a string, and populate in a cell. )

Reply
Jacek Sydor responded on 15 Jun 2018 6:58 AM
My Badges
Verified Answer

Thanks for reply. Error was in dialog not in info log. I found char via SQL

select Name

 from ECORESPRODUCTTRANSLATION

 where Name like('%' +  char(31) + '%')

Reply
Jacek Sydor responded on 15 Jun 2018 6:58 AM
My Badges
Verified Answer

Thanks for reply. Error was in dialog not in info log. I found char via SQL

select Name

 from ECORESPRODUCTTRANSLATION

 where Name like('%' +  char(31) + '%')

Reply

SBX - Two Col Forum

SBX - Migrated JS