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

RE: Find 0x1F char in string

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

RE: Find 0x1F char in string

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