Qlikview script function to remove leading spaces at the end

[#1]

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

[Chanty4u]

i think Typo mistake

?

did u chked the letters of ur field name

[Chanty4u]

i think Typo mistake

?

did u chked the letters of ur field name

[avinashelite]

could you please share the sample data

[#5]

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

[#6]

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

[#7]

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.

[Chanty4u]

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

[#9]

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

[MayilVahanan]

Hi

Try like this

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

Give one space befr and after "-"

[MayilVahanan]

Hi

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