Unwanted data remove

[Suraj_Kendre]

Hello,

I have CSV file data. In the data, I want to remove all [[ ]].

Please help with it.

[igoralcantara · Accepted solution]

In the load script, for each field you're loading, use one of these options:

Option 1: If all rows have the [[]]:

TextBetween(Mach, '[[', ']]') As Mach

Option 2:

Replace(Replace(Mach, '[[', ''), ']]', '') as Mach

Just adapt to your load script and to each field and you're good.

[BrunPierre]

Use PurgeChar() like

=PurgeChar(Mach, '[[]]')