Replace data in a table loaded in qvw

[#1]

Hi,

I am trying to load an Excel file into qlikview table through edit script.

Example:

  [Test]:

Load  * From 

(biff,embedded lables,table is sheet1$);

Actually, there are 50 Columns in the "Test.xlsx". I want to find the character "#" in each of the columns and need to replace with 'null'

I can write the same edit script as

[Test]:

Load

Replace(Field1,'#','') as Field1,

Replace(Field2,"#,'') as Field2,

..

..

..

Replace(Field50,'#','') as Field50

From

(biff,embedded labels,table is sheet1$);

But the problem is, my field names are not fixed and they vary for file to file and thats why i intend to use Load *.

Is there a way to achieve what i am trying to do without mentioning the fieldnames. Thanks in advance.

[Gysbert_Wassenaar]

See here. If you replace the trim function with your replace and change the table name it should work afaict.

[#3]

Thanks for your help Gysbert. I am able to get the logic and implement it as required.