Splitting a field

[#1]

Hi Experts,

I have a dimension field which has Alphanumeric data

like 79342-John Albert (i have a hyphen in between)

i need to separate into two. one with numeric data and other with the Alphabets

like Field1 - 79342

      Field2 - John Albert

Is it possible to split?

How can i do this. pls help

[arulsettu]

try like this

SubField('79342-John Albert',2) as numericfield,

SubField('79342-John Albert','-',2) as textfield

[#3]

i need to do this on pivot table and not on script.

pls help

[tresB · Accepted solution]

SubField('79342-John Albert','-',1)

SubField('79342-John Albert','-',2)

And this can be used in pivot table(or anywhere at the front-end)

You can use field name instead of the string.

[#5]

Hi,

thanks for the response

the example is the field value not the field name

[kaushiknsolanki]

Hi,

Yes its possible.

You can use the subfield function to get the separate fields.

Load Old_Field_Name,

SubField(Old Field Name,'-',1)  as Field1,

SubField(Old Field Name,'-',1)  as Field2

From XYZ;

Regards,

Kaushik Solanki

[alex_millan]

Hi,

create two calculated dimensions on your pivot table:

SubField('79342-John Albert','-',1)

SubField('79342-John Albert','-',2)

HTH

Regards