How to place alphanumeric in between an integer

Prince_Hyd · Post by **Prince_Hyd** » Wed Jun 12, 2013 9:23 am

Hi Folks

i have an input like this

Num

74584578845
73432848874
40594589485

i want to place '-' after third position.So output should be like

Num

745-84578845
734-32848874
405-94589485

Thanks

chulett · Post by **chulett** » Wed Jun 12, 2013 9:24 am

Substring the value apart (or use Left/Right) and concatenate back together adding that character between the two pieces.

Prince_Hyd · Post by **Prince_Hyd** » Wed Jun 12, 2013 11:26 am

Hi

can you explain in detail please.

Thanks

chulett · Post by **chulett** » Wed Jun 12, 2013 11:36 am

What detail do you need? It's not substantially different from your other recent post with the capitals. And your target will no longer be an integer of course, so first convert the source to a string and then proceed with the chopping upping.