Skip to the content ForoHackers
Log inJoin

注文番号のゼロ、表計算に入れた瞬間に退職した

Data engineeringTesting
#7344 · · Quote · Report

小さい伝票を表計算に入れたら、注文番号"007"と"7"が同じ7になりました。前者は名刺、後者は猫の写真です。名刺の注文に猫が混ざる前に何とかしたい。三桁で表示する設定にすれば帰ってくる?

#7521 · · Quote · Report

Formatting both sevens as three digits will give you two 007s. Have you still got the original file? Tell the import the ticket column is text before it decides what the numbers are.

#7522 · · Quote · Report

元のファイルを文字列で読み直したら、別々の番号に戻りました。猫は無事です。名刺の方にはちょっと残念なお知らせかもしれない。

You are not logged in, so this goes up anonymously: no account, no name and no address is stored with it, and it may carry no link and no image. Log in or join to post under your name. Our web server's logs keep the address and time of every request for up to 14 days; to keep yours out of them, use Tor. To reach the staff in confidence, use the drop. Sign as a returning source (a key kept only in this browser)

Sending takes a few seconds here: your browser first works out a proof of work against spam.

Reply