This discussion is archived
1 Reply Latest reply: Dec 18, 2012 4:57 AM by FrançoisDegrelle RSS

Merge and Split Concatinate

Moazam Shareef Explorer
Currently Being Moderated
Guyz,

I'm putting two fields into one.
:MN_MENU_SEC.MENU_ID := :MENUS.H_MENUID||'-'||:MENUS.V_MENUID;
how can i split one into two?
:MN_MENU_SEC.MENU_ID (total 8 characters)
:MENUS.H_MENUID (From 1st to Four here)
:MENUS.V_MENUID;(from four to last here)
Regards
Moazam

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points