Text with "D" automatically converts to scientific "E"

[Manojkumar]

Hi Team,

i am trying to pass the following text "15D213" from text input tool to a macro.

But it automaticall converts to 1.5E+ values. i want it to be passed as 15D213 to macro.

Can anyone please help

[T_Willins · Accepted solution]

Hi @Manojkumar,

Since it is coming from a text input, can you add a leading character in the text input, then remove that character with a subsequent formula tool?

[TonyA · Accepted solution]

Hi @Manojkumar ,

You have run into a very weird idiosyncrasy of certain computer languages. In some languages, including C (which a good part of Designer is written in), "D" is used to indicate double precision scientific notation. Alteryx is interpreting numbers according to that rule. This won't be a problem if there are strings somewhere in the column, but if all the values are either numeric or are numbers with a single "D" or "E" then you'll need a workaround like the one suggested by @T_Willins . If you have multiple columns with the same issue, another option would be to add a dummy first row that forces the data type to strings for all the problem columns and then remove it with a sample tool as a first step in the workflow. 

[Manojkumar]

Hi Willins,

Thanks for the solution !!

[Manojkumar]

Hi Tony,

Thanks for clarifying the issue