Not enough... I have tried the following in conditional split transformation editor and failed
REPLACE([QuantityUnits],"(","-")
REPLACE(QuantityUnits,')','')
I have tried the following in Derived Column Transformation editor and failed
REPLACE(REPLACE([QuantityUnits],”(“,”-”),”)“,””)
SUBSTRING([QuantityUnits],1,1) == "(" ? REPLACE(REPLACE([QuantityUnits],"(","-"),")","") : [QuantityUnits]
I have tried changing the data type in the flat file connection manager to string data type and that doesnt help
The csv file's problem columns have negative values that are represented like (2.5) and values with over 3 digits represented like " 1,074 ". The quotes are handled by my specification of the text qualifier but I am stuck on converting the negative values.