Solved: Unwanted data remove - Qlik Community - 2453582

Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.

Skip to main content

Qlik.com | Qlik Services| Qlik Help |

Ask a Question

Hello,

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

Please help with it.

1 Solution

Accepted Solutions

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.

Check out my latest posts at datavoyagers.net

View solution in original post

2 Replies

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.

Check out my latest posts at datavoyagers.net

Use PurgeChar() like

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