topic Re: Qlikview script function to remove leading spaces at the end in QlikView

Qlikview script function to remove leading spaces at the end

Thu, 24 Mar 2016 20:02:56 GMT

Hi,

I want to know to how to remove the spaces at the end of the string.

Eg: the qlikview is a learning tool.

Qlikview is analytics tool.

The length of the string varies and the spaces of the string varies to each string.. For eg.. The string 1 contains 5 leading spaces at the end..

The 2nd string contains 10 leading spaces at the end..I can't use replace function for removing because it will remove all the spaces including the spaces in between the string...

Can u please provide solution for the issue..

Message was edited by: vinu priya

Re: Qlikview script function to remove leading spaces at the end

sinanozdemir — Thu, 24 Mar 2016 21:13:32 GMT

Can you try Trim() function?

Trim(Your_Column_Name) this should remove the spaces.

Re: Qlikview script function to remove leading spaces at the end

martinpohl — Thu, 24 Mar 2016 21:46:58 GMT

you can use ltrim and rtrim to trim spaces at the beginning and the end

ltrim(rtrim(yourfield)) as yourfield

trim will also delete spaces between text

Regards

Re: Qlikview script function to remove leading spaces at the end

MarcoWedel — Fri, 25 Mar 2016 02:43:28 GMT

Hi,

to only trim trailing spaces, you can use RTrim() :

RTrim ‒ QlikView

LTrim() only trims leading spaces

LTrim ‒ QlikView

and Trim() both leading and trailing spaces.

Trim ‒ QlikView

hope this helps

regards

Marco

Re: Qlikview script function to remove leading spaces at the end

avinashelite — Fri, 25 Mar 2016 05:37:39 GMT

RTrim(Your_field_name) // this will remove the spaces at the end

LTrim(Your_field_name) // this will remove the spaces at the start of your statement

Trim(Your_field_name) // this will remove the spaces in both the ends i.e. at the start and at the end of your statements

Re: Qlikview script function to remove leading spaces at the end

Mon, 28 Mar 2016 09:32:49 GMT

Hi All,

Thanks for your replies.

I have written function like

trim(Material) & ' ' & rtrim(Material_description) as Material_and_Description,

Because I'm having spaces at both the ends for Material and spaces at the end for material description column.

For material it is working and rtrim for Material description is not working.

Can you please suggest

Re: Qlikview script function to remove leading spaces at the end

Mon, 28 Mar 2016 09:36:11 GMT

Trim(Your_field_name)

Re: Qlikview script function to remove leading spaces at the end

Mon, 28 Mar 2016 09:37:19 GMT

Rtrim(material_description) is not removing the spaces at the end

Re: Qlikview script function to remove leading spaces at the end

Chanty4u — Mon, 28 Mar 2016 10:01:40 GMT

did u concatenated those fields?

if yes

trim(Material) & '_ ' & rtrim(Material_description) as Material_and_Description,

Re: Qlikview script function to remove leading spaces at the end

Mon, 28 Mar 2016 10:05:03 GMT

I used this function but the spaces at the end of the material description is still not removed.

Re: Qlikview script function to remove leading spaces at the end

Chanty4u — Mon, 28 Mar 2016 10:05:43 GMT

i think Typo mistake

did u chked the letters of ur field name

Re: Qlikview script function to remove leading spaces at the end

Chanty4u — Mon, 28 Mar 2016 10:16:29 GMT

i think Typo mistake

did u chked the letters of ur field name

Re: Qlikview script function to remove leading spaces at the end

avinashelite — Mon, 28 Mar 2016 10:16:42 GMT

could you please share the sample data

Re: Qlikview script function to remove leading spaces at the end

Mon, 28 Mar 2016 10:39:09 GMT

Here some data

Material	Material Desc
600007	RES SEPHAROSE FAST FLOW
600008	RES EPHAROSE FAST FLOW
600008	RES SP SEPHAROSE FAST FLOW
600009	RES MACR-PRP DRXYPTTE TYPE II80UM
600015	CHM 95% ETHYL 190 PROOF
600017	CHM MES MONOHYDRATE FREE ACID CRYSTLLINE
600017	CHM MES MONOHYDRATE FREE ACID CRYSTLLINE

Re: Qlikview script function to remove leading spaces at the end

Mon, 28 Mar 2016 10:39:51 GMT

Spaces occurs both at the beginning and end of both material and material description

Re: Qlikview script function to remove leading spaces at the end

Mon, 28 Mar 2016 10:43:54 GMT

Hi Avinash,

With my own sample data I am able to achieve the trim function. But I'm not able to do the same with the excel data in the original datasource from excel.

I think there is some problem with the data - Can you please help me out.

Re: Qlikview script function to remove leading spaces at the end

Chanty4u — Mon, 28 Mar 2016 10:50:07 GMT

u can create a maping table and use[ mapsubsring ]funcion

Re: Qlikview script function to remove leading spaces at the end

Mon, 28 Mar 2016 10:51:33 GMT

Can you please elaborate about it. How to do the mapping function

Re: Qlikview script function to remove leading spaces at the end

MayilVahanan — Mon, 28 Mar 2016 10:52:31 GMT

Try like this

Trim(Material) &' - '& Trim([Material Desc]) As MaterialWithDesc

Give one space befr and after "-"

Re: Qlikview script function to remove leading spaces at the end

MayilVahanan — Mon, 28 Mar 2016 10:53:45 GMT

Is it possible to post your sample excel file for more analysis?