How to convert Number to Text

[balasundaram]

I Have to convert 16 digit number into text.Because Csv&Excel supports only 15digit numeric number.

ex:-

4567321789012347(qlikview) this number coming  like 4567321789012340(csv&excel) . last digit coming ZERO

[balasundaram]

sample code:

b:

LOAD * INLINE [

    sno, name

    8520000197286155, chiru

    8520000197286156, pathi

];

NoConcatenate

b1:

LOAD text(sno) as sno,

name

Resident b;

DROP Table b;

STORE b1 into b.csv(txt,delimiter is ',');

In b.csv file iam getting

sno

8520000197286150,

8520000197286150

last digit coming ZERO

[balasundaram]

sample code:

b:

LOAD * INLINE [

    sno, name

    8520000197286155, chiru

    8520000197286156, pathi

];

NoConcatenate

b1:

LOAD text(sno) as sno,

name

Resident b;

DROP Table b;

STORE b1 into b.csv(txt,delimiter is ',');

In b.csv file iam getting

sno

8520000197286150,

8520000197286150

last digit coming ZERO

[Roop]

This is a problem within Excel and not QlikView. The only way in which I can see to do this is to put some form of character on the from of the exported number.

The problem is that Excel will always convert a number type of field into a number and then it does not have enough significant places to hold the full number.

So the best that I can do is prepend an alphabetic character to the front of the number.

Note: even using the single quote at the front of the number does not work the way that Excel would normally operate

Possible a different CodePage may work but I have not tried that approach

Hope that this helps

[balasundaram]

thyank..u

[maxgro]

in csv iam getting

[#7]

Hi, I tried your sample, seems excel 2003 will display 8520000197286150, but since it's csv file, if you open the file by notepad, the data was stored as

sno,name

8520000197286155,chiru

8520000197286156,pathi

so, i believe it just an excel display issue.

[#8]

Hi,

Usually I put another delimiter, like tabulation, so that I can choose format when I convert csv in xlsx. Otherwise, you can try Text(YourNumber) or ''&YourNumber and then store into csv (txt, delimiter is ',', msq).

The msq will put quotes around your number-text and force Excel to interpret it as text.

Hope this helps.

[#9]

TEXT()