I have a field name as Section where my data is like:
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
try whis : left(filename( ),6)
or if length isn't constans
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,
Thanks for your Solution.
It works but if i use
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,
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)
Retrieving data ...