AnsweredAssumed Answered

How to format CSV file numbers

Question asked by JamesFenoulhet611119 on Nov 25, 2015
Latest reply on Jan 11, 2016 by JamesFenoulhet611119
I have used the :SET &HND# = PREP_PROCESS_FILE to import a csv. I have some large numbers classed as monetary values. Csv strips the formatting of these numbers so instead of displaying £1,234,567.00 I get 1234567.00.

Is there anyway i can format the text back into monetary values?

I am using the below to put the text into an HTML object
:   SET &COL1# = GET_PROCESS_LINE(&HND1#,1)
:         PUT_ATT_APPEND CALL_TEXT = "&COL1#"

Outcomes