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: 
tmumaw
Specialist II
Specialist II

Trimming x number of postions

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

 

Labels (1)
1 Solution

Accepted Solutions
sunny_talwar

or this

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

View solution in original post

4 Replies
chrishayes
Contributor III
Contributor III

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

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

or this

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

Thanks Sunny