drop first three digits

[#1]

Is it possible to drop the first three digits in a name?

I need to drop the SQL in the data.

Field     LastModBy

Data      sqlrsmith

Data      sqljdoe

Data      sqlbjones

[dmitry909]

You can try:

replace(LastModBy,'sql','')

or

right(LastModBy,len(LastModBy)-3)

[sunny_talwar]

Sure, try this may be:

Right(LastModBy, Len(LastModBy) - 3)

[#4]

[dmitry909]

Try do this in Qlik part of Script (above SQL Select), not in SQL code.

[#6]

still get error like above

[dmitry909 · Accepted solution]

Example of correct code here:

Table1:

Field1,

Field2,

........,

right(LastModBy,len(LastModBy)-3) as LastModBy;

SQL Select

Field1,

Field2,

........,

LastModBy

From SourceTable;

[#8]

Now my join does not work

[dmitry909]

Use alias, your field in "Rxs" table must be named as "LastModBy", like in another table.

Try this:

right(LastModBy,len(LastModBy)-3) as LastModBy

[robvanwun]

I think u missed the rename "as LastModifiedBy" in table RXS