Cut FQDN to host and domain

[#1]

Hi there again,

today I have a new Problem:

I have a list of FQDNs and paths, like:

//df020.sample.com/dfs/test$

test123.sample.com

new123.sample.com

//tf030.sample.com/new123

etc.

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.

[tresesco · Accepted solution]

Try like:

Load

          PurgeChar(SubField(YourField, '.',1), '/') as HostName,

          SubField(YourField, '.',2) as Domain

[#3]

Hi Tresesco,

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?!

[tresesco]

Could you give one such example (the entire field value) that failed?

[#5]

Some failed ones:

aaaraehu000300p.sample.com

aawrtgj000500st.sample.com

nt546674dr.sample.com

mg45ffrt.sample.com

Good ones:

0dg556de.sample.com

586775436.sample.com

Every value starting with numbers is ok....

[tresesco]

I guess it would be something else that is causing the problem. Otherwise, for these values too the expression should work like:

[#7]

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?

[tresesco]

IsText() - to check if text or not

Text() - to convert into text

[#9]

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?

[tresesco]

Could you share the sample qvw with sample data to look into the issue?