Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Specialist
Specialist

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  

Ralf-Narfeldt
Employee
Employee

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)