¿How create a field with modifications?

[#1]

Hi there,

I have a column (USERNAME) in Excel file that contains a information. I need to extract some information:

Name

FME_78701234

FME_71311233

FME_11281242

FME_71241244

FME_11241241

FME_92124124

FME_71241241

FME_71241242

FME_11231233

FME_71231233

FME_71231231

I need create the next field

Name 2
78701234
71311233
11281242
71241244
11241241
92124124
71241241
71241242
11231233
71231233
71231231

I can should be filter by Name 2.

I need solve this issue in QlikSense without any change in Excel File.

Thanks

[Peter_Cammaert]

You're asking this in a QlikView forum. Maybe you can move this thread to the proper area? Otherwise you may get irrelevant (or no) answers...

Best,

Peter

[Anonymous · Accepted solution]

Hi Juan,

One way to achieve this is by using 'mid' function in the load script. This way you can split the value and capture it in another column. Pls check the attached screen that has the load script syntax and the 2 list boxes showing the value.

[swuehl]

You can also use Subfield() with a delimiter '_' in your LOAD script:

LOAD

     USERNAME,

     Subfield(USERNAME,'_',2) as NAME2,

     ...

[Gysbert_Wassenaar]

Or one of these:

• Replace(USERNAME,'FME_','') as NAME2
• keepchar(USERNAME, '0123456789') as NAME2
• mid(USERNAME, Index(USERNAME, '_')+1) as NAME2