Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to fetch a particular section of data from a field

Dear All,

I have a field name as Section where my data is like:

Section

AA_D_B.<YYYY_MM_DD>.qvd

BB_S_D.<YYYY_MM_DD>.qvd

Now i want to take only the name before the . in the field ex:

AA_D_B and BB_S_D from the section field in my Qv Apps.

Kindly please suggest me a solution

Regards,

Pranav

1 Solution

Accepted Solutions
Not applicable
Author

Hi all,

Pari solution is helpful but if i use it it also take '.' at last, so to remove '.' from the fileds

i have modified the solution a bit

its like left(filename(),index(filename(),'.') -1)

Thanks

Pranav

View solution in original post

5 Replies
Not applicable
Author

try whis : left(filename( ),6)

Not applicable
Author

or if length isn't constans

left(filename(),index(filename(),'.'))

Not applicable
Author

Hi Pari,

If i am using you solution

left(filename(),index(filename(),'.')) because length isn't constant in my data.

Then the value splits and come as AA_D_B. and BB_S_D.

'.' is also coming with the filed can you tell me how to take out '.' from it.

Thanks & Regards,

Pranav

Not applicable
Author

Hi Pari,

Thanks for your Solution.

It works but if i use

left(filename(),index(filename(),'.'))

Then it will fetch data with AA_D_B. '.' at last also.

so to take out '.' from last i have modified the script as

left(filename(),index(filename(),'.') -1 )

This works perfectly,

Thanks again,,

Pranav

Not applicable
Author

Hi all,

Pari solution is helpful but if i use it it also take '.' at last, so to remove '.' from the fileds

i have modified the solution a bit

its like left(filename(),index(filename(),'.') -1)

Thanks

Pranav