Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hi,
Use subfield(IndexID,'/',1)
Regards
Hi,
Use subfield(IndexID,'/',1)
Regards
Use subfield():
subfield(IndexID,'/',1)
Hi,
You can use in script.
SubField(IndexID,',',1) as Index_ID,
or in script:
load
textbetween(IndexID,'','/') as ID
This is what you need.
Check the attached file.
Mohssine AMHACHI
Use subfiled() function in the script:
subfield(IndexID,'/',1) as IndexID
Hi,
You can also use this, Just another Way.
left(IndexID, index(IndexID,'/',1)-1) As IndexID
Regards,
Vish.
Thanks for all answers.