Solved: Mid statement based on character - Qlik Community

Anonymous · ‎2016-02-26

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

tresesco · ‎2016-02-26

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

View solution in original post

tresesco · ‎2016-02-26

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

PrashantSangle · ‎2016-02-26

Hi,

use subfield()

try like

subfield(fieldName,'#',2)

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

maxgro · ‎2016-02-26

maybe subfield

load

field,

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

Inline [

field

123;#Peter Jones

56789;# John Smith

];

Anonymous · ‎2016-02-26

Got it.

Thanks guys

Phil