Unanswered

hexadecimal value 0x00 is an invalid character

(0) Share

Report

Posted on by Vaishali04

Hi All,

I am trying to load data into dataverse table from a csv but getting error :hexadecimal value 0x00 is an invalid character/ in one of the field for few rows.

Can anyone tell hoe to fix it in dataverse? Do I need to write some formula or need to chnage data type from text?

Please help if aware .

Regards

Vaishali

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (3)

Answers (0)

ChrisPiasecki 6,422 Most Valuable Professional on at

Like (0)

Report

Hi @Vaishali04,

Looks like a hidden null character is in your file. You can open it in Excel and do a search for CHAR(0) and replace it with blank/empty space. Then save it as a CSV again and try reimporting.

---
Please click Accept as Solution if my post answered your question. This will help others find solutions to similar questions. If you like my post and/or find it helpful, please consider giving it a Thumbs Up.

Was this reply helpful? Yes No
Vaishali04 7 on at

Like (0)

Report

Hi @ChrisPiasecki ,

Thanks for your reply.

I don't have access to the csv file . It is in production environmen. I am loading the csv from Azure blob into Dataverse table using adf pipelines. for now I just skipped the records cuaing issue in adf pipeline. But I want to load those records in dataverse table . Is there a way to resolve the issue in dataverse or adf pipeline ?

Regards
Vaishali

Was this reply helpful? Yes No
ChrisPiasecki 6,422 Most Valuable Professional on at

Like (0)

Report
Hi @Vaishali04,

Ok, didn't realize you were using a pipeline to automate it. That opens up more possibilities 🙂. A possible approach would be:

Add a Derived Column transformation after you've read in the CSV data

In the Derived Column, You can use an expression such as regexReplace to replace it with an empty value. Haven't tested, but I imagine something like this (might need to try a few different combinations for the hex value, could be \x0000 or 0x0 without quotes):
regexReplace(<ColumnName>, '\\x00', '')

replace <ColumnName> with the CSV column that contains the null character.

---
Please click Accept as Solution if my post answered your question. This will help others find solutions to similar questions. If you like my post and/or find it helpful, please consider giving it a Thumbs Up.

Was this reply helpful? Yes No