AnsweredAssumed Answered

Split text at a spacific spacial character

Question asked by kapil8308 on Apr 13, 2015
Latest reply on Apr 13, 2015 by Dan_Patterson

Hi All,

 

I have facing same problem in arcgis. I have a table feature &  2 Lakhs records in this table. I want to split  row like excel function Text to Column.

for example: I want to split character in Underscore

Input

 

Name
ASSET_Name14
CIVLI STRUCTURE _Name 410
FACILITY _Name 0
FLOOR_Name 25
ROOM _Name 1000
WING _Name 21
WORKSTATION_Name 11
BUILDING_Name 10000

 

Output Name in arcgis
ASSETName14
CIVLI STRUCTUREName 410
FACILITYName 0
FLOORName 25
ROOMName 1000
WINGName 21
WORKSTATIONName 11
BUILDINGName 10000

  

So please tell me which tool are working at this situation.

 

Thanks & regards

Kapil

Outcomes