Formatting location codes for QlikMaps

[lbunnell]

I need to convert some location codes in a load script into a format that QlikMaps is able to render. I have longitude and latitude codes in the following format that does not work in QlikMaps:

Latitude	Longitude
+31198782	-084101689
+28623788	-081127853
+33478138	-082007668

It appears that QlikMaps is looking for these location codes in a format like this:

Latitude	Longitude
31.198782	-08.4101689
28.623788	-08.1127853
33.478138	-08.2007668

Does anyone know a way to convert these codes into a format that QlikMaps can understand?

[rubenmarin · Accepted solution]

Hi Lawrence, you can try with num#() and strings concatenations:

=num#(Left(Longitude,3)&'.'&Mid(Longitude, 4),'#0.0000000', '.', ',')

Or, if all values have the same lenght:

Latitude/1e7 //1e7 = 10000000

[lbunnell]

It appears that Longitude/1e6 works