Project and Portfolio Management Practitioners Forum
cancel

When [...] is not a token.

Highlighted
AlekseyG
Super Contributor.

When [...] is not a token.

Hello!

 

I want to use the string containing  '[^,]+' in sql request type rule but the system interprets it as a token and doesn't allow me to save the rule...

How to spell (what simbol to add before "[" maybe) to mark that it's not a token?

 

Thanks! 

3 REPLIES
Natalia_R_PPM
Super Contributor.

Re: When [...] is not a token.

Hello AlekseyG,

 

 

Actually there are other users that reported similar issues in the past with strings that works in SQLTools but not in PPM.

There is a ER created for this issue, but the status is deferred

 

In PPM SQL this is treated as [^#@' || '#] is a Token, there should be way to treat is as string

 

 

 

I will search a little more in order to find if there a way to run these sql in PPM without confusing with a token.

 

Regards,

Natalia Rojas.

 

 

HP Support
If you find that this or any post resolves your issue, please be sure to mark it as an accepted solution.
Utkarsh_Mishra
Acclaimed Contributor.

Re: When [...] is not a token.

Are you trying to use Oracle regexp_substr ?

 

There are other ways to achive same functionality...

Cheers..
Utkarsh Mishra

-- Remember to give Kudos to answers! (click the KUDOS star)
AlekseyG
Super Contributor.

Re: When [...] is not a token.

Hello Utkarsh Mishra!

 

It would be great if you helped me to find the way.

 

I have two comma-separated strings:

'1,2,3', '4,5,6'

And want to split it into several rows and two columns:

 

1  4

2  5

3  6