---
title: "QQ - How do I transform data loaded as string into a double?"
slug: "qq-how-do-i-transform-data-loaded-as-string-into-a-double"
updated: 2022-10-10T08:09:28Z
published: 2022-10-10T08:09:28Z
canonical: "docs.datajet.app/qq-how-do-i-transform-data-loaded-as-string-into-a-double"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://docs.datajet.app/llms.txt
> Use this file to discover all available pages before exploring further.

# QQ - How do I transform data loaded as string into a double?

Lat/long data loaded in format

N 51.987878

E 00.654987

![](https://cdn.document360.io/73b6469b-c1e4-47e9-aa65-986c8ebd17ca/Images/Documentation/image-1664205639526.png)

How do we transform this into usable Numeric fields?

1. Use expression **mid** to trim the data and remove leading letters
2. Use a programmed field to convert the data to a double   **or**
3. Use String | DCAST