Morning,
I need assistance with converting string to number. In my trailer row I have the record count.
I need the count field to be right justified, padded with zeros (8). ex.00000732
I originally had right(PadLeft(ToString([Count]), 8, "0"),8) which worked when i didn't need it separated by commas. Now I need my trailer row to be comma separated instead of one string. Thanks in advance
Before:ZZZQUESBIO2016021900000272
I need it to look like this ZZZ,QUES,BIO,20160219,00000272
Solved! Go to Solution.
Perfect!
Hello,
i have a field with sales volumes such as 2,500 which is set as string when alteryx imports the input file. when i use the select tool and convert the field to a double it cuts the figures at the comma so the 2,300 becomes 2. I need to summarise and do calculations so can't keep the field as a string. How do i correctly convert the field to an integer?