IF left or right function

[#1]

Hi.

What is the best way in the script to do some string functions like this,

if some places are with North or north (like london north or Dublin south) I would like to have the result "N" or "S".

Thanks in advance!

[whiteline]

Hi.

I think it's not hard to adopt the solution provided above by jerem1234.

Replace function can help you to omit the direction word in the station name and then you can add it as a symbol.

[jerem1234 · Accepted solution]

You could try a mapping like:

map1:

Mapping load * Inline [

x, y

Norra, N

Södra, S

norra, N

södra, S

];

Then for your field do:

MapSubString('map1', Station) as Station

Hope this helps!