Hi,
I am try to make fields nulls or blank which contain 3 letters (currency code). Is there any way to do this, please see screenshot of sample data attached.
Current Input
BankDebt-GT110 VALE - GS1VALE (272930) | |
EUR | Opening Balance (Settle Date) |
GBP | Opening Balance (Settle Date) |
Desired Output
BankDebt-GT110 VALE - GS1VALE (272930) | |
Opening Balance (Settle Date) | |
Opening Balance (Settle Date) |
Thanks,
Laura
@furlonla here's one way:
Making use of the Length function. If Length of string = 3, then replace with null, else, keep existing value:
You can edit the length logic to whatever you like i.e. if length <= 3 then null etc.
Thanks,
BS