How to fetch a particular section of data from a field

[#1]

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

[#2]

try whis : left(filename( ),6)

[#3]

or if length isn't constans

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

[#4]

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

[#5]

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

[#6 · Accepted solution]

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