nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Would anyone know how I can do a Text to Columns split on this data

I'm trying to split this set of data which is held in a single excel cell by the :-

8=FIX.4.435=SA54=175=2026040764=2026040715=JPY53=20700118=426420000111001=XYC LTD111002=923910453=2448=XYZXXX447=D452=13448=K9WDOH4D2PYBSLSOB484447=N452=178=179=49276780=20700467=GRC092436468701154=42642...

I've tried using a Pipe in the delimiter on the test to columns, but it does nothing. Would anyone be able to advise what I need to use?

Accepted answers

@JustinBNY
You can copy and paste that symbol, that would work.
Or you can use a formula tool to replace that symbol with Pipe and then set the Pipe in the text to columns tool.

I've found a way to do this so no longer required. If you're interested I added a formula tool with the following formula Replace([column A], CharFromInt(1), "|"). This changed the SOH character to a pipe and allowed me to do the split.

All comments

Interestingly the character the data is split by has disappeared when I've posted.

It can be seen in the above picture

@JustinBNY
You can copy and paste that symbol, that would work.
Or you can use a formula tool to replace that symbol with Pipe and then set the Pipe in the text to columns tool.

I've found a way to do this so no longer required. If you're interested I added a formula tool with the following formula Replace([column A], CharFromInt(1), "|"). This changed the SOH character to a pipe and allowed me to do the split.

Thank you - as per below this worked!😀

Quick Links

Popular Tags

This months top contributors

atcodedog05 19598

Qiu 15908

MarqueeCrew 13710

apathetichell 13703