topic Re: Modify data in the script in QlikView

Modify data in the script

Fri, 27 Apr 2012 19:03:26 GMT

Hi,

I have a file qvw your database a xml file. I need to modify some data in some fields, eg the field MANAGER presents the data as follows: 132; # Name Manager. I need to be displayed only the name follows: name manager (without previous code). Thank you all for your help.

Modify data in the script

Jason_Michaelides — Fri, 27 Apr 2012 20:17:16 GMT

Try:

LOAD

Field1,

Field2,

Field3,

SubField(MANAGER,'# ',2) AS MANAGER,

Field4,

etc

From.....;

Hope this helps,

Jason

Re: Modify data in the script

Mon, 07 May 2012 18:15:45 GMT

Hi,

I used some functions character and was as follows:

LOAD

Mid(ows_Field, NumSum(Index(ows_Field, '#', 1), 1)) as 'Field',

Thank's Jason for help.