Cimload of data fields containing blank

Sonja

New Member
When I try to do a Cimload for a field which contains a blank I get the error message "input too long" because system assumes that after the blank a new input field begins. I think my put statement is wrong. It's like following:
put
'"' field1'" '
'"' field2'" ' ......

If field1 contains a value of e.g. "bad test" value "bad" is in first field and value "test" is in second field although I want to have the whole value "bad test" in first field. Can anybody help me with this program coding ?
 

sphipp

Member
It's always worth checking the CIM File first using a text editor or even more.

What you want to see in the CIM File is "Bad Test" ...

If you are using Put then you could do something like:

Code:
put unformatted """Bad Test""" skip.

put unformatted """" "Bad Test" """" skip.

put unformatted
  """"
  "Bad"
  " "
  "Test"
  """"
  skip.
 
put unformatted
  """"
  field1
  """"
  " "
  """"
  field2
  """"
  skip.
 
def var dblquot as char initial """" no-undo.

put unformatted
  dblquot field1 dblquot " " dblquot field2 dblquot skip.
 
function f_quote returns char (inp_word as char):
  return """" + inp_word + """".
end function.

put unformatted f_quote (field1) " " f_quote(field2) skip.

You could use EXPORT instead, but PUT is probably easier for all CIM Loads.
 
Top