Find 0x1F char in string

(0) Share

Report

Posted on by Community Member

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 ?

*This post is locked for comments

I have the same question (0)

All responses (2)

Answers (1)

Crispin John Augustine 37,081 on at

Like (0)

Report

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. )

Was this reply helpful? Yes No
Verified answer

Community Member on at

Like (1)

Report

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) + '%')

Was this reply helpful? Yes No