Сергей c0re

awk -F: '
/\{|\}|border|max-width|^$/ { print $0 }
!/\{|\}|border|max-width|^$/ {
  split( substr($2, 1, length($2)-1) , a," ");
  res = "";
  for (i in a) {
    ind = match(a[i], /[0-9]+px/)
    if (ind != 0) {
      a[i] = sprintf ("%.2frem", a[i]/10);
    }
    res=a[i] " " res;
  }
  res = substr(res, 1, length(res)-1);
  print $1 ": " res ";"
}
' some.css

Arrays in awk are different—they are associative. This means that each array is a collection of pairs—an index and its corresponding array element value...
The pairs are shown in jumbled order because their order is irrelevant.

awk -F: '{
if ($0 ~ /\{|\}|border|max-width|^$/ ) { print $0 }
else {
  res = "";
  split( substr($2, 1, length($2)-1) , a, " ");
  for (i=1; i<= length(a);i++) res = res " " ((match(a[i], /[0-9]+px/) != 0)? a[i]/10"rem" : a[i]);
  print $1 ": " res";"
}
}' some.css

SELECT json_build_object(
    'account_id', id,
    'first_name', first_name,
    'last_name', last_name
  ) AS author
  FROM accounts

json_build_object(
    'post_id', p.id,
    'body', p.body,
    'author', json_build_object(
      'account_id', a.id,
      'first_name', a.first_name,
      'last_name', a.last_name
    )
  )

SELECT json_agg(json_build_object(
    'post_id', p.id,
    'body', p.body,
    'author', json_build_object(
      'account_id', a.id,
      'first_name', a.first_name,
      'last_name', a.last_name
    )
  )) AS posts
  FROM posts p
  JOIN accounts a ON a.id = p.author_id

SELECT json_agg(json_build_object(
    'comment_id', c.id,
    'body', c.body,
    'author', json_build_object(
      'account_id', a.id,
      'first_name', a.first_name,
      'last_name', a.last_name
    )
  )) AS comments
  FROM comments c
  JOIN accounts a ON a.id = c.author_id
  GROUP BY post_id

WITH cmts AS (
SELECT json_agg(json_build_object(
    'comment_id', c.id,
    'body', c.body,
    'author', json_build_object(
      'account_id', a.id,
      'first_name', a.first_name,
      'last_name', a.last_name
    )
  )) AS comments,
  post_id
  FROM comments c
  JOIN accounts a ON a.id = c.author_id
  GROUP BY post_id
)
SELECT json_agg(json_build_object(
    'post_id', p.id,
    'body', p.body,
    'author', json_build_object(
      'account_id', a.id,
      'first_name', a.first_name,
      'last_name', a.last_name
    ),
    'comments', COALESCE(c.comments, '[]')
  )) AS "posts with comments"
  FROM posts p
  JOIN accounts a ON a.id = p.author_id
  LEFT JOIN cmts c ON c.post_id = p.id

