
Partner - Creator II
2016-02-04
10:52 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Identify Number and strings
HI,
One column contains strings and numbers. i want to group them and store two separate colums as number and string
I know how to do this with numbers
if(IsNum(Left(Mid(tId,2),1)),tId) as num,
but how can i extract strings?
- Tags:
- new_to_qlikview
630 Views
4 Replies

.png)
Luminary Alumni
2016-02-04
10:54 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
HI,
if(Not IsNum(Left(Mid(tId,2),1)),tId) as string,
Regards,
jagan.
492 Views

.png)
Luminary Alumni
2016-02-04
10:55 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
One more method
if(Not IsText(Left(Mid(tId,2),1)),tId) as string,
Regards,
Jagan.


Master III
2016-02-04
11:41 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Can you give some sample data?
May be like this..
KeepChar(tId,'0123456789') as Num1,
KeepChar(Lower(tId),'abcdefghijklmnopqrstuvwxyz') as Text


Partner - Champion III
2016-02-05
12:02 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Please provide some sample values and your desired output.
Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
492 Views
