Creating new fields from existing dimesnions

[#1]

Hi All,

I have an excel sheet with values and volumes for export and home. The headers are like this -

[Value - 01'11 Home], [Value - 01'11 Export], [Volume - 01'11 Home], [Volume - 01'11 Home] and so on

I want to create the following new fields in the back end

Value , Volume , Year , Month , Export and Home.

I tried using the left and the right functions but its not working.

I tried the below script

left([Value - * ],5) as [Value USD],

left([Volume - * ],5) as [Volume],

It would be great if somebody could help me out with this.

Thanks

Ani

[ariel_klien]

Hi,

Try TextBetween() function,

BR

Ariel