Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

please tell me the below answers

1)  ASCII and character values to display in table

2) this is variable my string function

let vrepeat=Repeat('*#',4);

output  : *#*#*#*#  display..okay

let vrepeat=Repeat('&*#',3);

i want output is & *#*#*# like that ..

3)Remove the character(#) in the name field

4) this my table

firstname          lastname

rajeev               sunkara

i want to display like  rajeevsunkara

2 Replies
ariel_klien
Valued Contributor

Re: please tell me the below answers

1) I didn't understood  what you meant ... for ASCII numbers you can use chr(#)

2)  let vrepeat= '& ' & Repeat('*#',3);

3) PurgeChar(fieldName,'#')

4) firstname&lastname as Full_name   



BR


Ariel  

rnt
Valued Contributor

Re: please tell me the below answers

1) Do you want a table with all ASCII characters and their respective number?

Characters:

Load Chr(RecNo()+Ord('A')-1) as Alpha, Ord('A') - 1 + RecNo() as Num autogenerate 26;

This will create a table from A - Z (upper case) and respective numbers (65-90)