SQL Server Stuff function in qlik sense

[baarathi]

I have a SQL query : SELECT STUFF('SQL Tutorial', 4, 0, 'HTML');

How to implement the same using Qlik Sense in load script ?

I have tried implementing it with replace function in qlik sense but we need pass character as argument, whereas i need to pass index as argument.

Is there any other solution to implement above query in qlik sense?

[undergrinder]

Hi Bharathi,

try this:

=mid([field],0,[indexToInsert]) & field_to_insert] & mid([field],[indexToInsert]))

In example:

SELECT STUFF('SQL Tutorial', 4, 0, 'HTML');

[field] = 'SQL Tutorial

[indexToInsert] = 4

[field_to_insert] = 'HTML'

G.