Char を使用して数値と文字の値を比較するやあ、
数値と文字の値を比較することはできますか?
2 つの列 (同一または異なる値) を比較したい。 1 つの列には数値の日付があり、もう 1 つの列には文字の日付があり、その一部のみを比較する必要があるため、部分文字列を使用したいと考えています。 以下のスクリプトは実行されますが、すべてが異なっているように見えるため、正しい結果が得られません (そうではありません)。 Char を間違って使用していますか?
If( Substr( Char( :Name( "Date/Time of Specimen Collection" ) ), 1, 10 ) == Substr( :Name( "Start Date/Time of Visit" ), 1, 10 ),
"identical",
"different"
)
「標本収集の日付/時刻」の形式を変更できることはわかっていますが、スクリプトの他の部分が複雑になるため、変更したくありません。
前もって感謝します
スクリプティングRe: Char を使用して数値と文字の値を比較する何が起こっているのかを理解するために、一時的な列を作成します
Char( :Name( "Date/Time of Specimen Collection" ) )
式として。 おそらく、(char(...) の代わりに) format(...) 関数を使用して、すべての値と区切り文字を正しく取得するために必要な正確な日時形式を指定する必要があります。 列のプロパティ ダイアログを使用して format...date セクションを見ると、使用可能な形式名を確認できます。
Re: Char を使用して数値と文字の値を比較するあなたの言ってる事がわかります。 ただし、フォーマットを使用して正しく取得できないようです。
余分な列を作成せずにこれを行う方法はありますか?
Re: Char を使用して数値と文字の値を比較するはい。 文字の日付の形式は何ですか?
Re: Char を使用して数値と文字の値を比較する添付の表の抜粋では、「標本収集の日付/時間」列の日付部分 (数値、yyy-mm-ddThh:mm:ss) と「訪問の開始日/時間」列 (文字) を比較しようとしています。 、公称)
日付部分に部分文字列を使用できるように、jmpが数値を文字（もちろん日付としてフォーマット）として表示できるようにする機能はありますか？
Re: Char を使用して数値と文字の値を比較する
Using the format() function; the numeric date is in year-month-day for 7 February; the character format is in day/month/year.Using the format() function; the numeric date is in year-month-day for 7 February; the character format is in day/month/year.Using the format() function; the numeric date is in year-month-day for 7 February; the character format is in day/month/year.Using the format() function; the numeric date is in year-month-day for 7 February; the character format is in day/month/year.Using the format() function; the numeric date is in year-month-day for 7 February; the character format is in day/month/year.Using the format() function; the numeric date is in year-month-day for 7 February; the character format is in day/month/year.Using the format() function; the numeric date is in year-month-day for 7 February; the character format is in day/month/year.Using the format() function; the numeric date is in year-month-day for 7 February; the character format is in day/month/year.Using the format() function; the numeric date is in year-month-day for 7 February; the character format is in day/month/year.Using the format() function; the numeric date is in year-month-day for 7 February; the character format is in day/month/year.Using the format() function; the numeric date is in year-month-day for 7 February; the character format is in day/month/year.Using the format() function; the numeric date is in year-month-day for 7 February; the character format is in day/month/year.Using the format() function; the numeric date is in year-month-day for 7 February; the character format is in day/month/year.Using the format() function; the numeric date is in year-month-day for 7 February; the character format is in day/month/year.Using the format() function; the numeric date is in year-month-day for 7 February; the character format is in day/month/year.Using the format() function; the numeric date is in year-month-day for 7 February; the character format is in day/month/year.Using the format() function; the numeric date is in year-month-day for 7 February; the character format is in day/month/year.Using the format() function; the numeric date is in year-month-day for 7 February; the character format is in day/month/year.Using the format() function; the numeric date is in year-month-day for 7 February; the character format is in day/month/year.Using the format() function; the numeric date is in year-month-day for 7 February; the character format is in day/month/year.Using the format() function; the numeric date is in year-month-day for 7 February; the character format is in day/month/year.Using the format() function; the numeric date is in year-month-day for 7 February; the character format is in day/month/year.Using the format() function; the numeric date is in year-month-day for 7 February; the character format is in day/month/year.Using the format() function; the numeric date is in year-month-day for 7 February; the character format is in day/month/year.Using the format() function; the numeric date is in year-month-day for 7 February; the character format is in day/month/year.format() 関数の使用;数値の日付は、2 月 7 日の年月日です。文字形式は日/月/年です。
Re: Char を使用して数値と文字の値を比較する次の形式が必要になる場合があります。
the T format is an ISO standard.the T format is an ISO standard.the T format is an ISO standard.the T format is an ISO standard.the T format is an ISO standard.the T format is an ISO standard.the T format is an ISO standard.the T format is an ISO standard.the T format is an ISO standard.the T format is an ISO standard.the T format is an ISO standard.the T format is an ISO standard.the T format is an ISO standard.the T format is an ISO standard.the T format is an ISO standard.the T format is an ISO standard.the T format is an ISO standard.the T format is an ISO standard.T 形式は ISO 標準です。
Re: Char を使用して数値と文字の値を比較するまたはこれでも：
You don't need substr for the yyy-mm-dd format; it already returns just the 10 characters you need.You don't need substr for the yyy-mm-dd format; it already returns just the 10 characters you need.You don't need substr for the yyy-mm-dd format; it already returns just the 10 characters you need.You don't need substr for the yyy-mm-dd format; it already returns just the 10 characters you need.You don't need substr for the yyy-mm-dd format; it already returns just the 10 characters you need.You don't need substr for the yyy-mm-dd format; it already returns just the 10 characters you need.You don't need substr for the yyy-mm-dd format; it already returns just the 10 characters you need.You don't need substr for the yyy-mm-dd format; it already returns just the 10 characters you need.You don't need substr for the yyy-mm-dd format; it already returns just the 10 characters you need.You don't need substr for the yyy-mm-dd format; it already returns just the 10 characters you need.yyy-mm-dd 形式の場合、substr は必要ありません。必要な 10 文字だけが既に返されています。
Re: Char を使用して数値と文字の値を比較するどうもありがとう - 私はそれを試してみます:)
