You need a Hex editor to edit the LR profiles. I used Hex Fiend. You can import those after either in CC/Mobile or Classic. I had the same problem with after getting the xpro3 and x100v.
All it took was finding the xpro1 and x100t profiles and doing a search and replace on camera names.
Dm if you have questions.
If it is a binary file, and you want to inspect the contents, you'll need a hex editor. Looks like you're on a Mac? I hear good things about https://hexfiend.com/
But bear in mind, that if you don't know the format of the file, then being able to see it might not help you much.
Are you sure the blank space is a recognized space character? There are in fact different kinds of space characters, and some which appear as a space to a human are not considered as a space to a machine. Excel struggles with this, so I assume SAS could too.
So. Where is your data from? If its a CSV, open it up in a hex editor and see what specific thing is being used as a space, and see if its a regular space. A hex editor is a text editor for programers which lets you see a little further into what characters are specifically used.
​
I use this one on my Mac: https://hexfiend.com
IDK about windows... maybe notepad++ has it as a feature?
I'm not sure the exact steps in anything except Hex Fiend (macOS only) but just like scroll to where the offset (usually numbers on the left side) is 3900 and select everything from there to the start, then delete it.