
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Opposite of concatenate
Hello
I would like to know what expression should be used to split data. Something similar to Excel's text to column functionality. I have looked at the left and right functions, but really need to extract the text prior to other text.
See below example of lines;
6 Work Order
295 Work Order
I would like to extract the "6" and the "295" and left function will not work as the length is variable. I really need the left of the word "work"
Hope this makes sense. cheers
- Tags:
- new_to_qlikview
- « Previous Replies
-
- 1
- 2
- Next Replies »
Accepted Solutions


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hello Chris, can you please mark this question as answered if you're happy. Thanks.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
SubField()
SubField('295 Work Order' , ' ',1) // gives 295, so to generalise, you can try:
SubField(YourField, ' ',1)


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
keepchar ( 'yourfield','0123456789' )

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May be like this..
=Left('295 Work Order',Index('295 Work Order','Work')-1)
Instead of '295 Work Order', you can use field name
Karthik


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
There are lots of way to do this, and you can use left if you want:
left(Field,Index(Field,' ')-1)

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thank you!
Sent from my iPhone

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thank you
Sent from my iPhone

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thank you
Sent from my iPhone

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thank you
Sent from my iPhone


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hello Chris, can you please mark this question as answered if you're happy. Thanks.

- « Previous Replies
-
- 1
- 2
- Next Replies »