Set property dynamically

Question

Question

Ahmad Bukhtiar · Nov 22, 2020

If I have table of 60 fields is there a way to add values to columns dynamically ?

Fields are like this Field1, Field2, Field3...Field60 and I am reading data from flat files. I tried below code but it didn’t work

For i=2:1:$LENGTH(line) {

set SourceTable.Field_i = $PIECE(line, "|", i)

Discussion (3)0

Log in or sign up to continue

Dmitry Maslennikov · Dec 22, 2020

use $translate

USER>write $translate("some 'data'", "'")
some data

0 0

score 1 · Answer 1 · 2020-11-22T02:15:08-05:00

set $property(SourceTable, "Field"_i) = $PIECE(line, "|", i)

https://docs.intersystems.com/irislatest/csp/docbook/DocBook.UI.Page.cls...

score 0 · Answer 2 · 2020-12-22T07:19:57-05:00

Hi @Dmitry Maslennikov
This suggestion worked thanks, one I am looping over 60 columns and all is working fine. One thing is breaking sometimes data is single codes ' in the text and such records are not being saved. Any suggestion how to handle this?

For i=1:1:60 {
set FieldName = FieldName_",Field"_i
set FieldVaue = FieldVaue_"','"_$Piece(pInput,"|",i)}