topic Re: substring within string. in App Development

substring within string.

YADAVSLN — Sun, 24 Feb 2019 04:16:15 GMT

HI All,

I Have a scenario like this:

Example

Name

Team Member (10000)

Team leader (20000)

Ass Manager (40000)

Manager (60000)

Consultant (120000)

Associate Consultant (1300000)

Senior Consultant (60080)

I want Out put like this;

Name Code

Team Member (10000)

Team leader (20000)

Ass Manager (40000)

Manager (60000)

Consultant (120000)

Associate Consultant (1300000)

Senior Consultant (60080)

Could you please suggest me.Thanks in Adv.

Regards,

YADAVSLN.

Re: substring within string.

pradosh_thakur — Sun, 24 Feb 2019 06:50:13 GMT

load Left(Name,Index(Name,'(')-1) as Name,mid(Name,Index(Name,'(')) as Code Inline [
Name 

Team Member (10000)

Team leader (20000)

Ass Manager (40000)

Manager (60000)

Consultant   (120000)

Associate  Consultant (1300000)

Senior Consultant  (60080)

];

Re: substring within string.

maxgro — Sun, 24 Feb 2019 09:59:05 GMT

Another solution: if you only have one '(' for row, you can use the subfield funtion

Names: 
Load * inline [
Name
Team Member (10000)
Team leader (20000)
Ass Manager (40000)
Manager (60000)
Consultant   (120000)
Associate  Consultant (1300000)
Senior Consultant  (60080)
];

[2Cols]:
Load
	subfield(Name,'(', 1) as Name,
	'(' & subfield(Name,'(', 2) as Code
Resident Names;

DROP Table Names;

Re: substring within string.

jonathandienst — Mon, 25 Feb 2019 05:54:03 GMT

Did you know that you can subfield from the RHS of the string as well?

Table:
LOAD trim(left(Name, len(code))) as Name, Code;
LOAD Name, SubField(Name, ' ', -1) as Code
Inline
[
	Name
	...