Number Load Format

[NemoAndStitch22]

Hiya, 

Might be a really simple answer but I can't find anything when I google..

I have a text file that I'm loading in and for some reason the numbers are formatted in brackets for negatives which are then being ignored as they aren't numbers in qlik...

Does anyone know the formula/how to change them to negatives when loading in? 

I've tried Num/Num#/replace but I can't get anything to work.

Thanks!!!

[PrashantSangle]

Check evaluate ()

https://help.qlik.com/en-US/qlikview/May2024/Subsystems/Client/Content/QV_QlikView/Scripting/StringF...

[NemoAndStitch22]

That's just removing the brackets and making everything positive.. Not keeping them as negatives?

[marcus_sommer]

You may try: alt(Field, purgechar(Field, '()') * -1)

[NemoAndStitch22 · Accepted solution]

That just made everything negative.. I've got a mix of positives, think I've found an answer:

num#(Replace(Replace([field], '(', '-'), ')', '')) as [field],