Trying to expand binary content

Question

Hi,Is there any other way to expand this content, because if i click on expand icon besides Content, then it is not working&nbsp;

alexisolson · Answer

The code for this step looks like this:
= Table.TransformColumns(#"Filtered Rows", {{"Content", Text.FromBinary}})
You can replace Text.FromBinary with the appropriate function like Excel.Workbook.
= Table.TransformColumns(#"Filtered Rows",{{"Content", Excel.Workbook}})
&nbsp;Then it should return tables instead of garbled text.

kymramosrpo · Answer

Hello! By now I'm assuming you have found a solution to this, but just in case anyone would find this post asking the same or a similar question, here's my suggestion:

1. Keep the 'Content' column with 'Binary' values.

2. Add a custom column and paste, Table.FromList(Lines.FromBinary([Content])).

3. Keep that custom column (i.e., with 'Table' values).

4. Expand that column by clicking on the ↰↱ button in the top right corner of the column.

Result:

---

How about you? What's your suggestion?

serpiva64 · Answer

Hi,
right click on the column
select transform - text

&nbsp;
and it opens
&nbsp;
If this post isuseful to help you to solve your issue consider giving the post a thumbs up and accepting it as a solution !
&nbsp;

fcerullo · Answer

Combining Binary files:I know how to do it by adding a custom column forcsv files =Csv.Document([Content])orExcel files = Excel.Workbook([Content])But, what about .txt files?Is there a command that does the same as above"?my reasoning:I HATE those auto-created transformation files, and I like to keep certain columns to identify dates or original source, which the first to allow me to do, but the Combine button removes.

anonymous · Answer

When i tried above solution then getting below error&nbsp;&nbsp;

Forum Discussion

Trying to expand binary content

10 Replies

Related content

Trying to expand a json array into multiple columns

The content is blocked.

expanded table

web content

Trying to expand a json array into multiple columns