Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
try whis : left(filename( ),6)
or if length isn't constans
left(filename(),index(filename(),'.'))
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
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
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