1. Andres Slachevsky
  2. PowerBuilder
  3. Thursday, 21 March 2019

Hello All,

I have a DW with column names like :
Column1, FirstName,LastName

when i create the json file using exportJson

the Json is generated with names in lowercase 

column1,firstname,lastname

and that cause a problem when i try to import it in the targer application (non PB)

if i edit the names to keep the UpperCase then it import works.

any way i can solve it or i must use the JsonParser object?

Kevin Ridley Accepted Answer Pending Moderation
0
Votes
Undo

Not ideal but if it's only 1 dw and you know the column names, you can just write a find/replace utility to replace the lowercase for each column, since JSON is really just a string.

Comment
FYI the pfc has a great string replace function. Check out pfc_n_cst_string.of_globalreplacenew it should have everything you need. You can put "old" and "new" values into arrays and loop through calling the replace function. Also looks like you can just copy the function right from the pfc without all the usual pfc "hooks".
  1. Kevin Ridley
  2. Thursday, 21 March 2019
There are no comments made yet.
  1. Thursday, 21 March 2019
  2. PowerBuilder
  3. # 1
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.