Problem with load data to import set from csv file

[michal_masztal1]

Hi everyone.

I have some problem. When I import data to import set from csv file content of columns which names contain '/' are empty.

In other columns data import correctly. Do you know why and how can I do this ?

Thanks for response.

[ghsrikanth]

Is the "/" is in the header column or in the data?

[michal_masztal1]

It's in the header. For example in csv file is "Name" header and the data load correctly. But if header name's "State / Province" the data in column are empty.

[ghsrikanth]

In servicenow, CSV import follows RFC4180, on seeing that link - / is seemed to be considered as escaped character, so State/Province is changing to u_state_province - system considering that there is space.

In case of your issue, can't you replace all / in header with spaces and manually create columns with the same name in the import set table.

Once you upload into import set table, you can use the transform map into the target table.

The target table can have label as State/Province.

It feels like a workaround instead of getting stuck.

Hope it is helpful

[Nick65]

Not sure if you can, but looks like it is not parsing the column names with the spaces State / Province like that, if you can try it without the spaces before and after the slashes, State/Province