my requirement is after ifen Symbol in name is there in my Field iwant another field in qlikview

[jonesbrown]

Hi All

I am new to Qlikview 

my requirement is after ifen Symbol in name is there  in my Field iwant another field in   qlikview Application

How i will get

plz help. 

[Vegar · Accepted solution]

Use this

Substring(Field, '-',1) as FieldPart1,

Substring(Field, '-',2) as FieldPart2

[jonesbrown]

Thanks  Vegar.