API tools faq
paste
Guest User

Remove Character in Worksheet

a guest
Mar 26th, 2020
516
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 18.95 KB | None | 0 0
raw download clone embed print report
  1. <process name="__selection__IPA1416_GetOpenPOsAndSendEmails">
  2. <subsheet subsheetid="05f76d9c-98cc-4bfd-ac22-3a6661fa02ad" type="Normal" published="False">
  3. <name>Remove Character in Worksheet</name>
  4. <view>
  5. <camerax>49</camerax>
  6. <cameray>75</cameray>
  7. <zoom version="2">1.25</zoom>
  8. </view>
  9. </subsheet>
  10. <stage stageid="23c3fde4-7567-45a8-b568-b0b049efe98a" name="Remove Character in Worksheet" type="SubSheetInfo">
  11. <subsheetid>05f76d9c-98cc-4bfd-ac22-3a6661fa02ad</subsheetid>
  12. <narrative>This page searches for a String, and removes it from the Worksheet.
  13. Used to remove Tabs and Enters from Excel files</narrative>
  14. <displayx>-195</displayx>
  15. <displayy>-150</displayy>
  16. <displaywidth>150</displaywidth>
  17. <displayheight>90</displayheight>
  18. <font family="Segoe UI" size="10" style="Regular" color="000000" />
  19. </stage>
  20. <stage stageid="17529e48-1e33-409c-8458-c9e404126cc1" name="Start" type="Start">
  21. <subsheetid>05f76d9c-98cc-4bfd-ac22-3a6661fa02ad</subsheetid>
  22. <loginhibit onsuccess="true" />
  23. <preconditions>
  24. <condition narrative="Excel file open" />
  25. </preconditions>
  26. <postconditions>
  27. <condition narrative="Excel file with characters removed" />
  28. </postconditions>
  29. <narrative></narrative>
  30. <displayx>-15</displayx>
  31. <displayy>-180</displayy>
  32. <displaywidth>60</displaywidth>
  33. <displayheight>30</displayheight>
  34. <font family="Segoe UI" size="10" style="Regular" color="000000" />
  35. <inputs>
  36. <input type="number" name="handle" narrative="Handle for excel object" stage="handle" />
  37. <input type="text" name="Character" narrative="Character to find and remove" stage="Character" />
  38. <input type="text" name="Range" narrative="Range to search the text" stage="Range" />
  39. </inputs>
  40. <onsuccess>f28aafaa-cc6e-4116-9088-8e9b995b8320</onsuccess>
  41. </stage>
  42. <stage stageid="5f3b621a-1013-44ca-8a1c-32f1b65b0402" name="End" type="End">
  43. <subsheetid>05f76d9c-98cc-4bfd-ac22-3a6661fa02ad</subsheetid>
  44. <loginhibit onsuccess="true" />
  45. <narrative></narrative>
  46. <displayx>-15</displayx>
  47. <displayy>300</displayy>
  48. <displaywidth>60</displaywidth>
  49. <displayheight>30</displayheight>
  50. <font family="Segoe UI" size="10" style="Regular" color="000000" />
  51. </stage>
  52. <stage stageid="a84fb114-a6c1-45e5-ac8d-6925c1a6c236" name="Find Chr" type="Action">
  53. <subsheetid>05f76d9c-98cc-4bfd-ac22-3a6661fa02ad</subsheetid>
  54. <loginhibit onsuccess="true" />
  55. <narrative></narrative>
  56. <displayx>-15</displayx>
  57. <displayy>-75</displayy>
  58. <displaywidth>60</displaywidth>
  59. <displayheight>30</displayheight>
  60. <font family="Segoe UI" size="10" style="Regular" color="000000" />
  61. <inputs>
  62. <input type="number" name="Handle" narrative="Handle of the Excel instance being used." expr="[handle]" />
  63. <input type="text" name="Range" narrative="Range in which the search will be performed (i.e. &quot;A1:X23&quot;)." expr="[Range]" />
  64. <input type="text" name="String To Search" narrative="String to search in the range." expr="[Character]" />
  65. </inputs>
  66. <outputs>
  67. <output type="collection" name="Found Cells" narrative="Collection containing the cells in which the string was found." stage="Found Cells" />
  68. </outputs>
  69. <onsuccess>bb4ece7a-22b2-470e-9861-69cb195f6513</onsuccess>
  70. <resource object="BR_MS Excel VBO" action="Find String In Range" />
  71. </stage>
  72. <stage stageid="150fad41-caed-44d3-b7fc-813e02f4c322" name="Replace" type="Calculation">
  73. <subsheetid>05f76d9c-98cc-4bfd-ac22-3a6661fa02ad</subsheetid>
  74. <loginhibit onsuccess="true" />
  75. <narrative></narrative>
  76. <displayx>-15</displayx>
  77. <displayy>120</displayy>
  78. <displaywidth>60</displaywidth>
  79. <displayheight>30</displayheight>
  80. <font family="Segoe UI" size="10" style="Regular" color="000000" />
  81. <onsuccess>81e165e9-a758-4f32-a54a-2755a026604d</onsuccess>
  82. <calculation expression="Replace([Cell Value],[Character], &quot;&quot;)" stage="Cell Value" />
  83. </stage>
  84. <stage stageid="a4293c0b-3888-4c2c-956f-8d57730050e8" name="Read" type="Action">
  85. <subsheetid>05f76d9c-98cc-4bfd-ac22-3a6661fa02ad</subsheetid>
  86. <loginhibit onsuccess="true" />
  87. <narrative></narrative>
  88. <displayx>-15</displayx>
  89. <displayy>60</displayy>
  90. <displaywidth>60</displaywidth>
  91. <displayheight>30</displayheight>
  92. <font family="Segoe UI" size="10" style="Regular" color="000000" />
  93. <inputs>
  94. <input type="number" name="handle" narrative="The integer handle identifying the instance from which the required cell value should be retrieved. The default of zero indicates the currently active instance." expr="[handle]" />
  95. <input type="text" name="Cell Reference" narrative="The cell reference indicating which cell's value should be retrieved. An empty value indicates that the currently active cell's value should be retrieved." expr="[Found Cells.Column1]" />
  96. </inputs>
  97. <outputs>
  98. <output type="text" name="Value" narrative="The (unformatted) value from the required cell." stage="Cell Value" />
  99. </outputs>
  100. <onsuccess>150fad41-caed-44d3-b7fc-813e02f4c322</onsuccess>
  101. <resource object="BR_MS Excel VBO" action="Get Cell Value" />
  102. </stage>
  103. <stage stageid="81e165e9-a758-4f32-a54a-2755a026604d" name="Write back" type="Action">
  104. <subsheetid>05f76d9c-98cc-4bfd-ac22-3a6661fa02ad</subsheetid>
  105. <loginhibit onsuccess="true" />
  106. <narrative></narrative>
  107. <displayx>-15</displayx>
  108. <displayy>180</displayy>
  109. <displaywidth>60</displaywidth>
  110. <displayheight>30</displayheight>
  111. <font family="Segoe UI" size="10" style="Regular" color="000000" />
  112. <inputs>
  113. <input type="number" name="handle" narrative="The integer handle identifying the instance on which the required cell value should be set. The default of zero indicates the currently active instance." expr="[handle]" />
  114. <input type="text" name="Cell Reference" narrative="The reference on the speficied sheet identifying the cell which should be set." expr="[Found Cells.Column1]" />
  115. <input type="text" name="Value" narrative="The value to which the specified cell should be set." expr="[Cell Value]" />
  116. </inputs>
  117. <onsuccess>996af317-a3ba-4e17-94df-335a90ccc1ce</onsuccess>
  118. <resource object="BR_MS Excel VBO" action="Set Cell Value" />
  119. </stage>
  120. <stage stageid="bb4ece7a-22b2-470e-9861-69cb195f6513" name="Loop Cells" type="LoopStart">
  121. <subsheetid>05f76d9c-98cc-4bfd-ac22-3a6661fa02ad</subsheetid>
  122. <loginhibit onsuccess="true" />
  123. <narrative></narrative>
  124. <displayx>-15</displayx>
  125. <displayy>0</displayy>
  126. <displaywidth>60</displaywidth>
  127. <displayheight>30</displayheight>
  128. <font family="Segoe UI" size="10" style="Regular" color="000000" />
  129. <onsuccess>a4293c0b-3888-4c2c-956f-8d57730050e8</onsuccess>
  130. <groupid>fb0c02f5-e0f5-43d5-b4ba-6a7e96807be3</groupid>
  131. <looptype>ForEach</looptype>
  132. <loopdata>Found Cells</loopdata>
  133. </stage>
  134. <stage stageid="996af317-a3ba-4e17-94df-335a90ccc1ce" name="Loop Cells" type="LoopEnd">
  135. <subsheetid>05f76d9c-98cc-4bfd-ac22-3a6661fa02ad</subsheetid>
  136. <loginhibit onsuccess="true" />
  137. <narrative></narrative>
  138. <displayx>-15</displayx>
  139. <displayy>240</displayy>
  140. <displaywidth>60</displaywidth>
  141. <displayheight>30</displayheight>
  142. <font family="Segoe UI" size="10" style="Regular" color="000000" />
  143. <onsuccess>5f3b621a-1013-44ca-8a1c-32f1b65b0402</onsuccess>
  144. <groupid>fb0c02f5-e0f5-43d5-b4ba-6a7e96807be3</groupid>
  145. </stage>
  146. <stage stageid="bf605fd5-61df-4a84-b887-76cca5a64490" name="Found Cells" type="Collection">
  147. <subsheetid>05f76d9c-98cc-4bfd-ac22-3a6661fa02ad</subsheetid>
  148. <narrative></narrative>
  149. <displayx>-195</displayx>
  150. <displayy>45</displayy>
  151. <displaywidth>120</displaywidth>
  152. <displayheight>30</displayheight>
  153. <font family="Segoe UI" size="10" style="Regular" color="000000" />
  154. <datatype>collection</datatype>
  155. <private />
  156. <alwaysinit />
  157. </stage>
  158. <stage stageid="06b98948-8314-4551-b926-9b0201b6d025" name="Cell Value" type="Data">
  159. <subsheetid>05f76d9c-98cc-4bfd-ac22-3a6661fa02ad</subsheetid>
  160. <narrative></narrative>
  161. <displayx>-195</displayx>
  162. <displayy>15</displayy>
  163. <displaywidth>120</displaywidth>
  164. <displayheight>30</displayheight>
  165. <font family="Segoe UI" size="10" style="Regular" color="000000" />
  166. <datatype>text</datatype>
  167. <initialvalue />
  168. <private />
  169. <alwaysinit />
  170. </stage>
  171. <stage stageid="099e4861-d618-48b6-b887-bf67ca0eccb6" name="handle" type="Data">
  172. <subsheetid>05f76d9c-98cc-4bfd-ac22-3a6661fa02ad</subsheetid>
  173. <narrative></narrative>
  174. <displayx>-195</displayx>
  175. <displayy>-15</displayy>
  176. <displaywidth>120</displaywidth>
  177. <displayheight>30</displayheight>
  178. <font family="Segoe UI" size="10" style="Regular" color="000000" />
  179. <datatype>number</datatype>
  180. <initialvalue />
  181. <private />
  182. <alwaysinit />
  183. </stage>
  184. <stage stageid="1f518770-7caf-4f55-bbd7-3292c6e1c552" name="Character" type="Data">
  185. <subsheetid>05f76d9c-98cc-4bfd-ac22-3a6661fa02ad</subsheetid>
  186. <narrative></narrative>
  187. <displayx>-195</displayx>
  188. <displayy>-45</displayy>
  189. <displaywidth>120</displaywidth>
  190. <displayheight>30</displayheight>
  191. <font family="Segoe UI" size="10" style="Regular" color="000000" />
  192. <datatype>text</datatype>
  193. <initialvalue />
  194. <private />
  195. <alwaysinit />
  196. </stage>
  197. <stage stageid="a39505c2-3e49-4da4-8574-923f88efa647" name="Retry Find" type="Data">
  198. <subsheetid>05f76d9c-98cc-4bfd-ac22-3a6661fa02ad</subsheetid>
  199. <narrative></narrative>
  200. <displayx>-195</displayx>
  201. <displayy>75</displayy>
  202. <displaywidth>120</displaywidth>
  203. <displayheight>30</displayheight>
  204. <font family="Segoe UI" size="10" style="Regular" color="000000" />
  205. <datatype>number</datatype>
  206. <initialvalue>0</initialvalue>
  207. <private />
  208. <alwaysinit />
  209. </stage>
  210. <stage stageid="274c3137-3ce3-46ed-a1d3-ec3513b6e8c7" name="Retry Replace" type="Data">
  211. <subsheetid>05f76d9c-98cc-4bfd-ac22-3a6661fa02ad</subsheetid>
  212. <narrative></narrative>
  213. <displayx>-195</displayx>
  214. <displayy>105</displayy>
  215. <displaywidth>120</displaywidth>
  216. <displayheight>30</displayheight>
  217. <font family="Segoe UI" size="10" style="Regular" color="000000" />
  218. <datatype>number</datatype>
  219. <initialvalue>0</initialvalue>
  220. <private />
  221. <alwaysinit />
  222. </stage>
  223. <stage stageid="2e60de94-8377-4363-9817-385e12f4c98b" name="Block" type="Block">
  224. <subsheetid>05f76d9c-98cc-4bfd-ac22-3a6661fa02ad</subsheetid>
  225. <narrative></narrative>
  226. <displayx>-60</displayx>
  227. <displayy>-105</displayy>
  228. <displaywidth>180</displaywidth>
  229. <displayheight>60</displayheight>
  230. <font family="Segoe UI" size="10" style="Regular" color="7FB2E5" />
  231. </stage>
  232. <stage stageid="d079a363-4766-404f-8f8b-999400028947" name="Recover" type="Recover">
  233. <subsheetid>05f76d9c-98cc-4bfd-ac22-3a6661fa02ad</subsheetid>
  234. <loginhibit onsuccess="true" />
  235. <narrative></narrative>
  236. <displayx>75</displayx>
  237. <displayy>-75</displayy>
  238. <displaywidth>60</displaywidth>
  239. <displayheight>30</displayheight>
  240. <font family="Segoe UI" size="10" style="Regular" color="000000" />
  241. <onsuccess>2ad0be41-bfbb-4f07-bcdb-e81560483862</onsuccess>
  242. </stage>
  243. <stage stageid="2ad0be41-bfbb-4f07-bcdb-e81560483862" name="Retry Find?" type="Decision">
  244. <subsheetid>05f76d9c-98cc-4bfd-ac22-3a6661fa02ad</subsheetid>
  245. <loginhibit onsuccess="true" />
  246. <narrative></narrative>
  247. <displayx>225</displayx>
  248. <displayy>-75</displayy>
  249. <displaywidth>60</displaywidth>
  250. <displayheight>30</displayheight>
  251. <font family="Segoe UI" size="10" style="Regular" color="000000" />
  252. <decision expression="[Retry Find] &lt; 10" />
  253. <ontrue>9170f8db-cd78-457e-8f21-3648439ec378</ontrue>
  254. <onfalse>41ddc086-45d3-499a-8f41-8e60e6a702f1</onfalse>
  255. </stage>
  256. <stage stageid="98665d7a-ebf9-4d74-89ea-5586c7499050" name="Retry Find ++" type="Calculation">
  257. <subsheetid>05f76d9c-98cc-4bfd-ac22-3a6661fa02ad</subsheetid>
  258. <loginhibit onsuccess="true" />
  259. <narrative></narrative>
  260. <displayx>45</displayx>
  261. <displayy>-135</displayy>
  262. <displaywidth>60</displaywidth>
  263. <displayheight>30</displayheight>
  264. <font family="Segoe UI" size="10" style="Regular" color="000000" />
  265. <onsuccess>f28aafaa-cc6e-4116-9088-8e9b995b8320</onsuccess>
  266. <calculation expression="[Retry Find] + 1" stage="Retry Find" />
  267. </stage>
  268. <stage stageid="9170f8db-cd78-457e-8f21-3648439ec378" name="Resume" type="Resume">
  269. <subsheetid>05f76d9c-98cc-4bfd-ac22-3a6661fa02ad</subsheetid>
  270. <loginhibit onsuccess="true" />
  271. <narrative></narrative>
  272. <displayx>225</displayx>
  273. <displayy>-135</displayy>
  274. <displaywidth>60</displaywidth>
  275. <displayheight>30</displayheight>
  276. <font family="Segoe UI" size="10" style="Regular" color="000000" />
  277. <onsuccess>9f061162-c2e5-4cc3-89ff-cf1d06e3df10</onsuccess>
  278. </stage>
  279. <stage stageid="41ddc086-45d3-499a-8f41-8e60e6a702f1" name="Re-Throw" type="Exception">
  280. <subsheetid>05f76d9c-98cc-4bfd-ac22-3a6661fa02ad</subsheetid>
  281. <narrative></narrative>
  282. <displayx>315</displayx>
  283. <displayy>-75</displayy>
  284. <displaywidth>60</displaywidth>
  285. <displayheight>30</displayheight>
  286. <font family="Segoe UI" size="10" style="Regular" color="000000" />
  287. <exception localized="yes" type="" detail="" usecurrent="yes" />
  288. </stage>
  289. <stage stageid="0727aa02-e86c-4ad7-b837-27240dd4059a" name="Block" type="Block">
  290. <subsheetid>05f76d9c-98cc-4bfd-ac22-3a6661fa02ad</subsheetid>
  291. <narrative></narrative>
  292. <displayx>-60</displayx>
  293. <displayy>-30</displayy>
  294. <displaywidth>180</displaywidth>
  295. <displayheight>300</displayheight>
  296. <font family="Segoe UI" size="10" style="Regular" color="7FB2E5" />
  297. </stage>
  298. <stage stageid="57c9ff70-18ea-42e5-ba48-f888761265bb" name="Recover" type="Recover">
  299. <subsheetid>05f76d9c-98cc-4bfd-ac22-3a6661fa02ad</subsheetid>
  300. <loginhibit onsuccess="true" />
  301. <narrative></narrative>
  302. <displayx>75</displayx>
  303. <displayy>240</displayy>
  304. <displaywidth>60</displaywidth>
  305. <displayheight>30</displayheight>
  306. <font family="Segoe UI" size="10" style="Regular" color="000000" />
  307. <onsuccess>648eca7a-6279-42d6-83fa-194ff7036457</onsuccess>
  308. </stage>
  309. <stage stageid="648eca7a-6279-42d6-83fa-194ff7036457" name="Retry Replace?" type="Decision">
  310. <subsheetid>05f76d9c-98cc-4bfd-ac22-3a6661fa02ad</subsheetid>
  311. <loginhibit onsuccess="true" />
  312. <narrative></narrative>
  313. <displayx>165</displayx>
  314. <displayy>240</displayy>
  315. <displaywidth>60</displaywidth>
  316. <displayheight>30</displayheight>
  317. <font family="Segoe UI" size="10" style="Regular" color="000000" />
  318. <decision expression="[Retry Replace] &lt; 25" />
  319. <ontrue>29415ef4-fef0-41d6-81b0-be4e703f5c5f</ontrue>
  320. <onfalse>664e4a64-7ece-4052-9444-281b769c44a0</onfalse>
  321. </stage>
  322. <stage stageid="e893d1e2-6468-44f0-a421-3b412fcf43f0" name="Retry Replace++" type="Calculation">
  323. <subsheetid>05f76d9c-98cc-4bfd-ac22-3a6661fa02ad</subsheetid>
  324. <loginhibit onsuccess="true" />
  325. <narrative></narrative>
  326. <displayx>165</displayx>
  327. <displayy>60</displayy>
  328. <displaywidth>60</displaywidth>
  329. <displayheight>30</displayheight>
  330. <font family="Segoe UI" size="10" style="Regular" color="000000" />
  331. <onsuccess>a4293c0b-3888-4c2c-956f-8d57730050e8</onsuccess>
  332. <calculation expression="[Retry Replace] + 1" stage="Retry Replace" />
  333. </stage>
  334. <stage stageid="29415ef4-fef0-41d6-81b0-be4e703f5c5f" name="Resume" type="Resume">
  335. <subsheetid>05f76d9c-98cc-4bfd-ac22-3a6661fa02ad</subsheetid>
  336. <loginhibit onsuccess="true" />
  337. <narrative></narrative>
  338. <displayx>165</displayx>
  339. <displayy>180</displayy>
  340. <displaywidth>60</displaywidth>
  341. <displayheight>30</displayheight>
  342. <font family="Segoe UI" size="10" style="Regular" color="000000" />
  343. <onsuccess>59cb3f5d-b9b6-462e-a534-e3894dbe2c95</onsuccess>
  344. </stage>
  345. <stage stageid="664e4a64-7ece-4052-9444-281b769c44a0" name="Re-Throw" type="Exception">
  346. <subsheetid>05f76d9c-98cc-4bfd-ac22-3a6661fa02ad</subsheetid>
  347. <narrative></narrative>
  348. <displayx>255</displayx>
  349. <displayy>240</displayy>
  350. <displaywidth>60</displaywidth>
  351. <displayheight>30</displayheight>
  352. <font family="Segoe UI" size="10" style="Regular" color="000000" />
  353. <exception localized="yes" type="" detail="" usecurrent="yes" />
  354. </stage>
  355. <stage stageid="59cb3f5d-b9b6-462e-a534-e3894dbe2c95" name="Sleep S" type="Action">
  356. <subsheetid>05f76d9c-98cc-4bfd-ac22-3a6661fa02ad</subsheetid>
  357. <loginhibit onsuccess="true" />
  358. <narrative></narrative>
  359. <displayx>165</displayx>
  360. <displayy>120</displayy>
  361. <displaywidth>60</displaywidth>
  362. <displayheight>30</displayheight>
  363. <font family="Segoe UI" size="10" style="Regular" color="000000" />
  364. <inputs>
  365. <input type="number" name="Sleep Time (Seconds)" narrative="The time (in seconds) for which to sleep" expr="[GLOBAL TIMEOUT - S]" />
  366. </inputs>
  367. <onsuccess>e893d1e2-6468-44f0-a421-3b412fcf43f0</onsuccess>
  368. <resource object="BR_Utility - General" action="Sleep" />
  369. </stage>
  370. <stage stageid="9f061162-c2e5-4cc3-89ff-cf1d06e3df10" name="Sleep S" type="Action">
  371. <subsheetid>05f76d9c-98cc-4bfd-ac22-3a6661fa02ad</subsheetid>
  372. <loginhibit onsuccess="true" />
  373. <narrative></narrative>
  374. <displayx>135</displayx>
  375. <displayy>-135</displayy>
  376. <displaywidth>60</displaywidth>
  377. <displayheight>30</displayheight>
  378. <font family="Segoe UI" size="10" style="Regular" color="000000" />
  379. <inputs>
  380. <input type="number" name="Sleep Time (Seconds)" narrative="The time (in seconds) for which to sleep" expr="[GLOBAL TIMEOUT - S]" />
  381. </inputs>
  382. <onsuccess>98665d7a-ebf9-4d74-89ea-5586c7499050</onsuccess>
  383. <resource object="BR_Utility - General" action="Sleep" />
  384. </stage>
  385. <stage stageid="b27c32a4-4c81-4c7a-8ef3-025aa5c8d3d8" name="Range" type="Data">
  386. <subsheetid>05f76d9c-98cc-4bfd-ac22-3a6661fa02ad</subsheetid>
  387. <narrative></narrative>
  388. <displayx>-195</displayx>
  389. <displayy>-75</displayy>
  390. <displaywidth>120</displaywidth>
  391. <displayheight>30</displayheight>
  392. <font family="Segoe UI" size="10" style="Regular" color="000000" />
  393. <datatype>text</datatype>
  394. <initialvalue xml:space="preserve">"A:Z"</initialvalue>
  395. <private />
  396. <alwaysinit />
  397. </stage>
  398. <stage stageid="f28aafaa-cc6e-4116-9088-8e9b995b8320" name="Anchor6" type="Anchor">
  399. <subsheetid>05f76d9c-98cc-4bfd-ac22-3a6661fa02ad</subsheetid>
  400. <narrative></narrative>
  401. <displayx>-15</displayx>
  402. <displayy>-135</displayy>
  403. <displaywidth>10</displaywidth>
  404. <displayheight>10</displayheight>
  405. <font family="Segoe UI" size="10" style="Regular" color="000000" />
  406. <onsuccess>a84fb114-a6c1-45e5-ac8d-6925c1a6c236</onsuccess>
  407. </stage>
  408. </process>
Advertisement
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!