topic Re: using rtrim to isolate server name in QlikView

using rtrim to isolate server name

ngosz4074 — Mon, 17 Aug 2015 17:53:56 GMT

I have a server path (or paths) that we want to do selections on the server name only.

Example: \\server1\Folder Path

var1 - mid(Path, index(Path,'\\', 1) + 2) to remove the first two slashes

var2 - RTrim(Path) - ??

What's the best way to accomplish removing everything after the slash after server1 and be flexible to handle different string lengths?

Thanks in advance

Re: using rtrim to isolate server name

ramoncova06 — Mon, 17 Aug 2015 18:00:28 GMT

you can use subfield

subfield(mid(Path, index(Path,'\\', 1) + 2) ,'\',1)

you can use subfield for the whole thing subfield(Path,'\',3) if you do not want to use the mid function

Re: using rtrim to isolate server name

petter — Mon, 17 Aug 2015 18:04:55 GMT

You can pick out the part of the path you want by using SubField()-function. This can be used both in a load script but also in the running application in the UI.

SubField( Path , '\' , 3 ) will pick out the server1

Since the first element is empty... the string starts with a backslash. The second part is empty - since there is nothing between the two first backslashes.

You can also index backwards by using a negative index. So SubField( Path , '\' , -1 ) will give you the text after the last backslash.

Re: using rtrim to isolate server name

maxgro — Mon, 17 Aug 2015 18:07:48 GMT

for server1

= subfield(replace('\\server1\Folder Path', '\\', ''), '\', 1)

Re: using rtrim to isolate server name

sasiparupudi1 — Mon, 17 Aug 2015 19:29:09 GMT

folder path

trim(subfield(Replace( '\\server1\Folder Path','\\',''),'\',2))

server name

subfield(Replace( '\\server1\Folder Path','\\',''),'\',1)

hth

Sasi

Re: using rtrim to isolate server name

swuehl — Mon, 17 Aug 2015 19:34:15 GMT

Or using Textbetween()

=TextBetween('\\server1\Folder','\\','\')

=TextBetween(path ,'\\','\')