Another simpleton question: Turn nr. into str

[datanibbler]

Hi,

my issue is very simple: I have eight tables to CONCATENATE in the script. Seven of them have a nr. (the nr. of a delivery_slot, like "81, 82, 83" - one has a nr. and a text, "73-LV".

=> I have already enclosed them all in upper quotes,  but still those seven are regarded as numbers and displayed on the right-hand side of a listbox, the eigth is regarded as text and displayed on the left.

=> How can I make them all the same (text)?

Thanks a lot!

Best regards,

DataNibbler

[agilos_mla · Accepted solution]

Load Text([FieldName]) AS FieldName,

Or in the presentation tab of the list box, set the alignment on left/right for numbers and texts

Michael.

[atsushi_saijo]

Good morning. This is typecast and TEXT() is used to convert datatype into text. However; once typecasted, they are not read as number.

[ashwanin]

=text(field) as Field

in script

[datanibbler]

Hi,

thanks! The display on the left and right is, of course, only a symptom and not a big deal in itself - but there should not be this difference.

I'll use this function.

Best regards,

DataNibbler