topic Re: String to integer conversion in QlikView

String to integer conversion

Tue, 26 Aug 2014 08:01:57 GMT

Is it possible to convert the format from string into integer in QV? For example my data is : PX42/ABCDEFG1234/0.222342 and i want to convert it to integer....as a number....is it possible for me??

Re: String to integer conversion

tresB — Tue, 26 Aug 2014 08:09:09 GMT

Have a look at PurgeChar()/Keepchar().

Re: String to integer conversion

Tue, 26 Aug 2014 08:15:15 GMT

erm...what is that?i'm new for QV.....sry about that...

Re: String to integer conversion

jagan — Tue, 26 Aug 2014 08:17:21 GMT

Hi,

Try like this

=KeepChar('PX42/ABCDEFG1234/0.222342', '1234567890')

LOAD

KeepChar(DimensionName, '1234567890') as FormattedNumber

FROM DataSource;

Note: Replace DimensionName with your actual field name.

Regards,

Jagan.

Re: String to integer conversion

Tue, 26 Aug 2014 08:20:05 GMT

it gv me error in calculation dimension.....

Re: String to integer conversion

tresB — Tue, 26 Aug 2014 08:20:47 GMT

Those are functions.

PurgeChar('12345@#67#@', '#@') -> gives output : 123456 , simply purges the characters (second parameter from the main string(first parameter).

keepChar() -> similarly does the reverse, keeps only the characters mentioned as the second argument. For details see help.

Re: String to integer conversion

Tue, 26 Aug 2014 08:21:20 GMT

I tried both for PurgeChar()/Keepchar().....both also gv me error in calculation in dimension....any idea tresesco???

Re: String to integer conversion

tresB — Tue, 26 Aug 2014 08:26:40 GMT

What is the expected output from the your sample string 'PX42/ABCDEFG1234/0.222342' ? Do you need decimal?

Re: String to integer conversion

jagan — Tue, 26 Aug 2014 08:30:48 GMT

Hi,

Do this in load script, so that it would be easier in front end.

LOAD

KeepChar(DimensionName, '1234567890') as FormattedNumber

FROM DataSource;

Regards,

Jagan.

Re: String to integer conversion

Tue, 26 Aug 2014 08:37:56 GMT

ya i try yr purgechar and keepchar already....its both work very well for me.....then now i want to ask if i want to convert only one character to ASCII value or a value.....izzit possible for me??

for example S is equal to 83 and P is equal to 80.....i found this on ASCII table....but if i want to do it on QV.....can??

Re: String to integer conversion

tresB — Tue, 26 Aug 2014 08:42:58 GMT

Use Ord(), like:

Ord('P') gives 80

Re: String to integer conversion

jagan — Tue, 26 Aug 2014 08:53:43 GMT

Hi,

Try like this

CharMap:

Mapping LOAD

Chr(RecNo() - 1) AS Char,

RecNo() - 1 AS Asciicode

AutoGenerate 256;

Data:

LOAD

DimName,

MapSubString('CharMap', DimName) as formattedText

FROM DataSource;

Note: Replace DimName with your actual field name.

Regards,

Jagan.

Re: String to integer conversion

Wed, 27 Aug 2014 00:52:41 GMT

Sry Tresesco disturb u again.....the Ord() function is for 1 charc only? if i have a string "abv123456" and then i want to convert it all to ASCII code.......possible??

Re: String to integer conversion

jagan — Wed, 27 Aug 2014 01:22:56 GMT

Hi Lee,

Is code posted in previous post is working?

Regards,

Jagan.

Re: String to integer conversion

Wed, 27 Aug 2014 01:26:18 GMT

all all work and i click it as correct ans already....^^

Re: String to integer conversion

Wed, 27 Aug 2014 01:47:55 GMT

mohan....i want to ask if i hv one table like below.....then i want to delete the duplicate row in the table.....can??

Like the row with x42 x51 and x52 and twice rite? so if i want to delete it can or not??

Re: String to integer conversion

jagan — Wed, 27 Aug 2014 01:56:24 GMT

HI Lee,

Try like this

If you have only one field then use

LOAD

DISTINCT Bin

FROM DataSource;

Or if you have other fields then use

Data:

LOAD

WHERE Flag = 1;

LOAD

If(Previous(Bin) <> Bin, 1) AS Flag;

LOAD

FROM DataSource

ORDER By Bin, Field1, Field2.....;

Note: Replace Field1, Field2 with your fields to prioritize and identify the first record

Regards,

Jagan.

Re: String to integer conversion

Wed, 27 Aug 2014 02:03:20 GMT

cannot be load the data.....can write some coding in the expression there only to delete the duplicate data instead of changing in the script??

Re: String to integer conversion

jagan — Wed, 27 Aug 2014 02:06:18 GMT

Hi,

Can you attach some sample, I didn't understand what you actually required, attach some sample and your expected output.

Regards,

Jagan.

Re: String to integer conversion

Wed, 27 Aug 2014 02:13:32 GMT

The table above is i created on the QV.....n then u can see the above hv the duplicate value rite?

so i wish i can write something on the dimension parameter there with some formula or coding to delete the duplicate data....like x42 i only want 1 enough......x51 and x52 also want 1 enough already in my table.....that what i want.....so can or not if i want like this??