Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
load subfield(Project,'_',1) as Project, subfield(Project,'_',2) as PositionNr from < Table anem>;
load subfield(Project,'_',1) as Project, subfield(Project,'_',2) as PositionNr from < Table anem>;
load subfield(Project,'_',1) as Project, subfield(Project,'_',2) as PositionNr inline [ Project 121513_01 121513_02 121512_123 121512_1245 ];
hi,
Use this.,
SubField(project,'-',1) as Project
SubField(project,'-',2) as PositionNr
SubField(Project, ' _',1) as project,
SubField(Project, '_ ',-1) as projectNr
Pradosh, thanks a lot for your time and help
Bacius, thanks a lot for your help and time
Somasundaram, thanks a lot for your time and help
Channa, thanks a lot for your help and time