topic Re: How to split a single string into individual letters ? Is there any function ? in QlikView

How to split a single string into individual letters ? Is there any function ?

shekhar_analyti — Wed, 25 Nov 2020 16:16:04 GMT

Hi All ,

How to split a single string into individual letters ?

Example : A field called PASSWORD has values

PASSWORD

@aklipo

3!5576

i want to split them like

@ and @ k l i p o

and store in table , so that table is read by reading software .

Thanks & Regards

Shekar

Re: How to split a single string into individual letters ? Is there any function ?

t_chetirbok — Thu, 21 Dec 2017 06:52:40 GMT

hi Shekar,

Do you want to have both options: each letter in a new column and each letter in a new row?

or it's enough to have each letter in a new row

Re: How to split a single string into individual letters ? Is there any function ?

shekhar_analyti — Thu, 21 Dec 2017 06:56:39 GMT

Actually i am testing an application which read letters and pronounces it out .
So basically a this point of time i am not sure which will be better , hence i opted for both the options .

However anything is fine , in case if both ways are not realistic requirement .

Thanks

Shekar

Re: How to split a single string into individual letters ? Is there any function ?

t_chetirbok — Thu, 21 Dec 2017 06:58:06 GMT

try this:

load PASSWORD, if(iterno()=1,1,0) as FirstLetterFlag,

mid(PASSWORD,IterNo(),1 ) as letter

while IterNo()<=len(PASSWORD);

load * Inline

[

PASSWORD

@aklipo

3!5576

]

;

Re: How to split a single string into individual letters ? Is there any function ?

tresB — Thu, 21 Dec 2017 06:59:39 GMT

Try this:

Load

PASSWORD,

mid(PASSWORD,IterNo(),1) as Characters

While iterno()<=Len(PASSWORD);

Load * Inline [

PASSWORD

@aklipo

3!5576]

Re: How to split a single string into individual letters ? Is there any function ?

tresB — Thu, 21 Dec 2017 07:00:55 GMT

Too fast!

Re: How to split a single string into individual letters ? Is there any function ?

Anil_Babu_Samineni — Thu, 21 Dec 2017 07:01:01 GMT

Perhaps this?

Load

PASSWORD,

mid(PASSWORD,IterNo(),1) as Characters

While iterno()<=Len(PASSWORD);

Load * Inline [

PASSWORD

@aklipo

3!5576

];

Re: How to split a single string into individual letters ? Is there any function ?

t_chetirbok — Thu, 21 Dec 2017 07:01:34 GMT

Re: How to split a single string into individual letters ? Is there any function ?

shekhar_analyti — Thu, 21 Dec 2017 07:05:25 GMT

So there is no function that Qlik provides ...

To achieve above without using explicit loops in a way .....

It will be a great help if i get it in columan wise

Re: How to split a single string into individual letters ? Is there any function ?

Anil_Babu_Samineni — Thu, 21 Dec 2017 07:07:29 GMT

No, In UI what you are looking and which object. Is there anything issue from script?

Re: How to split a single string into individual letters ? Is there any function ?

shekhar_analyti — Thu, 21 Dec 2017 07:23:44 GMT

I want each letters in separate columns with column name as Letter1 , Letter2 , Letter3 .... and so on

Example

PASSWORD Letter1 Letter2 Letter3 ............... Letter(i)

CAR C A R

Re: How to split a single string into individual letters ? Is there any function ?

t_chetirbok — Thu, 21 Dec 2017 07:36:50 GMT

for columns

PASS:

load * Inline

[

PASSWORD

@aklipo

3!5576

yhF&kd#1

]

;

max:

load max(len(PASSWORD)) as Max_Size Resident PASS;

let Num = peek('Max_Size') ;

drop Table max;

sub filling(Number)

left join(PASS)

load PASSWORD , if(len(PASSWORD)>=$(Number),mid(PASSWORD,$(Number),1),null()) as Letter$(Number) Resident PASS;

ENDSUB

for i=1 to $(Num)

call filling($(i));

Re: How to split a single string into individual letters ? Is there any function ?

shekhar_analyti — Thu, 21 Dec 2017 07:41:38 GMT

Take a bow

Re: How to split a single string into individual letters ? Is there any function ?

shekhar_analyti — Thu, 21 Dec 2017 07:49:32 GMT

Please help me understanding $(Number)

if(len(PASSWORD)>=$(Number)

Re: How to split a single string into individual letters ? Is there any function ?

t_chetirbok — Thu, 21 Dec 2017 08:30:40 GMT

$(Number) is a variable for creating and filling new fields

the procedure is called in a loop

call filling(1) - will create one new field Letter1

the condition if(len(PASSWORD)>=$(Number) is used for checking if the letter that we want to create is still in the password or we separated all letters.

for example call filling(8): in @aklipo 7 letters, that means we should put "letter8" column null value

I hope my explanation was clear)

Re: How to split a single string into individual letters ? Is there any function ?

MarcoWedel — Thu, 21 Dec 2017 23:58:57 GMT

Hi,

another solution might be:

table1:
Generic
LOAD *,
    'Char'&IterNo(),
    Mid(PASSWORD,IterNo(),1)
INLINE [
    PASSWORD
    @aklipo
    3!5576
] While IterNo()<=Len(PASSWORD);

hope this helps

regards

Marco

Re: How to split a single string into individual letters ? Is there any function ?

tresB — Fri, 22 Dec 2017 05:14:36 GMT

Hi Marco,

I was trying to achieve the similar - separated characters in listbox looping through the value characters purely in the UI. I was trying with valueloop(). But could not manage to do it. I have seen some tricky and nice solutions from you. Could you please give this a try too?

Re: How to split a single string into individual letters ? Is there any function ?

shekhar_analyti — Fri, 22 Dec 2017 12:46:15 GMT

Thank you all for the solution ...

Re: How to split a single string into individual letters ? Is there any function ?

MarcoWedel — Fri, 22 Dec 2017 22:58:32 GMT

Hi,

maybe these examples might be helpful?

table1:

LOAD Text(PASSWORD) as PASSWORD

Inline [

PASSWORD

@aklipo

3!5576

Password

P@$$w0rd

MySecret

Test

1234

12345

qwerty

1q2w3e

];

Marco