Right sharing of fields

[beck_bakytbek]

Hi Folks,

i got a Situation, where  i am facing with the following issue, my fields do look like:

Project

121513_01

121513_02

121512_123

121512_1245

my expected Output does look like:

Project             PositionNr

121513                01

121513                02

121512                123

121512                1245

i used the Function: Right() but my results does look not correct, because the last number consist of 2, 3 or 4 Numbers.

Does anybody have any idea or Suggestion, how to resolve this issue?

Thanks a lot in Advance for Feedback and help

Beck

[pradosh_thakur · Accepted solution]

load subfield(Project,'_',1) as Project,

  subfield(Project,'_',2) as PositionNr

from


< Table anem>; 

[MindaugasBacius]

Subfield(Project, '_', 2) as PositionNr

Find more http://help.qlik.com/en-US/qlikview/12.0/Subsystems/Client/Content/Scripting/StringFunctions/SubFiel...

[pradosh_thakur]

load subfield(Project,'_',1) as Project,

  subfield(Project,'_',2) as PositionNr

inline [
Project

121513_01

121513_02

121512_123

121512_1245
];

[Somasundaram]

hi,

Use this.,

SubField(project,'-',1) as Project 

SubField(project,'-',2) as PositionNr

[Channa]

SubField(Project, ' _',1) as project,

SubField(Project, '_ ',-1) as projectNr

[beck_bakytbek]

Pradosh, thanks a lot for your time and help

[beck_bakytbek]

Bacius, thanks a lot for your help and time

[beck_bakytbek]

Somasundaram, thanks a lot for your time and help

[beck_bakytbek]

Channa, thanks a lot for your help and time