Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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??
Have a look at PurgeChar()/Keepchar().
Have a look at PurgeChar()/Keepchar().
erm...what is that?i'm new for QV.....sry about that...
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.
it gv me error in calculation dimension.....
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.
I tried both for PurgeChar()/Keepchar().....both also gv me error in calculation in dimension....any idea tresesco???
What is the expected output from the your sample string 'PX42/ABCDEFG1234/0.222342' ? Do you need decimal?
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.
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??