i have a question about importing data: i have a column that i want to import [Status] in a csv file
this field consits in syntax Status\Substatus for example: "Active\Operational"
Now what i want to do is define in the ini file a command that can filter out these 2 states and put them in the right field in service desk who is "Status" and "Sub-Status": i tried to do this with CHARINDEX (to lookup the '\') but apparently this command isn't recognized by Data Exchange
the part of the data Exchange ini file:
ATT= \ [Status], \ [Sub-Status], \
COLUMNS= sub_string([Status], 0, CHARINDEX('\', [Status])) as [Status], \ sub_string([Status], CHARINDEX('\', [Status]), 20) as [Sub-Status], \