Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
philmywallet
New Contributor III

Mid statement based on character

Hi

I want to remove some text from the beginning of a field by expression / script.  The seperater is '#', but it is not always at the same mid point of the field.  Could anyone help.  Please see below  ....

123;#Peter Jones

56789;# John Smith

I want to show .....

Peter Jones

John Smith

Any thoughts welcome

Thanks  

Phil

Tags (3)
1 Solution

Accepted Solutions
MVP
MVP

Re: Mid statement based on character

SubField(YourField, '#', 2) as Name

4 Replies
MVP
MVP

Re: Mid statement based on character

SubField(YourField, '#', 2) as Name

Re: Mid statement based on character

Hi,

use subfield()

try like

subfield(fieldName,'#',2)


Regards

Great dreamer's dreams never fulfilled, they are always transcended.
MVP
MVP

Re: Mid statement based on character

maybe subfield


load

  field,

  trim(SubField(field, '#', 2)) as newfield

Inline [

field

123;#Peter Jones

56789;# John Smith

];

philmywallet
New Contributor III

Re: Mid statement based on character

Got it.

Thanks guys

Phil

Community Browser