[SOLVED] Convert String Attribute to Int Attribute? (No not the atof() expr)

[bentraje]

Hi,

Is there a way I can change the string attribute to an int attribute.

For example, base data is

BEFORE
ptnum, name
1,  joint_a_sel,
2, joint_b_sel,
3, joint_d_sel,
4, joint_a_sel,
5, joint_c_sel,

resulting data would be like

AFTER
ptnum, name, name_int
1,  joint_a_sel, 1
2, joint_b_sel, 2
3, joint_d_sel, 4
4, joint_a_sel, 1
5, joint_c_sel, 3

I'm not sure what's the proper nomenclature for this task but hopefully the before and after makes it clear.

Is there a way around this?

P.S. AFAIK, the atof() expression is only for strings that already looks like a number but is labelled as a string.

Edited November 19, 2021 by bentraje

[Aizatulin]

Hi,

a quick and dirty way:

push all strings into one array (once per string) and return index foreach string.

string_to_number.hipnc

[bentraje]

Hi @Aizatulin

Thanks for the illustration file. Works as expected.
Learned about find and push expressions