topic Remove First and Last Character in Loadscript OR Remove Two Characters from Loadscript in QlikView

Remove First and Last Character in Loadscript OR Remove Two Characters from Loadscript

Thu, 29 Jan 2015 12:49:16 GMT

Hello!

Here's the problem, my data is coming in wrapped in square brackets, e.g. [www.google.com]

Can I remove the square brackets, either by:

1. Removing the first and last character of a line in the loadscript?

2. Removing all '[' and ']' from my data?

Thanks!

Alex

Re: Remove First and Last Character in Loadscript OR Remove Two Characters from Loadscript

crusader_ — Thu, 29 Jan 2015 12:54:28 GMT

Hi,

Use below expression:

LOAD

PurgeChar(Field,'[]') as New_Field

FROM datasource;

Hope this helps you.

Regards,

Andrei Kaliahin

Re: Remove First and Last Character in Loadscript OR Remove Two Characters from Loadscript

cesaraccardi — Thu, 29 Jan 2015 13:01:28 GMT

Hi Alex,

There are multiple ways to achieve that, see examples below.

1. Removing the first and last character of a line in the loadscript?

A. This will ignore the first and last character:

LOAD

mid(Field,2,len(Field)-1) as Field

(...);

B. This will look for the brackets to get what's in between then:

LOAD

textbetween(Field,'[',']') as Field

(...);

2. Removing all '[' and ']' from my data?

C. This will remove any occurence of brackets in any position:

LOAD

PurgeChar(Field,'[]') as Field

(...);

Hope this helps you.

Cesar

Re: Remove First and Last Character in Loadscript OR Remove Two Characters from Loadscript

Thu, 29 Jan 2015 13:05:24 GMT

Thank you!

Re: Remove First and Last Character in Loadscript OR Remove Two Characters from Loadscript

Thu, 29 Jan 2015 13:05:32 GMT

Thank you!

Re: Remove First and Last Character in Loadscript OR Remove Two Characters from Loadscript

maxgro — Thu, 29 Jan 2015 13:06:00 GMT

remove first and last from field

load

field,

mid(field, 2, len(field)-2)

......