
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Need to consider Numeric values after an Alphabet in my straight table or pivot for
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!!
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Try this?
If(Left(String,1)='R' and IsNum(Mid(String,2)), String) as Output

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hope this can help you.
Table_A:
Load*
From XXX
where wildmatch(Station,'R*');

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Reon,
this will return RGB and RT1 as well.
Output as below :
Station
RGB
RT1
R01
R98
R97
R12
R34

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Table_A:
Load*
From XXX
where wildmatch(Station,'R0*','R1*','R2*','R3*','R4*','R5*','R6*','R7*','R8*','R9*');
Hope this helps you.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Try this?
If(Left(String,1)='R' and IsNum(Mid(String,2)), String) as Output

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
You can try this below.
Table_A:
Load*
From XXX
where wildmatch(Station,'R*') and IsNum(Mid(Station,2));

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thank you so much Tresesco!
It works absolutely fine.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
I am using QlikSense.
