Quote from Olga Beatriz Rojas on August 5, 2020, 5:03 pmHola a todos, necesito buscar y contar caracteres distintos en una tabla y no se con que comando o función realizar, si me pueden ayudar.
Hola a todos, necesito buscar y contar caracteres distintos en una tabla y no se con que comando o función realizar, si me pueden ayudar.
Uploaded files:
Quote from Olga Beatriz Rojas on August 5, 2020, 5:07 pmEn excel se puede realizar, pude conectar a visualneo win con la sugerencia de ustedes, pero no se como visualizarlo
En excel se puede realizar, pude conectar a visualneo win con la sugerencia de ustedes, pero no se como visualizarlo
Quote from fjmangas on August 7, 2020, 9:25 amBuenos días Olga:
Si me cuentas un poco de qué va tu aplicación a lo mejor puedo ayudarte. Veo la foto de la tabla pero no me da información sobre lo que quieres hacer.
Creo que puedes acceder a mi email, pero yo no he podido acceder al tuyo.
Espero noticias
Francisco Javier
Buenos días Olga:
Si me cuentas un poco de qué va tu aplicación a lo mejor puedo ayudarte. Veo la foto de la tabla pero no me da información sobre lo que quieres hacer.
Creo que puedes acceder a mi email, pero yo no he podido acceder al tuyo.
Espero noticias
Francisco Javier
Quote from Vadim on August 7, 2020, 9:55 am@olga-beatriz-rojas
For example, one field (column) of the table. A special variable is used [ID.Table. $ RecCount]
https://neodbprohelp.visualneo.com/SpecialVariables.htmlYou can repeat this code for other columns using a loop.
dbpFieldToVar "ID" "TableName" "FIELD" "[Field]" "Delimiter=#;SkipBlanks=Yes;NoDuplicates=Yes;DelimiterInContext=Leave"
StrParse "[Field]" "#" "[Array]" "[Count]"
Loop "1" "[Count]" "[i]"
dbpQuery "ID" "TableName" "FIELD = [#34][Array[i]][#34]"
SetVar "[Sum_[Array[i]]]" "[ID.TableName.$RecCount]"
EndLoop
AlertBox "" "finish!"See the result in the debugger in variables starting with the prefix "Sum_"
P.S.: So that the code does not affect the appearance of the table, you can make a blind copy of it and search in it.
For example, one field (column) of the table. A special variable is used [ID.Table. $ RecCount]
https://neodbprohelp.visualneo.com/SpecialVariables.html
You can repeat this code for other columns using a loop.
dbpFieldToVar "ID" "TableName" "FIELD" "[Field]" "Delimiter=#;SkipBlanks=Yes;NoDuplicates=Yes;DelimiterInContext=Leave"
StrParse "[Field]" "#" "[Array]" "[Count]"
Loop "1" "[Count]" "[i]"
dbpQuery "ID" "TableName" "FIELD = [#34][Array[i]][#34]"
SetVar "[Sum_[Array[i]]]" "[ID.TableName.$RecCount]"
EndLoop
AlertBox "" "finish!"
See the result in the debugger in variables starting with the prefix "Sum_"
P.S.: So that the code does not affect the appearance of the table, you can make a blind copy of it and search in it.
Quote from Vadim on August 7, 2020, 11:39 amHere's another way:
dbpFieldToVar "ID" "TableName" "FIELD" "[Field]" "Delimiter=#;SkipBlanks=Yes;NoDuplicates=No;DelimiterInContext=Leave"
StrParse "[Field]" "#" "[Array]" "[Count]"
Loop "1" "[Count]" "[i]"
IfEx "[Array[i]] <> [#34][#34] AND [Array[i]] <> [Tmp]"
SetVar "[Tmp]" "[Array[i]]"
Loop "1" "[Count]" "[j]"
SearchStr "[Tmp]" "[Array[j]]" "[ResultSearch]" ""
If "[ResultSearch]" "<>" "0"
SetVar "[Sum_[Array[i]]]" "[Sum_[Array[i]]]+1"
EndIF
EndLoop
EndIF
EndLoop
AlertBox "" "finish!"See the result in the debugger in variables starting with the prefix "Sum_"
Here's another way:
dbpFieldToVar "ID" "TableName" "FIELD" "[Field]" "Delimiter=#;SkipBlanks=Yes;NoDuplicates=No;DelimiterInContext=Leave"
StrParse "[Field]" "#" "[Array]" "[Count]"
Loop "1" "[Count]" "[i]"
IfEx "[Array[i]] <> [#34][#34] AND [Array[i]] <> [Tmp]"
SetVar "[Tmp]" "[Array[i]]"
Loop "1" "[Count]" "[j]"
SearchStr "[Tmp]" "[Array[j]]" "[ResultSearch]" ""
If "[ResultSearch]" "<>" "0"
SetVar "[Sum_[Array[i]]]" "[Sum_[Array[i]]]+1"
EndIF
EndLoop
EndIF
EndLoop
AlertBox "" "finish!"
See the result in the debugger in variables starting with the prefix "Sum_"