topic Re: How to remove symbols '/' from cell values? in QlikView

How to remove symbols '/' from cell values?

Thu, 02 Apr 2015 13:14:41 GMT

Hi,

I have data in excel as below. there are more rows like this

IndexID= 039327/607685.

I want to show in table IndexID= 039327

so, I don't want to display anything right to the symbol '/'

Please can anyone how to remove these.

Thanks.

PrashantSangle — Thu, 02 Apr 2015 13:17:02 GMT

Hi,

Use subfield(IndexID,'/',1)

Regards

Anonymous — Thu, 02 Apr 2015 13:17:03 GMT

Use subfield():

subfield(IndexID,'/',1)

Thu, 02 Apr 2015 13:22:14 GMT

Hi,

You can use in script.

SubField(IndexID,',',1) as Index_ID,

robert_mika — Thu, 02 Apr 2015 13:31:12 GMT

or in script:

load

textbetween(IndexID,'','/') as ID

Thu, 02 Apr 2015 13:32:30 GMT

This is what you need.

Check the attached file.

Mohssine AMHACHI

Thu, 02 Apr 2015 13:43:23 GMT

Use subfiled() function in the script:

subfield(IndexID,'/',1) as IndexID

vishsaggi — Thu, 02 Apr 2015 13:44:50 GMT

Hi,

You can also use this, Just another Way.

left(IndexID, index(IndexID,'/',1)-1) As IndexID

Regards,
Vish.

Thu, 02 Apr 2015 13:52:42 GMT

Thanks for all answers.