Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
i think Typo mistake
?
did u chked the letters of ur field name
i think Typo mistake
?
did u chked the letters of ur field name
could you please share the sample data
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 |
Spaces occurs both at the beginning and end of both material and material description
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.
u can create a maping table and use[ mapsubsring ]funcion
Can you please elaborate about it. How to do the mapping function
Hi
Try like this
Trim(Material) &' - '& Trim([Material Desc]) As MaterialWithDesc
Give one space befr and after "-"
Hi
Is it possible to post your sample excel file for more analysis?