topic Re: Trim in QlikView

Trim

everest226 — Wed, 25 Nov 2020 16:16:04 GMT

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,

Re: Trim

vishsaggi — Thu, 15 Dec 2016 23:55:02 GMT

Can you use subfield?

Do you have a list how it is coming?I mean is there a path?

Subfield('document', '.qvw',1)

Re: Trim

Fri, 16 Dec 2016 09:41:33 GMT

Hi Ujjwal,

https://help.qlik.com/en-US/qlikview/12.1/Subsystems/Client/Content/Scripting/StringFunctions/Trim.htm

Trim - script and chart function

Trim() returns the input string trimmed of any leading and trailing spaces.

Syntax:

Trim(text)

Return data type: string

Example	Result
Trim( ' abc' )	Returns 'abc'
Trim( 'abc ' )	Returns 'abc'
Trim( ' abc ' )	Returns 'abc'

Thanks,

Re: Trim

Fri, 16 Dec 2016 09:46:38 GMT

You can use the Replace() function in your load script.

Just simple put in Replace(.qvw column name, '.qwv', '')
With this you replace the .qvw part with nothing by putting two apostrophe's.

Hope I have helped you with this

Re: Trim

Anonymous — Fri, 16 Dec 2016 10:47:44 GMT

HI,

You can use subfield() as following...

subfield(FieldName,'.',1) as NewFieldName.

through above you will get left side value of dot ".".

Thanks,

Re: Trim

everest226 — Fri, 16 Dec 2016 17:53:25 GMT

Thanks Pooja ,

i tried this and it works .

Replace(Lower(Subfield(Document,'\',-1)),'.qvw','') as QVWName,

Re: Trim

tamilarasu — Sat, 17 Dec 2016 07:11:44 GMT

Hi,

I see that you made use of my solution but I am not sure why you deleted my comment. I just want to let you know that I don't post only for you but for the benefits of others who will come across such scenario.

I am posting it again for others sake.

Replace(Lower(Subfield(Document,'\',-1)),'.qvw','') as QVWName,

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

Re: Trim

maxgro — Sat, 17 Dec 2016 07:54:55 GMT

Another one, using subfield onl

SubField(Lower(SubField(Document, '\', -1)), '.qvw', 1)

Re: Trim

sasiparupudi1 — Mon, 19 Dec 2016 12:53:49 GMT

Try

Left(DocumentName(),Index(DocumentName(),'.')-1)

Re: Trim

everest226 — Mon, 19 Dec 2016 21:52:41 GMT

Thanks tamilarasu‌ thanks for help. and also does that will only trim the document which has .QVW at the end. coz some document name does not have QVW at the end thanks.

somehow by accident it got deleted.

Thanks Again

Re: Trim

tamilarasu — Tue, 20 Dec 2016 01:49:22 GMT

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','')

Re: Trim

venkat1 — Wed, 13 Nov 2019 11:55:35 GMT

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?