Utilizzo di Char per confrontare valori numerici e caratteriCIAO,
È possibile confrontare valori numerici e caratteri?
Voglio confrontare due colonne (valori identici o diversi). Una colonna ha una data numerica e una ha una data di carattere e poiché ho bisogno di confrontare solo parti di essa, voglio usare la sottostringa. Lo script seguente viene eseguito, ma non mi dà il risultato corretto poiché tutto sembra essere diverso (il che non è il caso). Sto usando Char sbagliato?
If( Substr( Char( :Name( "Date/Time of Specimen Collection" ) ), 1, 10 ) == Substr( :Name( "Start Date/Time of Visit" ), 1, 10 ),
"identical",
"different"
)
So di poter cambiare il formato di "Data/ora della raccolta dei campioni", ma preferisco non farlo perché complicherebbe altre parti del mio copione.
grazie in anticipo
ScriptingRi: Utilizzo di Char per confrontare valori numerici e caratteriPer capire cosa sta succedendo, crea una colonna temporanea con
Char( :Name( "Date/Time of Specimen Collection" ) )
come la formula. Probabilmente dovrai usare la funzione format(...) (invece di char(...)) per specificare l'esatto formato data-ora di cui hai bisogno per ottenere tutti i valori ei caratteri separatori corretti. Puoi vedere i nomi dei formati disponibili quando usi la finestra di dialogo delle proprietà della colonna e guardi la sezione formato...data.
Ri: Utilizzo di Char per confrontare valori numerici e caratteriCapisco il tuo punto. Tuttavia, non riesco a farlo bene usando il formato.
C'è comunque di farlo senza creare colonne extra?
Ri: Utilizzo di Char per confrontare valori numerici e caratteriSÌ. Qual è il formato della data del carattere?
Ri: Utilizzo di Char per confrontare valori numerici e caratteriNello snip della tabella allegata sto cercando di confrontare la parte della data della colonna "Data/ora della raccolta del campione" (numerica, aaa-mm-ggThh:mm:ss) con la colonna "Data/ora di inizio della visita" (carattere , nominale)
Esiste una funzione che consente a jmp di vedere i valori numerici come caratteri (formattati come una data ovviamente) in modo da poter utilizzare la sottostringa per la parte relativa alla data?
Ri: Utilizzo di Char per confrontare valori numerici e caratteri
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.Usando la funzione format(); la data numerica è in anno-mese-giorno per il 7 febbraio; il formato dei caratteri è in giorno/mese/anno.
Ri: Utilizzo di Char per confrontare valori numerici e caratteriPotresti aver bisogno di questo formato:
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.il formato T è uno standard ISO.
Ri: Utilizzo di Char per confrontare valori numerici e caratteriO anche questo:
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.Non è necessario substr per il formato aaa-mm-gg; restituisce già solo i 10 caratteri necessari.
Ri: Utilizzo di Char per confrontare valori numerici e caratteriGrazie mille - ci proverò 
