Trimming x number of postions

[tmumaw]

Hi All,

I need to remove some information for the beginning of a string.  Here is an example:

d:/accesspoint/billing analysis residential - 132531 _   r_c west columbus.qvw

I want to remove  d:/accesspoint/ 

thanks

[chrishayes]

If 'd:/accesspoint/' is constant you could use the following:
Mid('d:/accesspoint/billing analysis residential - 132531 _ r_c west columbus.qvw', 16)

[chrishayes]

If its not constant, you could use the following:

Subfield('d:/accesspoint/billing analysis residential - 132531 _   r_c west columbus.qvw', '/', 3)

It's looking for the delimiter '/' then taking the third value.

https://help.qlik.com/en-US/sense/November2018/Subsystems/Hub/Content/Sense_Hub/Scripting/StringFunc...

[sunny_talwar · Accepted solution]

or this

=SubField('d:/accesspoint/billing analysis residential - 132531 _   r_c west columbus.qvw', '/', -1)

[tmumaw]

Thanks Sunny