Hi all, I am quite new to Alteryx. I am trying to remove the first character of one column, it is currently a string now.
So ex.
111a
112b
113c
I want to make it so that it'll be
RowID
11a
12b
13c
Solved! Go to Solution.
Your explanation is greatly appreciated. I used this after trying all the various tiles and formulas, which did not work, but this was PERFECT!
if all you need to do is remove the first character, a substring would be the simplest way
substring([FieldName],1,999999)
choose an appropriate length to make sure you get everything, i.e. make sure your field isn't 100000000 characters long for example.
substring in alteryx starts at 0, which is why we tell it 1 as the starting position in the substring formula. then it skips the first letter and take everything after it.
it's the same thing in excel, mid([Cell],2,99999999) would get you there the same way. except that excel "starts" counting at 1, so we put 2 in the mid() formula to skip the first character
Thank you so much for clarifying this!!!!!!