Extracting parts of field names to create new fields

[#1]

Hi there,

Im looking for a way to extract parts of a field name I have.

In the excel sheet the field name is '2013 Q1 Planning'

So when I pull this into qlick view I get [2013 Q1 Planning]

I would now like to extract the '2013' from this field name and label it Year.

I would also like to extract the 'Q1' and label it Quater.

And then have the corresponding values attached to theses fields.

Please see my examples below.

Table A Is what I have, Table B is what I want.

Table A : What I have:

Table B: What I want:

If anyone knows how to do this or if it can even be done, Id really appriciate the help.

Thanks

[marcus_sommer]

You could solve it with a crosstable - see attachment.

- Marcus