Need to consider Numeric values after an Alphabet in my straight table or pivot for

[nikita23]

Hi Guys,

I am having a column called "Station" which contains value as below:

Station

R01

R98

UPS

LUX

AAH

RGB

RT1

R97

R12

R34

Now I want to fetch the values with alphabet starts with 'R' along with numeric values after it  like 

output:

Station

R01

R98

R97

R12

R34

May thanks in advance!!

[REON_LEE]

Hope this can help you.

Table_A:

Load*

From XXX

where wildmatch(Station,'R*');

[nikita23]

Hi Reon,

this will return RGB and RT1 as well.

Output as below :
Station
RGB
RT1
R01
R98
R97
R12
R34

[Edvin]

You can modify Reon given example by:

Table_A:

Load*

From XXX

where wildmatch(Station,'R0*','R1*','R2*','R3*','R4*','R5*','R6*','R7*','R8*','R9*');

Hope this helps you.

[nikita23]

Thanks Edvin!!

Its working fine but it will consider the fields like as below

R2T,

R9U etc

I need values after R in numeric only. if you know any solution then please let me know.

[tresesco · Accepted solution]

Try this?

If(Left(String,1)='R' and IsNum(Mid(String,2)), String) as Output

[REON_LEE]

You can try this below.

Table_A:

Load*

From XXX

where wildmatch(Station,'R*') and IsNum(Mid(Station,2));

[nikita23]

Thank you so much Tresesco!

It works absolutely fine.

[Sue_Macaluso]

@nikita23  I know you received your answer but I would still like to move this into the correct product forum.  Are you using QlikView? I just want to confirm before I move this. Thanks 

[nikita23]

Hi,

I am using QlikSense.