Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Friends,
I have one column with values 01,02,03,87,89,98etc
I want to use match function. How to convert these numbers to string so that It will be easy for me to comparision.
Thanks
Pavan
Hello
You can use text(number_field) to convert it to string.
If you want this number with the zeros in the left, you can use text(num(number_field,'00')). This way will keep, for example, "01".
Hope it helps.
Regards,
Gabriel
see if this is you need.
Hi,
try with Text(Trim(Field))
Hope this helps.
Hi,
you can use text(field) then the values will be converted to string.
If you have 01 you have yet a value in string format, try to add more details to your request
Hello
You can use text(number_field) to convert it to string.
If you want this number with the zeros in the left, you can use text(num(number_field,'00')). This way will keep, for example, "01".
Hope it helps.
Regards,
Gabriel
Hi,
try this
Text(field value)