23
Views
11
Comments
Giving a gibberish text like PK *** while using BinaryData to text conversion
Question

Hi,

I am converting BinaryData to text in then It is giving me gibbersish text like PK***  

2021-01-04 08-13-48
Toto
 
MVP

Hi Vivek,

That should be normal, depending what binary data that you convert to text.

UserImage.jpg
Vivek Pandurang Pandile

I just converted some column to binary text.

2021-01-04 08-13-48
Toto
 
MVP

Can you elaborate for "column" ?

Do you mean column data value, converted to binary ? if so, I think it is list converted to binary.

UserImage.jpg
Vivek Pandurang Pandile

Yes It is column data value and after converting from Binary data to text then It is showing PK*** and coming more text 

2021-01-04 08-13-48
Toto
 
MVP

Yes that is expected. Because it is from List -> Binary -> Text
if you want it to show Text, then convert List to Text (maybe using JSON serialize) then convert to Binary, then Text, this should return Text that you can read without gibberish text

UserImage.jpg
Vivek Pandurang Pandile

When I upload excel then it is in binary data but then need to convert text so please tell me how I can convert to JSON and henceforth

2021-01-04 08-13-48
Toto
 
MVP

Wait, better you inform us what is your requirement for this ?

UserImage.jpg
Vivek Pandurang Pandile

I have one excel where I have two column where added some data in those column. When I upload this excel then need to take those values from that excel and need to update those records in database, hope so you are getting my issue.

2021-01-04 08-13-48
Toto
 
MVP

I see, then you doing it wrong.

After you upload your excel, you can use ExcelToRecordList widget for convert excel to List, then you can insert the list into Entity (Database)


The example above, I user "User" entity

UserImage.jpg
Vivek Pandurang Pandile

When we used Upload widget to upload excel then we have to pass two parameter one is Filecontent and Filename so Filecontent is binary data so How we can use excelto recordlist?

2021-01-04 08-13-48
Toto
 
MVP

Yes, put the filecontent in exceltorecordlist file content parameter


Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.