Trim

[everest226]

hi i have a apps that read data from server logfile . it capture all the apps name as ####.qvw , is there any way when its load then trim qvw.

i only want document  name ,  for example     Finance.qvw   as finance

This is my load script

Lower(Mid(Document,Index(Document,'\',-1)+1)) as QVWName,

[tamilarasu]

Hi Ujjwal,

No problem. You can test the expression by simply copy and paste in two text box's. It will work in both the cases.

=Replace(Lower(Subfield('C:\Users\User1\Desktop\Test.qvw','\',-1)),'.qvw','')

=Replace(Lower(Subfield('C:\Users\User1\Desktop\Test','\',-1)),'.qvw','')

[venkat1]

it works... 🙂

but i need to trim front string also for example

c:/user/publish/finance.qvw

here i want only fiance ,how to dot his?