Shorten datavalues

[#1]

Hello.

I have been working on my first Qlikview course since a couple of days.

I've got a database from my lecturer what I need to work on.

This is in short what the table looks like:

Store               Value

Storname1      10

Storename2     32

etc                    etc

What i whant, is that the storenames start from character 14, because the storenames starting all with the same name, followed by the actual name.
Example:

Milkshakebar Amsterdam
Milkshakebar Rotterdam

I dont want the term Milkshakebar in my table.
I heard that ri can use the function mid

The tablename in the databse is Vestigingnaam.

I hope you guys can help me out, i am new to Qlikview.

Best regard

Joerie

[Gysbert_Wassenaar]

Try: 

MyData:

Load

     FieldA,

     FieldB,

     mid(Store,14) as Store,

     FieldX;

Select FieldA, FieldB, Store, FieldX

From Vestigingnaam;