Discussion Board for collaboration on QlikView Layout & Visualizations.
Hi there again,
today I have a new Problem:
I have a list of FQDNs and paths, like:
I need the hostnames standalone in a new field like test123, new123 but not the pathes.
Pathes can left blank in this new field.
I tried left, rigt, subfield, etc. but nothing really works.
Anybody an idea?
Thx in advance.
Go to Solution.
PurgeChar(SubField(YourField, '.',1), '/') as HostName,
SubField(YourField, '.',2) as Domain
thanx for your fast answer.
I tried your formula, but there I only get hostnames starting with numbers,
every other hostname starting with letter is empty?!
Could you give one such example (the entire field value) that failed?
Some failed ones:
Every value starting with numbers is ok....
I guess it would be something else that is causing the problem. Otherwise, for these values too the expression should work like:
Hm, the problem must be anywhere else, you are right.
Is there a way to check in Qlik, if the values are all strings?
Or is there a chance to say: FQDN --> text?
IsText() - to check if text or not
Text() - to convert into text
They are all text....I don't understand this problem.
If I take the same data and cut it in Excel, everything is fine,
in Qlik only FQDNs with numbers at the start will work?
Could you share the sample qvw with sample data to look into the issue?