Discussion Board for collaboration related to QlikView App Development.
I got a qvw that reads in data from excel and then adds it to nPrint.No spaces are allowed in [e-post] as well it has to be lowercase.
I sorted out the lower as lower([e-post]) as [e-post],
Can I make one line to handle both the lower and the remove of spaces in e-post?
I read about 10 posts in the forum but could not find anything that worked, I tried a few different trims, replace etc.
The space can be anywhere in the e-mail, it's users who adds them.
Maybe: lower(purgechar([e-post], ' ')) as [e-post]
View solution in original post
trim(PurgeChar([e-post],' ')) as [e-post], this solved first problem,but can I incoporate lower on the same line?
I used to have lower([e-post]) as [e-post] for the lower before I added this.
Lower(Replace([e-post], ' ', '')) as [e-post],
lower(PurgeChar([e-post],' ')) as [e-post], worked space between '' ofc, thank you for the help!
You could easily nest these functions - depending on the task (not in this case) it might be useful to apply functions like lower/upper at the most inside because it could reduce the efforts with the keepchar/purgechar and similar.
Both these expressions should work:
PurgeChar( Lower([e-m ai l]), ' ')
Replace( Lower([e-m ai l]), ' ','')
Using this script:
LOAD * inline [e-m ai ljacob T@qlikcommunity.comVegar@ qlik community.com];