Hi all,
I am facing the following issue with BP 6.4.0.
---------
---------
Now the issue comes that when using BP 5.0.12 it works perfectly and I get all the columns as "Text" (originally were "Number").
However with BP 6.4.0, I still get some columns as "Number". (couple of screenshots attached of BP 5 correct cast)
Any idea why and how to overcome this issue?
Thanks a lot for your help!
Cheers,
Ismael.
I am facing the following issue with BP 6.4.0.
- When getting CSV file to collection I get some columns formatted as "Number".
- I made the following simple custom code, to translate all the columns to String (Text).
---------
Code:
OutCol = inCol.Clone()
'convert all the columns type to String
For Each col As DataColumn In OutCol.Columns
col.DataType = GetType(String)
Next
OutCol.Load(inCol.CreateDataReader)
---------
Now the issue comes that when using BP 5.0.12 it works perfectly and I get all the columns as "Text" (originally were "Number").
However with BP 6.4.0, I still get some columns as "Number". (couple of screenshots attached of BP 5 correct cast)
Any idea why and how to overcome this issue?
Thanks a lot for your help!
Cheers,
Ismael.