Trim on Load

[Anonymous]

I would like to TRIM the values of a field to deliver a specific value(AP-EU-AM), but there is no common starting place to do a MID - LEFT or Right.

Here is the data:

WW_FIN_DLD1_CONS_BW_GL_TXN_DATA_AP_

WW_FIN_DLD1_CONS_BW_GL_TXN_DATA_EU_

WW_FIN_CAL1_CONS_BW_VC_TO_DM_OPENPER_AM_

What would be the way to do this on the Load?

Thanks!

Dan

[swuehl · Accepted solution]

Maybe

LOAD

     Subfield( YourField, '_', -2) as YourFieldTrimmed,

     ...

[sunny_talwar]

What is the expected output here?

[Anonymous]

Sunny ,

The desired output is AP, EU, AM

[sunny_talwar]

Then swuehl‌ should be able to get you to that output

[Anonymous]

Swuehl,

Field contains no data-

Subfield(Jobstream,'-',-2)as Region,

[swuehl]

Looks like you used a minus sign '-' as delimiter, not an underscore '_'?

[sunny_talwar]

Not the dash ( - ), you need to use underscore ( _ )

Subfield(Jobstream,'_',-2)as Region,

[Anonymous]

swuehl,

My bad on the '-', fixed it '_' and it worked just fine!

Thanks for the quick response!!

Regrds,

Dan

[sunny_talwar]

If you got what you needed, please mark Stefan's answer as correct to close the thread.