Need support on a simple topics

Question

I would like to know how to be able to do the excel function in Alteryx Designer Repeat space before a value to be able to créer a txt.file

example : maxi range 48. below 0 before the amount should be space

202303123456 123456 0000000000000000000012344,67

Thanks in advance for your support.

here the result

12_6_6_24

ENG_Be · Answer

the original data came from a file that i create and redoo the template for an automatic upload but to respect the format and range accepted by SAP so DATe, sender,reveiver and amount should be in the final colum create via formulas to export in a txt.file at the end. expect i was more clear in my explanations, i very thank to you for your understanding.

ENG_Be · Answer

ok i undestand. in reallity i create a formula to do so, but space is never recognize and i need to respect a range

yes here are what i've done. base on different colums i have a need to recreate the final data which were created in a txt file to be upload by SAP system .

philipmannering · Answer

If you need to format your fields (convert to date or number) you can do so with the Select Tool or Formula Tool. Example attached,

Split on space.yxmd