sed -r '
s/(className="[^"]+)([A-Z])([^"]+)([A-Z])([^"]+)([A-Z])([^"]+")/\1-\L\2\3-\L\4\5-\L\6\7/g;
s/(className="[^"]+)([A-Z])([^"]+)([A-Z])([^"]+")/\1-\L\2\3-\L\4\5/g;
s/(className="[^"]+)([A-Z])([^"]+")/\1-\L\2\3/g
' input_file > output_file

sed -i -r '
s/(className="[^"]+)([A-Z])([^"]+)([A-Z])([^"]+)([A-Z])([^"]+")/\1-\L\2\3-\L\4\5-\L\6\7/g;
s/(className="[^"]+)([A-Z])([^"]+)([A-Z])([^"]+")/\1-\L\2\3-\L\4\5/g;
s/(className="[^"]+)([A-Z])([^"]+")/\1-\L\2\3/g
' *.jsx

create table ru_word (word varchar(100), freq INT);

: переходим в папку с БД, там же должен быть файлru_50k.txt
cd C:\tmp

: открываем БД в sqlite3
c:\bin\sqlite3.exe my_example_db.sqlt
SQLite version 3.41.0 2023-02-21 18:09:37
Enter ".help" for usage hints.
sqlite> create table ru_word (word varchar(100), freq INT);
sqlite> .tables
ru_word
sqlite> .separator " "
sqlite> .import ru_50k.txt ru_word
sqlite> SELECT count(*) FROM ru_word;
50000
sqlite> SELECT MAX(freq) FROM ru_word;
3854593
sqlite> SELECT * FROM ru_word LIMIT 10;
я 3854593
не 3244771
что 2665565
в 2212420
и 2179689
ты 2067418
это 1999607
на 1240437
с 1128276
он 966203
sqlite> .quit

curl -s https://www.cbr.ru/scripts/XML_daily.asp | awk -F '</Valute>'  '{for (i=1; i<=NF; i++) if($i ~ /USD|EUR/) print substr($i, index($i, "CharCode")+9,3)" "substr($i, index($i, "Value")+6,7)}' 2>/dev/null

wget -qO- https://www.cbr.ru/scripts/XML_daily.asp | awk -F '</Valute>'  '{for (i=1; i<=NF; i++) if($i ~ /USD|EUR/) print substr($i, index($i, "CharCode")+9,3)" "substr($i, index($i, "Value")+6,7)}' 2>/dev/null

perl -MLWP::Simple -e '$_=get("https://www.cbr.ru/scripts/XML_daily.asp");while(m/(USD|EUR).+?Value>([^<]+)/g){print "$1 $2\n"}'

python3 -c 'import requests,re;print("\n".join([" ".join(i.groups()) for i in list(re.finditer(r"(USD|EUR).+?Value>([^<]+)", requests.get("https://www.cbr.ru/scripts/XML_daily.asp").text))]))'

# вариант 1 (RegEx)
(Invoke-WebRequest -UseBasicParsing -URI 'https://www.cbr.ru/scripts/XML_daily.asp').Content | Select-String '(USD|EUR).+?Value>([^<]+)' -AllMatches | foreach {$_.Matches.Groups[1,2,4,5].Value}
# вариант 2 (XML/XPath)
([xml](Invoke-WebRequest -UseBasicParsing -URI 'https://www.cbr.ru/scripts/XML_daily.asp').Content).SelectNodes('//Valute[CharCode="USD" or CharCode="EUR"]') | ft Name,Value

node -e "https.get('https://www.cbr.ru/scripts/XML_daily.asp',r=>{s='';r.on('data',d=>s+=d);r.on('end',()=>[...s.matchAll(/(USD|EUR).+?Value>([^<]+)/g)].forEach(e=>console.log(`${e[1]} ${e[2]}`)))})"

INSERT INTO product_attr (attr_7, attr_29)
WITH RECURSIVE
  param AS
(
  SELECT
    461  AS attr_7_start,  -- начальное значение для attr_7
    10   AS attr_7_num,    -- количество итераций в attr_7
    1097 AS attr_29_start, -- начальное значение для attr_29
    3    AS attr_29_num    -- количество итераций в attr_29
),
  attr29_iter (n) AS
(
  SELECT 0
  UNION ALL
  SELECT n + 1 FROM attr29_iter, param WHERE n < attr_29_num -1
),
 attr_7_iter (n) AS
(
  SELECT 0
  UNION ALL
  SELECT n + 1 FROM attr_7_iter, param WHERE n < attr_7_num -1
),
  gen_inc AS
(
  SELECT i7.n as inc7, i29.n as inc29
    FROM attr_7_iter i7, attr29_iter i29
)
SELECT attr_7_start + inc7, attr_29_start + inc29
  FROM gen_inc, param
  ORDER BY 1,2
;

INSERT INTO product_attr (product_id, product_price, product_old_price, attr_7, attr_29)
WITH RECURSIVE
  param AS
(
  SELECT
    461  AS attr_7_start,  -- начальное значение для attr_7
    14   AS attr_7_num,    -- количество итераций в attr_7
    1097 AS attr_29_start, -- начальное значение для attr_29
    3    AS attr_29_num    -- количество итераций в attr_29
),
  attr29_iter (n) AS
(
  SELECT 0
  UNION ALL
  SELECT n + 1 FROM attr29_iter, param WHERE n < attr_29_num -1
),
 attr_7_iter (n) AS
(
  SELECT 0
  UNION ALL
  SELECT n + 1 FROM attr_7_iter, param WHERE n < attr_7_num -1
),
  gen_inc AS
(
  SELECT i7.n as inc7, i29.n as inc29
    FROM attr_7_iter i7, attr29_iter i29
)
SELECT p.product_id, p.product_price, p.product_old_price, attr_7_start + inc7 AS attr_7, attr_29_start + inc29 AS attr_29
  FROM gen_inc, param, product p, category c
  WHERE p.product_id = c.product_id
    AND c.category_id NOT IN (214, 221, 220, 217, 216, 215, 48, 42, 40, 45, 46, 44, 50, 41, 43, 31, 178, 89, 47, 179, 177, 120, 121, 59, 58, 32, 37, 56, 53, 54, 55, 29, 28, 30, 176, 237, 113, 116, 175, 114, 196, 195, 197, 218, 219, 33, 93, 92, 91, 81, 90)
  ORDER BY 1, 4, 5
;