String to integer conversion

[#1]

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??

[tresesco]

Use Ord(), like:

Ord('P')  gives 80

[jagan]

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.

[#4]

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??

[jagan]

Hi Lee,

Is code posted in previous post is working?

Regards,

Jagan.

[#6]

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

[#7]

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??

[jagan]

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.

[#9]

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??

[jagan]

Hi,

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

Regards,

Jagan.

[#11]

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??