topic Re: Trim a Field in QlikView

Trim a Field

evansabres — Tue, 18 Nov 2014 19:24:25 GMT

Hello -

I have a field that reads Video 123456: Name of Video

I only want the name of the video. How would I trim the field to only return the video name?

Thank you in advance for your assistance.

shree909 — Tue, 18 Nov 2014 19:29:48 GMT

Hi Use the subfield function

=subfield('Video 123456: Name of Video',':',-1) to get right most part

=subfield('Video 123456: Name of Video',':',1) to get the result as Video 12345 (left most value)

please post a sample file .

Thanks

antoinelaviron — Tue, 18 Nov 2014 19:30:35 GMT

Hi,

Try this in the script:

Trim( SubField(Field,':',2)) as Name

Best regards,

Antoine

MK_QSL — Tue, 18 Nov 2014 20:20:25 GMT

=SubField(YourFieldName,':',2)

=SubField(YourFieldName,':',-1)

=Mid(YourFieldName, Index(YourFieldName,':')+1)

MarcoWedel — Tue, 18 Nov 2014 23:47:24 GMT

Hi,

I guess Manish Kachhia's solution

Mid(YourFieldName, Index(YourFieldName,':')+1)

might work best because it's the only one that doesn't load e.g. "Mission: Impossible" as just "Mission" or "Impossible".

hope this helps

regards

Marco