Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Remove characters before a special character

Hi,

So I have a field which has a '-' at different places within the field. In all cases I want to only show the characters that appear after the -.

For example:-

stu-art   should be    art

s-tuart   should be    tuart

What type of expression can I use to get around this?

Thanks

Stuart

1 Solution

Accepted Solutions
MK_QSL
MVP
MVP

Subfield(YourFieldName,'-',2) as YourFieldName

or

Subfield(YourFieldName,'-',-1) as YourFieldName

View solution in original post

5 Replies
MK_QSL
MVP
MVP

Subfield(YourFieldName,'-',2) as YourFieldName

or

Subfield(YourFieldName,'-',-1) as YourFieldName

ashfaq_haseeb
Champion III
Champion III

Hi

try below

subfiled(field,'-',2)


Regards

ASHFAQ

Not applicable
Author

Hi,

Sorry i should have said that the field could be any lenght.

For example we could have

ffffffffffffffffffffffffff-f

or

ggggggggggggggggggggggggggggggggggggggggg-aa

ashfaq_haseeb
Champion III
Champion III

That should work.

Regards

ASHFAQ

ecolomer
Master II
Master II

Use SubField:

Subfield(FieldName,'-',2) as NewFieldName