0%

How to split text field into X fields in ArcMap?

How To: Split text field into X fields in ArcMap

Solution

步驟1:於TABLE表內新增所需欄位(Text格式),並於所需欄位利用FIELD CALCULATOR運算

Step 1:Add the field that type is Text, and use the tool “field calculator” to calculate.

How To: Split text field into X fields in ArcMap

步驟2:如下圖,「ID」為基礎資料,若要取前面兩個字母,Parser 選擇「Python」, 下列方框內填入 !ID![:2]

Step 2:If the ID field values are basic data, that using Calculate Fields tool with python slices. Need that first two words, key in “!ID![:2]”.

How To: Split text field into X fields in ArcMap

How To: Split text field into X fields in ArcMap

步驟3:如下圖,「ID」為基礎資料,若要取第三個字母,Parser 選擇「Python」,在下列方框內填入 !ID![2:3]

Step 3:Need that third word, key in “!ID![2:3]”.

How To: Split text field into X fields in ArcMap

How To: Split text field into X fields in ArcMap

步驟4:如下圖,「ID」為基礎資料,若要取後四個字母,Parser 選擇「Python」,在下列方框內填入!ID![2:]

Step 4:Need that last four words, key in “!ID![2:]”.

How To: Split text field into X fields in ArcMap

How To: Split text field into X fields in ArcMap

References

Split one field into 3 fields?