Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
or this
=SubField('d:/accesspoint/billing analysis residential - 132531 _ r_c west columbus.qvw', '/', -1)
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.
or this
=SubField('d:/accesspoint/billing analysis residential - 132531 _ r_c west columbus.qvw', '/', -1)
Thanks Sunny