質問編集履歴
4
Java とjavascripを明確に分けた
test
CHANGED
|
@@ -1 +1 @@
|
|
|
1
|
-
GAS
|
|
1
|
+
GAS 問い合わせ件数、行数が異なるメールをスプレットシートへ転記したい。
|
test
CHANGED
|
File without changes
|
3
Java とjavascripを明確に分けた
test
CHANGED
|
File without changes
|
test
CHANGED
|
@@ -146,35 +146,7 @@
|
|
|
146
146
|
|
|
147
147
|
|
|
148
148
|
|
|
149
|
-
let
|
|
149
|
+
let name = plainBody.match(/商 品 名：(.*)/);
|
|
150
|
-
|
|
151
|
-
|
|
152
|
-
|
|
153
|
-
let buildType = plainBody.match(/B：(.*)/);
|
|
154
|
-
|
|
155
|
-
|
|
156
|
-
|
|
157
|
-
let buildLocation = plainBody.match(/C：(.*)/);
|
|
158
|
-
|
|
159
|
-
|
|
160
|
-
|
|
161
|
-
let buildNearestStation = plainBody.match(/D：(.*)/);
|
|
162
|
-
|
|
163
|
-
|
|
164
|
-
|
|
165
|
-
let buildDistance = plainBody.match(/E：(.*)/);
|
|
166
|
-
|
|
167
|
-
|
|
168
|
-
|
|
169
|
-
let buildRentFee = plainBody.match(/F：(.*)/);
|
|
170
|
-
|
|
171
|
-
|
|
172
|
-
|
|
173
|
-
let buildFloorPlan = plainBody.match(/G：(.*)/);
|
|
174
|
-
|
|
175
|
-
|
|
176
|
-
|
|
177
|
-
let buildOccupiedArea = plainBody.match(/H：(.*)/);
|
|
178
150
|
|
|
179
151
|
|
|
180
152
|
|
|
@@ -194,21 +166,7 @@
|
|
|
194
166
|
|
|
195
167
|
sheet.getRange(lastRow, 4).setValue(tel[1]);
|
|
196
168
|
|
|
197
|
-
sheet.getRange(lastRow, 5).setValue(
|
|
169
|
+
sheet.getRange(lastRow, 5).setValue(name[1]);
|
|
198
|
-
|
|
199
|
-
sheet.getRange(lastRow, 6).setValue(buildType[1]);
|
|
200
|
-
|
|
201
|
-
sheet.getRange(lastRow, 7).setValue(buildLocation[1]);
|
|
202
|
-
|
|
203
|
-
sheet.getRange(lastRow, 8).setValue(buildNearestStation[1]);
|
|
204
|
-
|
|
205
|
-
sheet.getRange(lastRow, 9).setValue(buildDistance[1]);
|
|
206
|
-
|
|
207
|
-
sheet.getRange(lastRow, 10).setValue(buildRentFee[1]);
|
|
208
|
-
|
|
209
|
-
sheet.getRange(lastRow, 11).setValue(buildFloorPlan[1]);
|
|
210
|
-
|
|
211
|
-
sheet.getRange(lastRow, 12).setValue(buildOccupiedArea[1]);
|
|
212
170
|
|
|
213
171
|
});
|
|
214
172
|
|
2
test
CHANGED
|
File without changes
|
test
CHANGED
|
File without changes
|
1
test
CHANGED
|
@@ -1 +1 @@
|
|
|
1
|
-
GAS/Java 問い合わせ件数、行数が異なるメールをスプレットシートへ転記したい。
|
|
1
|
+
GAS/JavaScript 問い合わせ件数、行数が異なるメールをスプレットシートへ転記したい。
|
test
CHANGED
|
File without changes
|