How to remove symbols '/' from cell values?

[#1]

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 · Accepted solution]

Hi,

Use subfield(IndexID,'/',1)

Regards

[Anonymous]

Use subfield():

subfield(IndexID,'/',1)

[#4]

Hi,

You can use in script.

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

[robert_mika]

or in script:

load

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

[#6]

This is what you need.

Check the attached file.

Mohssine AMHACHI

[#7]

Use subfiled() function in the script:

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

[vishsaggi]

Hi,

You can also use this, Just another Way.

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

Regards,
Vish.

[#9]

Thanks for all answers.