Seperating out Field

[#1]

Is there a way to separate fields that have been accidently combined in a source document?

Example: Banana-East or 15487-North

I need them to read

Field1	Field2
Banana	East
15487	North

[ciaran_mcgowan]

The RIGHT function here won't return the correct values. You need to use LEN(Field)-FINDONEOF(.....

[sunny_talwar]

This is good, but somehow feel that Mapping Load might be slightly easier to maintain in the long run as we can maintain this in an Excel file rather then listing them out here and missing something by chance

[sunny_talwar]

qlik_kev‌-

Did you get what you were looking for? If you did, please close this thread by marking the correct response.

Qlik Community Tip: Marking Replies as Correct or Helpful

Thanks and regards,

Sunny

[#5]

Thanks Sunny T but this isn't something I'd like to maintain in an external excel file so I'm going to go with the FindOneOf approach.

[sunny_talwar]

External Excel file was just an option. But feel free to go with the FindOneOf approach . Please mark ciaran.mcgowan response as correct answer as close this thread.

Best,

Sunny