Creating new fields from existing dimesnions

Mon, 03 Jun 2013 08:40:19 GMT

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

Re: Creating new fields from existing dimesnions

ariel_klien — Mon, 03 Jun 2013 11:41:18 GMT

Hi,

Try TextBetween() function,

Ariel