Need support on a simple topics

[ENG_Be]

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

[PhilipMannering]

You need the Text-to-Columns Tool and split on a space. You can then use the function TrimLeft([Field3], '0') to remove the leading zeros in a Formula Tool.

[ENG_Be]

Do you have an example to share ? to be sure to understand the topic ? Thansks in adavance.

[PhilipMannering]

Sure, something like this:

[PhilipMannering]

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,

[ENG_Be]

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 .

[ENG_Be]

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.