Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi community,
Please i want to transform a field INTEGER to a field STRING in Load statement?
For example : Let take this script.
Ligne:
LOAD CodeLigne,
LibelleLigne,
NumLigne,
CodeSsSousGroupe,
CodeSousGroupe,
CodeGroupe
FROM
Structure_Edition_V02.xls
(biff, embedded labels, table is Ligne$);
The type of field NumLigne is INTEGER,
I want to transform it in STRING.
How to do???
Thanks.
Hello Yimen,
Use Text() function. In the following example
Text('000001') AS TextField, Num(000001) AS NumField
TextField will return all preceding zeroes, as the field is considered text, while NumField will return just "1", as preceding zeroes don't count.
Hope that helps