I
I
Igor Frol2022-04-11 12:34:33
Parsing
Igor Frol, 2022-04-11 12:34:33

How to make price rounding when parsing prices via importxml?

Parse prices in Google spreadsheets. But when parsing the price, for example, the price is parsed into two cells. Rubles in one cell, and kopecks in another. Is it possible to do processing in the xpath query itself so that only up to a certain character in the text is parsed information or in Google tables in the formula to set some parameter?
6253f61f5ea5a967125502.jpeg

Answer the question

In order to leave comments, you need to log in

1 answer(s)
I
Igor Frol, 2022-04-11
@Fuzzotron

it would be more elegant to implement it in one formula, and not to produce in neighboring processing cells.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question