Question: Question 1 : Calculated Field that Splits data You work for the San Francisco energy audit and need to plan visits to the sites of

Question 1: Calculated Field that Splits data
You work for the San Francisco energy audit and need to plan visits to the sites of the buildings that have upcoming energy audits. To plan your visits, you want to know how many are in each block of the city. Connect to the B.2 San Francisco Excel data and create a calculated field to create a new field from the parcel field so that you can get the block number which is the first set of digits in front of the slash.
Which of the following syntax would correctly create a field for just the block part of Parcel?
A: BREAK([Parcel(s)],"/")
B: SPLIT([Parcel(s)],"/",1)
C: DATEPARSE([Parcel(s)],1)
D: SPLIT([Parcel(s)],"-",1)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!