Seprating numbers out of string help!!!

[amit_saini]

Hi Folks ,

I'm having below scenario:

Were these KT-PartNo belongs to Plant codes highlighted after # in location filed

What I want to have is output like below , so that I can assign Location codes for KT-PartNo:

Please suggest how to do this???

Thanks,

AS

[danansell42]

Have you tried using the subfield function?

[Gysbert_Wassenaar]

KeepChar(SubField(Location,'#'), '01234567989') as Location

or maybe

TextBetween(SubField(Location,'#'), '#',' KT') as Location

[amit_saini]

Thanks Gysbert!

Buy why we are getting blanks:

Thanks,

AS

[#5]

=mid(Location,5,3)  is the answer. FYR: https://help.qlik.com/en-US/qlikview/12.0/Subsystems/Client/Content/Scripting/StringFunctions/Mid.ht...

[Gysbert_Wassenaar]

TextBetween(SubField(Mid(Location,Index(Location,'#')+1),'#'), '#',' KT') as Location

[amit_saini]

Sorry this is not working!

KeepChar(SubField(Location,'#'), '01234567989') as Location is working but showing some blank values

Thanks,

AS

[#8]

try my method Amit, i think it works in your case!

[MindaugasBacius · Accepted solution]

Use this:

SubField(right(KeepChar(Location, '#0123456789'), len(KeepChar(Location, '#0123456789'))-1), '#')

Result:

[MindaugasBacius]

SubField takes values from the left.

If there is value like #001#002#003, then the first SubField value that will be returned is a blank value.