Prevent alphanumeric strings containing an 'E' from being treated as numbers

debugcn Published at Dev

Teleporting Goat

I work with CSV files that have around 3000 lines, and one column uses the format 0dddddddHH, d being a decimal and H an hexadecimal.

That means most of the data looks like 0128522FB but some of them look like 01283227E2. That's very problematic because it's automatically parsed as scientific notation, it gets displayed as 1.28E+08. The worst thing is that I can't even change the format back to text, because the original string has already been changed to 128322700.

Is there a way to disable this behaviour so that I don't completely break files and lose information?

According to this page, it can be disabled for dates but with numbers with E, I have to add a '. That's not doable in my case, and especially not doable in Excel because the information has already been modified.

(I'm using the 2013 business suite)

user308986

Importing Giffyguy's input on the button on the ribbon, you can click From Text on the Data tab of the ribbon (https://i.stack.imgur.com/dGrd9.png) to open the CSV file as a text file, then explictly specify text data type for the column containing hexadecimal data in the Text Import Wizard.

Double-clicking the file in Explorer will not work because this will skip the Text Import Wizard.

Collected from the Internet

Please contact [email protected] to delete if infringement.

edited at2021-07-20

Comments

0 comments

From Dev

Related Related

Article

Prevent alphanumeric strings containing an 'E' from being treated as numbers

Prevent alphanumeric strings containing an 'E' from being treated as numbers

Prevent line numbers from being copied to clipboard

Prevent strings from being interpreted as a file handle

Awk script: How to prevent ARGV from being treated as an input file name

Awk script: How to prevent ARGV from being treated as an input file name

JQuery Variables for Arithmetic being treated as strings

How to prevent short strings from being added to a set

How to prevent my empty strings from being part of the length

Prevent the letter 'e' and dots from being typed in an input number

Design to prevent magic numbers and strings

Sort Only numbers from alphanumeric string in MYSQL

r - extract alphanumeric strings from text

grep whole non-alphanumeric strings and non-numbers

Remove the numeric portion of alphanumeric strings but keep the pure numbers

How can I prevent 16 digit numbers from being logged by nlog?

How do I prevent two of the same random numbers being generated from two different variables in Python?

rails string limit does not prevent too long strings from being inserted in db

how do I prevent my list items from being broken up into individual strings when writing to CSV?

position() being treated as a function

Label being treated as a div

Prevent cell from being calculated

Prevent a Class from being instantiated

Prevent function from being called

can javascript sort strings containing numbers?

Sorting an array of filenames containing strings with numbers

Spring MVC: how to prevent Spring from adding commas in numbers for generated strings

Spring MVC: how to prevent Spring from adding commas in numbers for generated strings

Are strings in AWK treated as arrays?

How to prevent Laravel Routes from being accessed directly (i.e. non-ajax requests)

Prevent attachment from being deleted from Medialibrary